Page 199 - BSIT Course Syllabus (First Sem 2020-2021)

be able to: Presentation) 1. Identify and 6th week
1. identify basic A. ER Model Presentation explain the
concepts of ER B. Business Rule Modules components of an
model; C. Naming Objects Demonstration/ ER model.
2. familiarize entity D. Attributes Simulation Learning
types; E. Entity Relationships Guide Laboratory
3. recognize a. One to One Activity 4
relationships in b. One to Many Computer/La Creation of ERD.
creating an ER c. Many to Many ptop/mobile Student will be
design; and F. ER Diagram phone given problems
4. design an ERD. and they will
construct a model.
6 After the completion of VI. Introduction to Discussion Online Lecture Laboratory Before the
the unit, the students will Structured Query Learning (PowerPoint Activity 5 end of week
be able to: Language Presentation Presentation) 6th week
1. define the basics of 1. Installation of
database functions of A. Basic MySQL Demonstration/ Modules technology and
MySQL; and Functions Simulation familiarization of
2. apply basic functions B. Data Types Learning UI.
of MySQL C. Primary/ Secondary Guide
Key 2. Simple queries
D. Three main parts of Computer/ practice.
query Laptop/
mobile 3. Creation of
phone Queries: SQL
View in MS
Access

V02-2020-07-01