Call us +265 111 755 333

Module/Course Description

Course Title: Management of Database Systems

Course Code: UU-COM-3000

Programme:

Credits: 12.00

Course Description:

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.

Learning Outcomes:

• 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

Prerequisites Categories: -

Typical Module duration: 4.0 Week(s)

Return

This site uses cookies and other tracking technologies to assist with navigation and your ability to provide feedback, analyse your use of our products and services, assist with our promotional and marketing efforts, and provide content from third parties Cookie Policy