Database Design and Management

Course Main Objective

This course aims to make students acquainted with the basic concepts of databases and their advantages and types and be explain methods of designing, building and managing databases.

Course Learning Outcomes

• 1. Knowledge and Comprehension
• 1.1Explain development of using databases in libraries and information centers along with highlighting the basic concepts of databases and their environment as well as the relational database model “RDM”.
• 2. Skills
• 2.1 Able to create database using the Microsoft Access program.
• 2.2 Use database management systems to manage databases in libraries and information centers.
• 3. Values
• 3.1 Bear collective responsibility in submitting the project.

Course Content:

• The basic concepts of databases- files- database environment.
• Traditional file processing system- its drawbacks- database system advantages- database system disadvantages- database structuring- database models and types.
• Databases in libraries and information center.
• Database design- stages of database design- file design- a database expected lifespan (system)- database management system.
• Creating databases using Microsoft Access 2016- a general introduction to Access- system interface- address bar- tab bar- group bar- file tab
• Tables
• Queries 
•  Forms
• Reports
• Database management

Textbook (s) 

Primary Sources:
Al-Arbani, Arwa. (2013). Basics of Databases. 3rded. Amman: Dar Alwarraq
Stewart Melart-(2015). Microsoft Access 2016: The Complete Guide.

Secondary Sources:
Al-Fodaiyl, Muhammad.A.M.A. (2016). Input Gaps in the Database and Protection of the Model System Used in Open University of Sudan. Palestinian Journal of Open Learning.

Course ID: COMP 452