DATA AND INFORMATION MANAGEMENT (4 Credits)

Learning Outcomes:

On successful completion of this Course, students will be able to: LO1 – Describe the concept of data and information management as suitable with Database System Development Life Cycle and database design methodologies; LO2 – Explain database design methodology, terminologies, and new concept of database; LO3 – Design database which includes conceptual, logical, and physical based on Database System Development Lifecycle; LO4 – Create Database using Structured Data Model.

Topics:

1. Application Design;
2. Monitoring and Tuning the Operational System and Denormalization;
3. Entity Relationship Modeling;
4. Relational vs Graph Database Implementation;
5. Methodology – Logical Database Design;
6. Project Presentation Part 1;
7. Relationships and Unique Identifier;
8. Methodology – Conceptual Database Design;
9. DBMS Selection;
10. Identifying Entities, Attributes, Relationship and Unique Identifier;
11. Distributed Database;
12. Conceptual ERD;
13. Relational vs Non-Relational Database;
14. Introduction to Big Data;
15. Prototyping;
16. Entities, Attributes, and Super/Subtypes;
17. Physical Database Realization;
18. Database Development Project;
19. Project Presentation Part 2;
20. Logical ERD; Denormalization;
21. Non Relational Database;
22. Methodology – Physical Database Design.