Civil Engineering | |||||
Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 |
Course Code: | BIL391 | ||||||||
Course Name: | Database Management System | ||||||||
Course Semester: | Fall | ||||||||
Course Credits: |
|
||||||||
Language of instruction: | TR | ||||||||
Course Requisites: | |||||||||
Does the Course Require Work Experience?: | No | ||||||||
Type of course: | Compulsory | ||||||||
Course Level: |
|
||||||||
Mode of Delivery: | Face to face | ||||||||
Course Coordinator : | Prof. Dr. PINAR YILDIRIM | ||||||||
Course Lecturer(s): |
Dr. BİLİNMİYOR BEKLER Prof. Dr. PINAR YILDIRIM |
||||||||
Course Assistants: |
Course Objectives: | The purpose of the database management systems course is to educate students about the main concepts of database management systems and SQL language and as well as introduce to develop database by using relational database system. |
Course Content: | Introduction to database systems. Entity-relationship modeling. Relational model. Data description and query languages. Normal forms and database design. Physical design and access strategies. Security, integrity and reliability. Database design and implementation project. |
The students who have succeeded in this course;
|
Week | Subject | Related Preparation |
1) | • Disadvantages of file processing • Problems with data dependency • Problems with data redundancy • Advantages of database approach • Database management system • Costs and risks of database management system • Elements of database system • Enterprise data model • Database development life cycle • Database schema • People involved | Reading chapter 1-4 |
2) | • Describe importance of data modeling. • Explain how to write good names and definitions for entities, relationships, and attributes. • Define how to distinguish unary, binary, and ternary relationships. • Explain model different types of attributes, entities, relationships, and cardinalities. • Describe how to draw E-R diagrams for common business situations. • Explain how to convert many-to-many relationships to associative entities. | Reading chapter 5-7 |
3) | • Supertypes and subtypes. • Relationships and subtypes. • Generalization and specialization. • Constraints | Reading chapter 8 |
4) | • Components of relation model. • Relation. • Correspondence with E-R model. • Key fields. • Integrity constraints. • Transforming E-R and EER diagrams to relations. | Reading chapter 10 |
5) | • Physical database design. • Designing fields. • Choosing data types. • Field data integrity | Reading chapter 11 |
6) | • Relational database example. | Reading chapter 12. |
7) | Unary Relational Operations: SELECT and PROJECT. Relational Algebra Operations from Set Theory. Binary Relational Operations: JOIN and DIVISION. | |
8) | Midterm1 | |
9) | • SQL overview. • History of SQL. • Benefits of SQL. • SQL environment. • DDL, DML, DCL and database development process. • SQL database definition. • Steps in table creation. • Data integrity controls. • Changing and updating tables. • Table queries using select. | Reading chapter 15-18. |
10) | • Insert, update and delete expressions. • Processing multiple tables. • Natural join. • Outer join. • Processing multiple tables using subqueries. | Reading chapter 15-18. |
11) | Midterm2 | |
12) | • Data normalization. • Well-structured relations. • Anomalies in tables. • Functional dependencies and keys. • First normal form. • Second normal form. • Third normal form. | Reading chapter 13-14. |
13) | • Database Applications. | |
14) | • Project presentation. | |
15) | Final exam. |
Course Notes / Textbooks: | Veritabanı Sistemleri Dersi Teoriden Pratiğe Nergiz Ercil Çağıltay, Gül Tokdemir @2010|Seçkin Yayıncılık|1.baskı ISBN 978-605-61091-0-2 |
References: | Modern Database Management Jeffrey A. Hoffer, V. Ramesh, Heikki Topi @2013|Prentice Hall|10th Edition ISBN 0-13-608839-2 |
Learning Outcomes | 1 |
2 |
4 |
5 |
||||||
---|---|---|---|---|---|---|---|---|---|---|
Program Outcomes | ||||||||||
1) Adequate knowledge in mathematics, science and engineering subjects pertaining to the relevant discipline; ability to use theoretical and applied information in these areas to model and solve engineering problems. | ||||||||||
2) Ability to identify, formulate, and solve complex engineering problems; ability to select and apply proper analysis and modelling methods for this purpose. | ||||||||||
3) Ability to design a complex system, process, device or product under realistic constraints and conditions, in such a way so as to meet the desired result; ability to apply modern design methods for this purpose. (Realistic constraints and conditions may include factors such as economic and environmental issues, sustainability, manufacturability, ethics, health, safety isuues, and social and political issues according to the nature of the design.) | ||||||||||
4) Ability to devise, select, and use modern techniques and tools needed for engineering practice; ability to employ information technologies effectively. | ||||||||||
5) Ability to design and conduct experiments, gather data, analyse and interpret results for investigating engineering problems. | ||||||||||
6) Ability to work efficiently in intra-disciplinary and multi-disciplinary teams; ability to work individually. | ||||||||||
7) Ability to communicate effectively i Turkish, both orally and in writing; knowledge of a minimum of one foreign language. | ||||||||||
8) Recognition of the need for lifelong learning; ability to access information, to follow developments in science and technology, and to continue to educate him/herself. | ||||||||||
9) Awareness of professional and ethical responsibility. | ||||||||||
10) Information about business life practices such as project management, risk management, and change management; awareness of entrepreneurship, innovation, and sustainable development. | ||||||||||
11) Knowledge about contemporary issues and the global and societal effects of engineering practices on health, environment, and safety; awareness of the legal consequences of engineering solutions. |
No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
Program Outcomes | Level of Contribution | |
1) | Adequate knowledge in mathematics, science and engineering subjects pertaining to the relevant discipline; ability to use theoretical and applied information in these areas to model and solve engineering problems. | |
2) | Ability to identify, formulate, and solve complex engineering problems; ability to select and apply proper analysis and modelling methods for this purpose. | |
3) | Ability to design a complex system, process, device or product under realistic constraints and conditions, in such a way so as to meet the desired result; ability to apply modern design methods for this purpose. (Realistic constraints and conditions may include factors such as economic and environmental issues, sustainability, manufacturability, ethics, health, safety isuues, and social and political issues according to the nature of the design.) | |
4) | Ability to devise, select, and use modern techniques and tools needed for engineering practice; ability to employ information technologies effectively. | |
5) | Ability to design and conduct experiments, gather data, analyse and interpret results for investigating engineering problems. | |
6) | Ability to work efficiently in intra-disciplinary and multi-disciplinary teams; ability to work individually. | |
7) | Ability to communicate effectively i Turkish, both orally and in writing; knowledge of a minimum of one foreign language. | |
8) | Recognition of the need for lifelong learning; ability to access information, to follow developments in science and technology, and to continue to educate him/herself. | |
9) | Awareness of professional and ethical responsibility. | |
10) | Information about business life practices such as project management, risk management, and change management; awareness of entrepreneurship, innovation, and sustainable development. | |
11) | Knowledge about contemporary issues and the global and societal effects of engineering practices on health, environment, and safety; awareness of the legal consequences of engineering solutions. |
Lesson | |
Project preparation |
Written Exam (Open-ended questions, multiple choice, true-false, matching, fill in the blanks, sequencing) | |
Individual Project |
Semester Requirements | Number of Activities | Level of Contribution |
Project | 1 | % 15 |
Midterms | 2 | % 40 |
Final | 1 | % 45 |
total | % 100 | |
PERCENTAGE OF SEMESTER WORK | % 55 | |
PERCENTAGE OF FINAL WORK | % 45 | |
total | % 100 |
Activities | Number of Activities | Duration (Hours) | Workload |
Course Hours | 14 | 3 | 42 |
Project | 1 | 40 | 40 |
Midterms | 2 | 40 | 80 |
Final | 1 | 45 | 45 |
Total Workload | 207 |