| Teaching Staff
|
|
| Language of Instruction |
Türkçe (Turkish) |
| Type Of Course |
Compulsory |
| Prerequisites |
- |
| Recommended Optional Programme Component |
|
| Course Objectives |
• Be familiar with database architecture
• Master the design of retrieval queries
• Master normalization principles
• Be familiar with the design of a relational database
• Be familiar with embedded SQL queries
|
| Course Content |
Provides fundamental knowledge of, and practical experience with, database concepts. Includes study of information concepts and the realization of those concepts using the relational data model. Practical experience gained designing and constructing data models and using SQL to interface to both multi-user DBMS packages and to desktop DBMS packages Access 2016. |
| Learning Outcomes (LO) |
1. Differentiate database systems from file systems by enumerating the features provided by database systems and describe each in both function and benefit.
2. Define the terminology, features, classifications, and characteristics embodied in database systems.
3. Analyze an information storage problem and derive an information model expressed in the form of an entity relation diagram and other optional analysis forms, such as a data dictionary.
4. Demonstrate an understanding of the relational data model.
5. Transform an information model into a relational database schema and to use a data definition language and/or utilities to implement the schema using a DBMS.
6. Formulate, using relational algebra, solutions to a broad range of query problems.
7. Formulate, using SQL, solutions to a broad range of query and data update problems.
8. Demonstrate an understanding of normalization theory and apply such knowledge to the normalization of a database.
9. Use an SQL interface of a multi-user relational DBMS package to create, secure, populate, maintain, and query a database.
10. Use a desktop database package to create, populate, maintain, and query a database.
11. Demonstrate a rudimentary understanding of programmatic interfaces to a database and be able to use the basic functions of one such interface.
|
| Mode of Delivery |
Face to face |
| Course Outline |
| Week |
Topics |
| 1. Week |
Introduction to DB Management |
| 2. Week |
Conceptual Design & Data Modeling using E-R Diagrams |
| 3. Week |
The Relational Model (& more ER) |
| 4. Week |
Conceptial design |
| 5. Week |
Physical design |
| 6. Week |
Normalization |
| 7. Week |
Mid term Exam |
| 8. Week |
Relational Algebra & Relational Calculus |
| 9. Week |
Access 2016 and its usage |
| 10. Week |
Introduction to Sql |
| 11. Week |
SQL: Select, Project, Join |
| 12. Week |
SQL: Intersect, Union, Except |
| 13. Week |
Data Manipulation Language |
| 14. Week |
Advanced Sql |
|
| Assessment |
| |
Percentage(%) |
| Mid-term (%) |
40 |
| Quizes (%) |
|
| Homeworks/Term papers (%) |
|
| Practice (%) |
|
| Labs (%) |
|
| Projects/Field Work (%) |
|
| Seminars/Workshops (%) |
|
| Final (%) |
60 |
| Other (%) |
|
| Total(%) |
100 |
|
| Course Book (s) and/or References |
Concepts of Database Management" (8th Ed) (ISBN: 1285427106) |
| Work Placement(s) |
|
| The Relationship between Program Qualifications (PQ) and Course Learning Outcomes (LO) |
| | PQ1 | PQ2 | PQ3 | PQ4 | PQ5 | PQ6 | PQ7 | PQ8 | PQ9 | PQ10 | PQ11 | PQ12 | PQ13 | PQ14 | LO1 | 5 | | 3 | 2 | | 2 | 5 | | | | | | | | LO2 | 5 | | | | | | | | | | | 2 | | | LO3 | 5 | | | | | | | | 1 | | | | | | LO4 | 5 | | | 4 | | | | 3 | | | | | | |
* Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |