Page 32 - BSIT Course Syllabus (2019-2020)

3. SQL search
queries using
phpMyAdmin
Structure and
Queries
After the completion of the VIII. Storage System & File Lecture Reference Book Lecture Activity:
chapter, students should Structure 1. Quiz
be able to: 1. Storage System Reporting Presentation
1. Understand how files are - Primary Storage Graphics Laboratory Activity:
stored in the database - Secondary Storage Discussion 1. Create Entity-
2. Understand the different - Tertiary Storage Whiteboard Relationship model
structures of database. 1.2. Memory Hierarchy Question and Answer of tables on
1.3. Magnetic Disks Marker PhpMyAdmin
4 6 1.4. Redundant Array of Brainstorming
Independent Disks Laboratory Exercise
2. File Structure Class Demonstration
- File Organization
- Heap File Organization Laboratory Exercise
- Sequential File Organization
- Hash File Organization Observation
- Clustered File Organization
2.2. File Operations
After the completion of the IX. Indexing and Hashing Lecture Reference Book Lecture Activity:
chapter, students should be 1. Indexing 1. Quiz
able to: - Dense Index Reporting Presentation
1. Understand the use of - Sparse Index Graphics
Index. - Multilevel Index Discussion
4 2. Learn the 3 types of Index 2. Hashing Whiteboard
3. Understand the use of - Hash Organization Question and Answer
Hashing. - Static Hashing Marker
4. Learn the 2 types of - Bucket Overflow Brainstorming
Hashing. - Dynamic Hashing
- Organization
After the completion of the X. Database Security Lecture Reference Book Lecture Activity:
chapter, student should be 1. Database Security Best 1. Quiz
able to: Practices Reporting Presentation
2
1. Understand the 7 - Ensure Physical Database Graphics
Database Security Best Security Discussion
Practices. Whiteboard

V01-2018-07-17