BCT2204 Database Systems

This course introduces students to the concepts and techniques necessary to develop conceptual and physical data models, methods and techniques appropriate for solving problem, and ability to select and implement appropriate solution that reflects all suitable database constraints.

Course Objectives
This course focuses on equipping students with knowledge and skills required to:

• Apply the theoretical foundation of relational databases and query languages to create SQL data structure definitions and queries that meet specific business needs
• Identify and select database tools needed to develop database applications
• Create relational database application following the standard system design and data modeling steps
• Evaluate alternative internal schema structures and create indices for efficient database operation
• Apply database application development methodology to a major real-world project

Learning Outcomes
Upon successful completion of the course, students shall be able to:

• Describe how computer engineering uses or benefits from database systems and information management 
• Categorize data models, Compare and contrast the basic principles of the relational data model and those of the object-oriented model as they apply to computer engineering applications
• Demonstrate the successful formulation of queries in the relational algebra and queries in the tuple relational calculus 
• Demonstrate the ability to embed object-oriented queries into an appropriate stand-alone programming language 
• Demonstrate the ability to transform a relation into a prescribed normal form 
• Demonstrate the ability to apply suitable ideas on failure and recovery to an application taken from computer engineering. 
• Compare and contrast the different approaches to distributed concurrency control. 
• Explain how physical database design affects database transaction efficiency.
• Design and implement a database system.