IS3201 Enterprise Database Management Systems

Enterprise database management systems are the core of all information systems capabilities. The course provides the foundational knowledge, language, and capabilities to create, operate and manage enterprise-level data management systems. Students will learn the essential activities of how to store, retrieve, manage, and control data using a relational database management system. They not only will learn how to build a database application using modern database tools, and but also how to deploy database technology in a larger, organizational context to support problem solving. Further, by the time students have completed the course, they will understand the major steps required to manage complex database projects. Prerequisites: None.

Lecture Hours

4

Lab Hours

2

Course Learning Outcomes

Upon completion of this course, students will be able to:

Database Fundamentals:

·      Explain the concept of Relational Database Management Systems (RDBMS) and its significance in modern data management.

·      Apply data modeling concepts to design effective database schemas that accurately represent real-world scenarios.

·      Analyze the architecture of databases, identifying key components and their functions in data storage and retrieval.

·      Utilize relational algebra to manipulate and query data within relational databases effectively.

Normalization:

·      Describe the First through Fifth Normal Forms and their significance in database design.

·      Identify functional dependencies within a dataset and apply normalization techniques to eliminate data redundancy and anomalies.

·      Execute the normalization process to transform unnormalized database schemas into normalized forms.

·      Demonstrate proficiency in normalization through practical exercises designed to reinforce understanding.

Entity-Relationship Modeling:

·      Create Entity-Relationship Diagrams (ERDs) to visually represent the structure of a database.

·      Define entities, attributes, and relationships within an ERD, ensuring accuracy and completeness.

·      Interpret cardinality and participation constraints to establish the nature of relationships between entities.

SQL and Query Optimization:

·      Utilize SQL fundamentals to retrieve, manipulate, and manage data stored in relational databases.

·      Formulate complex queries to extract specific information from relational databases efficiently.

·      Implement indexing and optimization techniques to enhance the performance of database queries.

Advanced Topics:

·      Implement security measures and access control mechanisms to protect sensitive data stored in databases.

·      Develop strategies for data backup and redundancy to ensure data integrity and availability in case of failures.

·      Compare and contrast NoSQL databases with traditional relational databases, evaluating their suitability for different types of applications.