ICT702 Introduction to Database Design

Grad Cert IS                          Core

Database management, design and development serve as the foundation of the modern business world and information society. Information that is collected from the customers, the sales revenues that are gathered from the business competitors, the profit and loss that are generated and many more forms of data are required to be stored in a secured, efficient and accessible place, this is called a database. A well-designed database will fundamentally change the decision-making process, data communication process and front-end user experience. Therefore, the design of the database is crucial to conquer the concerns of data collection, data storage and data analysis.
This subject provides an overall understanding of database design terminology, database design strategy, database structure and relationships, and level of the data integrity for each database. By completing this subject, students will be able to design a basic relationship database, refine the database structure, integrate the business needs with the database design objectives and implement the database by using a database management system and structured queried language (SQL) Server environments.

Prerequisites

Nil