Course description
The overall objective of this course is to equip students with the theory and basic skills necessary for designing and implementing relational database systems.
Required text
Textbook: Database Systems - A PRACTICAL APPROACH TO DESIGN, IMPLEMENTATION, AND MANAGEMENT, 5th edition, Pearson, 2010. Authors: Thomas Connolly & Carolyn Begg.
Course content
• Introduction to Databases
• Introduction to Databases
• Database Environment & Architecture
• Relational Model
• Relational Algebra
• Structured Query Language (SQL)
• Entity-Relationship Modeling
• Normalization
• Security and Administration
• Semi-Structured Data and XML
Learning outcomes
• Explain the role and importance of database systems in organizations
• Demonstrate understanding of key concepts and theories relevant to the Relational Data Model and Relational Schema
• Develop basic Relational database schemas using ER modeling and Normalization techniques
• Design and execute SQL queries and commands to interrogate database relations and implement specified business constraints
• Summarize legal and ethical issues in data management.
Course ID: MIS 309
| Credit hours | Theory | Practical | Laboratory | Lecture | Studio | Contact hours | Pre-requisite | 3 | 3 | 1 | 4 | MIS 206 |
|---|
