ProgrammesModule: Management of Database Systems
Course Title: Management of Database Systems
Course Code: UU-COM-3000
Programme: Bachelor of Science (BSc) in Computer Science - MW - BL
Objectives of the Course:
• Examine databases, database management systems and their role in the organization.
• Follow historically the development of database management systems until present time.
• Analyze data models and data modeling techniques.
• Cover relational database design by converting a conceptual data model to a database schema.
• Explain normalization and use it to design normalized relational databases.
• Cover Structured Query Language’s (SQL), data definition (DDL), data manipulation (DML), and data control (DCL) components.
• Introduce data and database administration functions.
• Examine on-line transaction processing (OLTP) and its role in the business environment.
• Introduce business intelligence to include on-line analytic processing (OLAP), data warehousing, data mining.
• Explain the role of databases and database management systems in managing organizational data and information.
• Follow the historical development of database management systems and logical data models.
• See the role of information requirements specification processes in the broader systems analysis and design context.
• Distinguish between the basic approaches to data modeling techniques (i.e. object‐oriented data modeling, semantic data modeling, etc.)
• Use at least one conceptual data modeling technique (such as entity‐relationship modeling) to capture the information requirements for an enterprise domain.
• Design high‐quality relational databases.
• Explain the purpose and principles of normalizing a relational database structure and design a normalized relational database.
• Implement a relational database design using an industrial database management system, including the principles of data type selection and indexing.
• Use the data definition, data manipulation, and data control language components of SQL in the context of one widely use implementation of the language.
• Perform simple database administration tasks.
• Understand the concept of database transaction and apply it appropriately to an application context.
• Identify the role of databases and database management systems in the context of enterprise systems.
• Identify the difference between on‐line transaction processing (OLTP) and on‐line analytic processing (OLAP), and the relationship between these concepts and business intelligence, data warehousing and data mining.
Prerequisites: UU-ACG-1000, UU-MKT-2000, UU-MAN-2010, UU-BBA-2000, UU-ENG-1000, UU-ENG-1001, UU-ENG-1005, UU-COM-1000, UU-MTH-1000, UU-MTH-1005, UU-MTH-2000, UU-MTH-3000, UU-COM-1100, UU-COM-2000, UU-COM-2003, UU-BA-IND100, UU-FNT-103