School of Engineering \ Industrial Engineering
Course Credit
ECTS Credit
Course Type
Instructional Language
Programs that can take the course
Industrial Engineering Bachelor's Degree Program
Introduction to database management. Database query, design, normalization, interface and report preparation topics are covered.
Textbook and / or References
Database Management Systems” by Raghu Ramakrishnan, J. Gehrke, 3rd Edition, McGraw- Hill
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 |
| Activities |
Number |
Weight (%) |
| Course Attendance/Participation |
- |
- |
| Laboratory |
- |
- |
| Application |
- |
- |
| Homework |
- |
- |
| Project |
1 |
20% |
| Presentation |
- |
- |
| Field Work |
- |
- |
| Internship |
- |
- |
| Course Boards |
- |
- |
| Quiz |
4 |
15% |
| Midterm Exam |
1 |
25% |
| Final Exam |
1 |
40% |
|
Total |
100% |
| Tentative ECTS-Workload Table |
| Activities |
Number/Weeks |
Duration (Hours) |
Workload |
| Course Hours (first 6 weeks) |
6 |
4 |
24 |
| Course Hours (last 6 weeks) |
6 |
3 |
18 |
| Laboratory |
- |
- |
- |
| Application |
- |
- |
- |
| Homework |
- |
- |
- |
| Project |
1 |
35 |
35 |
| Presentation |
- |
- |
- |
| Field Work |
- |
- |
- |
| Internship |
- |
- |
- |
| Course Boards |
- |
- |
- |
| Preparation for Quiz |
4 |
2 |
8 |
| Preparation for Midterm Exam |
1 |
20 |
20 |
| Final Exam |
1 |
2 |
2 |
| Preparation for Final Exam |
1 |
24 |
24 |
| Study Hours Out of Class (preliminary work, reinforcement, etc.) |
12 |
3 |
36 |
| Total Workload | | |
167 |
| Total Workload / 30 | | |
167 / 30 |
| | |
5.566667 |
| ECTS Credits of the Course | | |
6 |
|
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
|
|
|
|
|
|
|
|