- At the end of the Course students should be able to:
- Explain what a Database System is, and be able to identify its characteristics and
- applications, Explain the different models of database,
- Design Entity Relationship models from specifications and interpret them into relational tables,
- Write SQL statements for data creation and manipulation purposes,
- Describe how to optimize databases to the most efficient form,
- Distinguish and use relational model and relational algebra,
- Identify and fix the possible problems that may occur in securing data
Fundamentals of Database Management System Course Module (Course Code Department based
Introduction Database a shared collection of logically related data and its description, designed to meet the information needs of an organization. We now examine the definition of a database so that you can understand the concept fully. The database is a single, possibly large repository of data that can be used simultaneously by many departments and users. Instead of disconnected files with redundant data, all data items are integrated with a minimum amount of duplication. The database is no longer owned by one department but is a shared corporate resource. The database holds not only the organization‘s operational data, but also a description of this data. For this reason, a database is also defined as a self-describing collection of integrated records. The description of the data is known as the system catalog (or data dictionary or metadata—the ―data about data‖).