Subject Code: ECP3076
Objective: 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.
Pre-Requisite: None
Credit Hours: 3
Contact Hours: 54 hours (lectures and tutorials)
Assessment: Assignment / Project: 15%
Test / Quiz: 15%
Tutorials: 5%
Industrial visit: 5%
Final Examination: 60%
References:
  • 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.

Course Contents

Learning Outcome of Subject (% of contribution)

At the completion of the subject, students should be able to perform the following tasks:

Programme Outcomes (% of contribution)