Code |
Name of the Course Unit |
Semester |
In-Class Hours (T+P) |
Credit |
ECTS Credit |
BIL309 |
DATABASE MANAGEMENT |
5 |
4 |
3 |
5 |
GENERAL INFORMATION |
Language of Instruction : |
Turkish |
Level of the Course Unit : |
BACHELOR'S DEGREE, TYY: + 6.Level, EQF-LLL: 6.Level, QF-EHEA: First Cycle |
Type of the Course : |
Elective |
Mode of Delivery of the Course Unit |
- |
Coordinator of the Course Unit |
Assist.Prof. AHMAD RESHAD NOORI |
Instructor(s) of the Course Unit |
|
Course Prerequisite |
No |
OBJECTIVES AND CONTENTS |
Objectives of the Course Unit: |
To teach the students defining entities and relationships, modelling attributes and constraints, normalizing data model, constructing physical database from data models, defining the basics of relational database systems, developing applications through SQL queries. |
Contents of the Course Unit: |
Defining Entities and Relationships, Modelling Attributes and Constraints, Normalizing Data Model, Constructing Physical Database From Data Models, Defining The Basics Of Relational Database Systems, Indexing, Developing Applications Through SQL Queries, Developing Oracle Applications. |
KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to) |
The students who take the course will be able to;
I. Define entities and relationships
II. Construct data models
III. Describe relational databases
IV. Construct physical databases
V. Design SQL queries
VI. Develop Oracle DBMS applications |
WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY |
Week |
Preparatory |
Topics(Subjects) |
Method |
1 |
- |
Importance of data, data management, and data management systems |
- |
2 |
- |
Defining the problem and gathering data |
- |
3 |
- |
Introduction to relational databases |
- |
4 |
- |
Relational database management systems |
- |
5 |
- |
Data Models |
- |
6 |
- |
Entity - Relationship Diagrams |
- |
7 |
- |
Data Modeling and Normalization |
- |
8 |
- |
MID-TERM EXAM |
- |
9 |
- |
SQL: Data Definition Language |
- |
10 |
- |
Simple SQL queries |
- |
11 |
- |
Built-in SQL functions |
- |
12 |
- |
Complex SQL queries |
- |
13 |
- |
Triggers |
- |
14 |
- |
Indexes and how to use them |
- |
15 |
- |
Other data models: XML, Text, and multimedia |
- |
16 |
- |
FINAL EXAM |
- |
17 |
- |
FINAL EXAM |
- |
SOURCE MATERIALS & RECOMMENDED READING |
1. Database Systems using Oracle: A Simplified Guide to SQL and PL/SQL, Nilesh Shah, Pearson Prentice Hall, 2005
2. Database Systems: A Practical Approach to Design, Implementation and Management, Thomas M. Connolly, Carolyn E. Begg, Pearson, 2014 |
ASSESSMENT |
Assessment & Grading of In-Term Activities |
Number of Activities |
Degree of Contribution (%) |
Description |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
CONTRIBUTION OF THE COURSE UNIT TO THE PROGRAMME LEARNING OUTCOMES
KNOWLEDGE |
Theoretical |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
The formal systems used in civil engineering takes and Discuss the different methods
|
|
|
|
|
|
|
SKILLS |
Cognitive |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Civil engineering design for the project presentation ensures the correct expression
|
|
|
|
|
|
|
SKILLS |
Practical |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Civil engineering design for the project presentation ensures the correct expression
|
|
|
|
|
|
|
OCCUPATIONAL |
Autonomy & Responsibility |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Rise construction in the areas of production engineering can work independently and take responsibility for these issues
|
|
|
|
|
|
|
OCCUPATIONAL |
Learning to Learn |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
As a requirement of the civil engineering profession and the current change follows the principle of lifelong learning
|
|
|
|
|
|
|
OCCUPATIONAL |
Communication & Social |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
As an individual becomes aware of social and professional responsibility
|
|
|
|
|
|
|
OCCUPATIONAL |
Occupational and/or Vocational |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
The powers and responsibilities of civil engineering and construction management takes place within
|
|
|
|
|
|
|
WORKLOAD & ECTS CREDITS OF THE COURSE UNIT |
Workload for Learning & Teaching Activities |
Type of the Learning Activites |
Learning Activities (# of week) |
Duration (hours, h) |
Workload (h) |
Lecture & In-Class Activities |
14 |
4 |
56 |
Preliminary & Further Study |
14 |
3 |
42 |
Land Surveying |
0 |
0 |
0 |
Group Work |
0 |
0 |
0 |
Laboratory |
0 |
0 |
0 |
Reading |
0 |
0 |
0 |
Assignment (Homework) |
4 |
4 |
16 |
Project Work |
0 |
0 |
0 |
Seminar |
0 |
0 |
0 |
Internship |
0 |
0 |
0 |
Technical Visit |
0 |
0 |
0 |
Web Based Learning |
0 |
0 |
0 |
Implementation/Application/Practice |
0 |
0 |
0 |
Practice at a workplace |
0 |
0 |
0 |
Occupational Activity |
0 |
0 |
0 |
Social Activity |
0 |
0 |
0 |
Thesis Work |
0 |
0 |
0 |
Field Study |
0 |
0 |
0 |
Report Writing |
0 |
0 |
0 |
Final Exam |
1 |
1 |
1 |
Preparation for the Final Exam |
4 |
5 |
20 |
Mid-Term Exam |
1 |
1 |
1 |
Preparation for the Mid-Term Exam |
3 |
4 |
12 |
Short Exam |
0 |
0 |
0 |
Preparation for the Short Exam |
0 |
0 |
0 |
TOTAL |
41 |
0 |
148 |
|
Total Workload of the Course Unit |
148 |
|
|
Workload (h) / 25.5 |
5,8 |
|
|
ECTS Credits allocated for the Course Unit |
6,0 |
|