COURSE OBJECTIVES

This course aims to make students:

  • Become familiar with database language and terminology
  • Explore the different database models
  • Understand the fundamentals of the Relational model
  • Become familiar with the Entity Relationship model and construct E-R Diagrams
  • Understand the concept of Normalization and normalize database tables
  • Understand and effectively use SQL commands to create and manipulate database objects
  • Explore current trends in database management

SEMESTER ASSIGNMENT

Students will be required to develop a database application utilizing the course concepts and techniques

COURSE OUTLINE

Overview of Database Systems: model, schema, instance. Database system vs. File systems. Data abstraction levels, database languages, system architecture. Classification of DBMS.  

Data Modeling: Entity-Relationship (ER) Model, Entities and Entity types, Relationship and Relationship type, Constraints, Weak Entity Types, ER, Diagrams. Semantic object model.

Process of Database Design: normalization, requirement analysis, conceptual database design, database schema design.  Database design using entity-relationship and semantic object models, database application design.  Terminology in Relational Data model, Integrity Constraints, Primitive Operations on Relations, Relational Algebra (RA), Relational Algebra Operations, Relational Completeness, Additional Operations on Relations. Foundations of relational implementation.

Structured Query Language (SQL): DML Features in SQL, DDL in SQL, updates in SQL, Views in SQL, Embedded SQL, Query-by-Example (QBE).  Concurrency, recovery and security issues.  Armstrong’s inference rules and minimum covers, normal forms.

Current Trends in Database Systems:  Client-Server database systems, Open Database connectivity (ODBC) standard, knowledge-Based Systems, Object-Based Systems, data warehousing and data mining concepts, Web databases.

RESOURCES

  • Software:
    • MySQL
    • MSSQL
    • Microsoft Access
    • Microsoft Visio
  • Books:
    • Coronel et al (2011). Database Systems: Design, Implementation, and Management. 9th Edition 
  • Useful Websites:
    • www.youtube.com
    • www.functionx.com