Database Design
Introduction
The database field subject is used for how to use computers to store and manage large quantities of data. This course is intended to provide students with an understanding of the current theory and practice of database, which in turn will help them to fully appreciate their nature. The course also provides a solid technical overview of database systems, using a current database product as a case study. In addition to technical concerns, these include data independence, integrity, security, recovery, performance, database design principles, and database administration.
Objectives
The course will cover the principles and practical solutions for storage and retrieval of information using a computer system, and with an emphasis both on the use of relational database management systems.
At the completion of this course, students should be able to do the following:
Understand the role of a database and Database Management System in an organization.
Understand basic database concepts, including the structure and operation of the relational data model.
Construct simple and moderately advanced database queries using Structured Query Language (SQL).
Understand and successfully apply logical database design principles, including E-R diagrams and database normalization.
Design and implement a small database project using Microsoft Access.
Understand the role of the database administrator.