DATA AND INFORMATION MANAGEMENT (4 Credits)

Learning Outcomes:

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

Topics:

1. Database System Development Life Cycle
2. Database Development Project
3. Entities and Attributes
4. Entity Relationship Modeling
5. Relationships
6. Unique Identifier
7. Methodology – Conceptual Database Design
8. Entity Relationship Modeling
9. Methodology – Conceptual Database Design
10. Methodology – Logical Database Design (Mapping)
11. Methodology – Logical Database Design (Normalization)
12. Methodology – Physical Database Design
13. Methodology – Monitoring and Tuning the Operational System and Denormalization
14. Arcs, Hierarchies, and Recursive Modeling
15. Changes and Historical Modeling
16. Methodology – Logical Database Design (Mapping)
17. Project Presentation Part 1
18. Methodology – Logical Database Design (Normalization)
19. Methodology – DBMS Selection
20. Distributed Database
21. Methodology – Physical Database Design
22. Methodology – Application Design
23. Methodology – Prototyping
24. Methodology – Monitoring and Tuning The Operational System and Denormalization
25. Introduction to Big Data
26. Project Presentation Part 2