Introduction to Data base systems Instructor: Dr. Faisal Akkawi
Course Description:
This course is specially designed to present the fundamentals of database management and data organization. This concept includes the principles and methodologies of database design, database application development, normalization, referential integrity, security, relational database models, database implementation, and database languages. It gives the history about how the DBMS (Database management system) has evolved from old file system, about their importance in managing the large bodies of data, what database model can be used to implement them, what relational languages are used to provide the interface for DBMS, and also covers how the data are actually organized in the abstract data structures. Principles are applied in written assignments and a project using an SQL database system.
Course Objectives:
Introduce the fundamentals of database management and data organization
To design and implement database application
Managing the large bodies of data
Understand how the data are actually organized in the abstract data structures
Understand relational languages and how they are used to provide the interface for DBMS
Introduce database models
Desired Course Outcomes
The fundamentals of database management and data organization
Design and implement database application
Managing the large bodies of data
How data is organized in abstract data structures
Relational languages and how they are used to provide the interface for DBMS
_______________________________________________________________________________________
Artifacts:
StayHomeVideo_backupVersion.accdb
CIS317_Fall2007_Project_Description.pdf
The StayHomeVideo database creation project demonstrates a clear understanding of the class objectives. It involved everything from Database Design Using E-R Model to SQL queries and database application design. The fall2007_Project pdf describes the project and the Access 2007 database file is the final result.
Main Take-Away
The importance of organizing large bodies of data and an understanding of how they are managed and how the data are actually organized in the abstract data structures that can be queried with relational languages that provide the interface for DBMS.
Areas of Strength
Understanding and use of database query techniques for data retrieval.
Areas for Development
Could work with more advanced database systems such as Oracle.