To provide a basic understanding of the concepts and types of Computer Database, examine theoretical and pragmatic ideas underlying relational databases, and discuss certain other aspects of database systems - recovery, concurrency, security, and integrity. Upon completion of this course, the students should be able to outline architecture for a database system, define and manipulate data, and understands transactions process of database systems.
54 hours (lectures and tutorials)
Assignment / Project: 15%
Test / Quiz: 15%
Industrial visit: 5%
Final Examination: 60%
Peter Rob, Carlos Coronel, “Database Systems: Design, Implementation, and Management”, 9th Edition, Course Technology, 2011. (Textbook)
D. Kroenke, “Database Processing: Fundamentals, Design and Implementation”, Prentice Hall Business Publishing, 1997.
C. J. Date, “An Introduction to Database Systems”, 6th Edition, Addison Wesley, 1995.
Ramez Elmasri and Shamkant B. Navathe, “Fundamentals of Database Systems”, 2nd Edition, Benjamin/Cummings Publishing Co., 1994.
Connolly, T., Begg, C. & Strachan, A., “Database Systems: A Practical Approach to Design, Implementation and Management”, Addison-Wesley, 1999.
Details of Assignment:
Example: Title: Database System Design
Objective: To allow students to understand and implement a database system
Type: Systems design
Description: Students are provided with general business scenarios of which they are required to understand and design a database system that will serve the purpose of the scenario selected. Using selected industry standard SQL database software, the students are then required to implement the code to transfer their business rules and models into a functioning database that will be able to answer typical queries in their scenario.
Overview of Database Systems, Database Systems vs. File Systems, Various aspects of Database Systems, Terminology: model, schema, instance.
Three levels of data abstraction, Database Languages, System Architecture of a Database System, Classification of DBMS.
Entity-Relationship(ER) Model, Entities and Entity types, Relationship and Relationship type, Constraints, Weak Entity Types, ER Diagrams. Semantic object model.
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.
Amstrong’s Inference Rules and Minimum Covers, Normal Forms: First Normal Form, Second Normal Form, Third Normal Form, Boyce-Codd Normal Form
Trends In Database
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.
Learning Outcome of Subject (% of contribution)
At the completion of the subject, students should be able to perform the following tasks:
LO1 - Characterize the various types of computer database. (Cognitive - remembering, Level 1) - 22%
LO2 – Apply data modeling concepts and normalization technology in designing a good practice database. (Cognitive - applying, Level 3) - 25%
LO3 - Design a relational database using commands and functions of SQL. (Cognitive - creating, level 6) - 18%
LO4 – Demonstrate designing aspect of database system architecture and data manipulation. (Cognitive - understanding, Level 2) - 20%