Page 31 - BSIT Course Syllabus (2019-2020)
P. 31
be able to: 2. Armstrong’s Axioms Reporting Presentation 1. Normalize the
1. Understand normalization 3. Trivial Functional Dependency Graphics given table to its first
in tables. 4. First to Third Normal Form Discussion and second normal
2. Normalize tables from first 5. Boyce Codd Normal Form Whiteboard form
to third normal form and to Question and Answer Marker 2. Identify the
Boyce Codd normal form following tables in
Brainstorming Computer what normal form.
3. Quiz
Class Demonstration Laboratory Exercises
Laboratory Activity:
Laboratory Exercise 1. SQL Conditional
queries (AND, OR,
Observation NOT, BETWEEN,
ORDER BY)
After the completion of the VI. Joins Lecture Reference Book Lecture Activity:
chapter, students should 1. Cartesian Join 1. Discuss the
be able to: 2. Inner Join Reporting Presentation difference of all
1. Understand the concept 3. Left Outer Join Graphics kinds of Joins
of joins 4. Right Outer Join Discussion 2. Quiz
2. Use joins in tables 5. Full Outer Join Whiteboard
6. Self Join Question and Answer Laboratory Activity:
4 6 Marker 1. Connect tables
Brainstorming using the Join
Computer queries
Class Demonstration
Laboratory Exercises
Laboratory Exercise
Observation
2 3 MIDTERM EXAMINATION
After the completion of the VII. phpMyAdmin Overview Discussion Reference Book Laboratory Activity:
chapter, students should 1. Data Manipulation Language 1.Installation of
be able to: Class Demonstration Presentation XAMPP
1. Access and use Graphics 2. SQL making
9
phpMyAdmin mySQL Laboratory Exercise tables using
Computer phpMyAdmin
Observation Structure and
Laboratory Exercise Queries
V01-2018-07-17