Database Organization
Syllabus
Course Description
This course is specially designed to present the fundamentals of database management and data organization. This concepts includes the aspect of database design, database models, database languages and database system implementation. 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. It also covers written assignments, weekly quiz session and one programming project, which gives enough exposure to real filed implementation.
Students need the familiarity with basic data structure, computer organization, and high level (like C , C++) languages.
Course Content
- Introduction, and Setting Class Expectations
- Introduction to Database Processing
- Introduction to Database Development
- The Relational Model and Normalization
- Database Design Using Entity-Relationship model
- E-R Model
- Foundations of Relational Implementation
- Midterm Exam
- Structured Query Language
- The Semantic Object Model
- Database Design with Semantic Object Model
- Multi-User Database Processing
- Final Exam and Project Due
