DATA AND INFORMATION MANAGEMENT (4 Credits)

Learning Outcomes :

On successful completion of this course, student 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 :

Identifying Entities, Attributes, Relationship and Unique Identifier; Database Development Project; Conceptual ERD; Entities, Attributes, and Super/Subtypes; Logical ERD; Physical Database Realization; Relationships and Unique Identifier; Entity Relationship Modeling; Non Relational Database; Denormalization; Methodology – Conceptual Database Design; DBMS Selection; Distributed Database; Methodology – Logical Database Design; Project Presentation Part 1; Methodology – Physical Database Design; Relational vs Non-Relational Database; Relational vs Graph Database Implementation; Database Implementation; Application Design; Prototyping; Monitoring and Tuning the Operational System and Denormalization; Introduction to Big Data; Project Presentation Part 2