School of Engineering \ Industrial Engineering
Course Credit
ECTS Credit
Course Type
Instructional Language
Programs that can take the course
Introduction to database management. Database query, design, normalization, interface and report preparation topics are covered.
Textbook and / or References
1. “Database Management Systems” by Raghu Ramakrishnan, J. Gehrke, 3rd Edition, McGraw- Hill
2. "Database Processing: Fundamentals, Design, and Implementation (15th Edition/ 40th Anniversary Edition)" by David M. Kroenke, David Auer, Scott L. Vandenberg, Robert C. Yoder. Pearson
Introduction to database management. Provide information on database querying, design, normalization, interface and report preparation
1. Ability to understand database and database management concepts
2. Ability to learn database design
3. Ability to learn and apply database query (SQL)
4. Ability to develop Database interface and output report development
5. To apply the theoretical content of the course through the project
6. Ability to express results written and orally
7. Ability to work within a project team
Week 1: Introduction to Database Systems
Week 2: Concepts in Database Design
Week 3: Entity Relationship Modeling
Week 4: Entity Relationship Modeling
Week 5: Normalization
Week 6: Normalization
Week 7: SQL Queries
Week 8: SQL Queries
Week 9: SQL Data Definition and Data Processing Commands
Week 10: SQL Data Definition and Data Processing Commands
Week 11: Creating a View, Procedure and Trigger
Week 12: Creating a View, Procedure and Trigger
Tentative Assesment Methods
• Midterm 25 %
• Final 40 %
• Project 20 %
• Quiz 15 %
|
Program Outcome
*
|
| 1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
|
Course Outcome
|
|---|
| 1 |
|
|
|
B
|
|
C
|
|
|
|
|
|
|
|
| 2 |
|
|
|
B
|
|
C
|
|
|
|
|
|
|
|
| 3 |
|
|
|
B
|
|
C
|
|
|
|
|
|
|
|
| 4 |
|
|
|
B
|
|
C
|
|
|
|
|
|
|
|
| 5 |
|
|
|
|
|
C
|
|
|
|
|
|
|
|
| 6 |
|
|
|
|
|
C
|
A
|
|
|
|
|
|
|
| 7 |
|
|
|
|
|
A
|
|
|
|
|
|
|
|