Page 30 - BSIT Course Syllabus (2019-2020)

8. Specialization Laboratory Activity
9. Inheritance 1. Installation of
10. Codd’s 12 Rules mySQL Server and
Workbench
After the completion of the III. . Relational Data Model Lecture Reference Book Lecture Activity:
chapter, students should 1. Concepts 1. Differentiate the
be able to: 2. Constraints Reporting Presentation Entity-Relationship
1. Discuss the concepts and 3. Relational Algebra Graphics model and
constraints of relational data 4. Relational Model Discussion Relational Model
model; 4.1 Mapping Entity Whiteboard 2. Quiz
2. understand the relational 4.2 Mapping Relationship Question and Answer
4 3 algebra; and 4.3 Mapping weak entity Marker Laboratory Activity:
3. perform mapping on sets Brainstorming 1. Introduction to the
relational model 4.4 Mapping hierarchical Computer MySQL Terminal
entities Class Demonstration Interface
2. Database and
Laboratory Exercise Table creation using
MySQL
Observation
After the completion of the IV. SQL Overview Lecture Reference Book Lecture Activity:
chapter, students should 1. Data Definition Language 1 Discuss the
be able to: 2. Data Manipulation Language Discussion Presentation difference between
1. Differentiate data Graphics DDL and DML
definition language from Brainstorming 2. Give SQL
data manipulation language. Whiteboard statements that
2. Understand and use the Class Demonstration under DDL and
MySQL via Terminal Computer DML
Laboratory Exercise
2 12
Laboratory Exercises Laboratory Activity:
Observation 1. SQL making table
queries (Create,
Insert, Delete,
Update, Alter, Drop)
2. SQL search
queries (Select,
Where, Group by,
Order by)
After the completion of the V. Normalization Lecture Reference Book Lecture Activity:
4 3
chapter, students should 1. Functional Dependency

V01-2018-07-17