Course Code & Number
CMPE 232-O
Course Title
Relational Databases
Credit Hours/ ECTS Credits
(3+0+0) 3 TEDU Credits, 5 ECTS Credits
Type of Course:
Compulsory
Mode of Delivery:
Face-to-face
Language of Instruction:
English
Pre-requisite / Co-requisite::
Pre-requisites: CMPE 112
Co-requisites: NONE
Catalog Description
Database system concepts and architecture. Relational data model and SQL. Database normalization. File structures and indexing. Transaction processing and concurrency control.
Course Objectives
The objective of this course is to provide understanding of large scale data storage and management techniques using relational database systems. The course provides information on how to design and normalize a database for storing, modifying and querying data in an efficient manner using web enable compatible tools such as PHP and MYSQL.
Course Learning Outcomes
Upon succesful completion of this course, a student will be able to
1. Analyze a large scale data provider for designing a corresponding database
2. Normalize a given database for time and space efficiency
3. Implement a database design using MYSQL
4. Create, modify and query a database using SQL
5. Implement web based database management systems using PHP and MYSQL
6. Analyze a database system for efficient indexing
Learning Activities and Teaching Methods:
Telling/Explaining
Discussion/Debate
Questioning
Reading
Demonstrating
Problem Solving
Collaborating
Case Study/Scenarion Analysis
Oral Presentations/Reports
Assessment Methods and Criteria:
Test / Exam
Quiz
Case Studies / Homework
Presentation (Oral/Poster)
Assessment Methods and Criteria Others:
Required Reading
1. Elmasri, R. and S. Navathe (2007). Fundamentals of database systems. Boston, Pearson/Addison Wesley
Grading
Midterm 1 Exam - 10%
Midterm 2 Exam - 10%
Projects - 40%
Final Exam - 40%
Learning Activities and Teaching Methods Others:
Student Workload:
| Workload | Hrs |
|---|
| Debate | 10 hrs |
| Hands-on Work | 22 hrs |
| Oral Presentation | 10 hrs |
Course & Program Learning Outcome Matching:
