Faculty of Engineering and Natural Sciences · Industrial Engineering (English 30%) · Undergraduate
ECTS: 5 T+P+L: 3+0+0 Departmental Elective
Coordinator: Arş. Gör. Biset TOPRAK
Course Objective
To provide a solid understanding of relational database management systems. Students will be able to perform analysis, design and implementation processes while making an improvement in relational database management system.
Course Content
Database processing, fundamentals of relational realization, query languages,Data Modeling, normalization, databases and Internet Technology, managing multi-user databases, using MS SQL.
Course Learning Outcomes
- To understand the concept of database management system, its components and its importance in the IT world.
- To be able to design conceptual database (ER diagram) including constraints by analyzing a given job description.
- To be able to transform conceptual database design into logical table design.
- To be able to implement logical table design in a physical database environment (using SQL and using the tools of the database server).
- To be able to make necessary queries and other operations in business processes using SQL
- To be able to encode procedure/function and trigger using programming structures specific to SQL and database server system.
- To be able to use the necessary tools/media for setup, operating and accessing database servers.
- To be able to design and develop a database by working as a team for a specific job,
- Prepare the necessary documentation and presentation for the database project and make the presentation.
Core Area Distribution
(48) Computing%50 (52) Engineering and Engineering Trades%50
Teaching Methods
ExpressionQuestion-AnswerExercise and PracticeGuided PracticeGroup StudyProject Based Learning (Including Field Work)
Assessment & Evaluation
HomeworkPerformance Assignment ( Lab / Workshop / Field Work / Seminar / Presentation / Completion Study / ThesisProject / DesignTesting (Essay / Tests: True-Falls, multiple-choice, short answer, matching)
ECTS / Workload
| Activity | Quantity | Duration (h) | Total Workload |
|---|---|---|---|
| Course Duration (Including Exam Week) | 16 | 4 | 64 |
| Out of Class Study Period | 6 | 3 | 18 |
| Midterm | 1 | 2 | 2 |
| Quiz | 2 | 2 | 4 |
| Assignment | 4 | 8 | 32 |
| Practice | 2 | 20 | 40 |
| Final | 1 | 3 | 3 |
Course Schedule
| Week | Subject | Preparation |
|---|---|---|
| 1 | Introduction to Database Systems, Relational Data Model, Semi Structured, Data Model | DaaStrcuture, Algebra |
| 2 | Entity-Relationship Data Model | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 4.1, 4.2, 4.3, 4.4, 4.5, 4.6) |
| 3 | Introduction to Relational Databases, Functional Dependencies | (Ch. 2.4, 3.1, 3.2, 3.3, 3.4, 3.5) |
| 4 | Design of Relational Databases, Multivalued Dependencies | Ch. 3.6, 3.7 |
| 5 | Functional Dependencies and Multivalued Dependencies Revisited | Ch. 2.4, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7 |
| 6 | ERD implementations | Ch. 4.1, 4.2, 4.3, 4.4, 4.5, 4.6 |
| 7 | Introduction to SQL (Part I) | Ch. 6.1, 6.2, 6.3, 6.4.1, 6.4.2) |
| 8 | Midterm Exam | * |
| 9 | Introduction to SQL (Part II) | Ch. 5.2, 6.4, 6.5 |
| 10 | Introduction to SQL (Part III) | Ch. 6, 7 |
| 11 | SQL Programming: Embedded SQL, PSM (PL/SQL) | Ch. 9.3, 9.4 |
| 12 | Transactions, Views, Indexes | Ch. 6.6, 8.1, 8.2, 8.3, 8.4, 8.5 |
| 13 | Normalization | * |
| 14 | Normalization-2 | ** |
| 15 | Project | * |
| 16 | Final | * |