CENG391 Database Management Systems Istanbul Okan UniversityDegree Programs Computer Engineering (English)General Information For StudentsDiploma SupplementErasmus Policy StatementNational Qualifications
Computer Engineering (English)
Bachelor TR-NQF-HE: Level 6 QF-EHEA: First Cycle EQF-LLL: Level 6

General course introduction information

Course Code: CENG391
Course Name: Database Management Systems
Course Semester: Spring
Course Credits:
Theoretical Practical Credit ECTS
3 0 3 7
Language of instruction: EN
Course Requisites:
Does the Course Require Work Experience?: No
Type of course: Department Elective
Course Level:
Bachelor TR-NQF-HE:6. Master`s Degree QF-EHEA:First Cycle EQF-LLL:6. Master`s Degree
Mode of Delivery: Face to face
Course Coordinator : Prof. Dr. PINAR YILDIRIM
Course Lecturer(s): Prof. Dr. PINAR YILDIRIM
Dr.Öğr.Üyesi NİGAR TUĞBAGÜL ALTAN GÜLGÜN
Course Assistants:

Course Objective and Content

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.

Learning Outcomes

The students who have succeeded in this course;
Learning Outcomes
1 - Knowledge
Theoretical - Conceptual
1) Ability to explain the concepts of database management systems
2) Ability to describe the different issues involved in the design and implementation of a database systems.
3) Ability to explain conceptual, logical, physical and relational database modeling.
4) Ability to use Structured Query Language (SQL).
5) Ability to develop and manage databases.
2 - Skills
Cognitive - Practical
3 - Competences
Communication and Social Competence
Learning Competence
Field Specific Competence
Competence to Work Independently and Take Responsibility

Lesson Plan

Week Subject Related Preparation
1) • • Definitions • 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
2) • Finding good name for a database • Data definitions • E-R(entitiy-relationship) model • Business rules • Entities • Strong, weak entities and idendifying relationships • Attributes • Simple composite attributes • Multi valued and derived attributes • Identifiers(keys) • Naming and defining attributes • Degree of relationships • Cardinality of relationships Reading chapter 2.
3) • Supertypes and subtypes. • Relationships and subtypes. • Generalization and specialization. • Constraints. Reading chapter 3.
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 4.
5) • Physical database design. • Designing fields. • Choosing data types. • Field data integrity Reading chapter 5
6) Example of Relational Database Application.
7)  Unary Relational Operations: SELECT and PROJECT.  Relational Algebra Operations from Set Theory.  Binary Relational Operations: JOIN and DIVISION.
8) Midterm1 Reading chapter 1-5.
9) • SQL overview. • History of SQL. • Benefits of SQL. • SQL environment. • DDL,DML,DCLand database development process. • SQL database definition. • Steps in table creation. • Data integrity controls. • Changing and updating tables. • Table queries using select Reading chapter 6. Research and work on project.
10) • Insert, update and delete expressions. • Processing multiple tables. • Natural join. • Outer join. • Processing multiple tables using subqueries. Reading chapter 7. Research and work on project.
11) Midterm2 Reading chapter 5-7.
12) • Data normalization. • Well-structured relations. • Anomalies in tables. • Functional dependencies and keys. • First normal form. • Second normal form. • Third normal form. Research and work on project.
13) • Database applications. Research and work on project.
14) Project presentations
15) Final exam

Sources

Course Notes / Textbooks: Modern Database Management
Jeffrey A. Hoffer, V. Ramesh, Heikki Topi
@2013|Prentice Hall|10th Edition
ISBN 0-13-608839-2
References: 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

Course-Program Learning Outcome Relationship

Learning Outcomes

1

2

3

4

5

Program Outcomes
1) Sufficient knowledge in mathematics, science and engineering related to their branches; the ability to apply theoretical and practical knowledge in these areas to model and solve engineering problems.
2) The ability to identify, formulate, and solve complex engineering problems; selecting and applying appropriate analysis and modeling methods for this purpose.
3) The ability to design a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; the ability to apply modern design methods for this purpose. (Realistic constraints and conditions include such issues as economy, environmental issues, sustainability, manufacturability, ethics, health, safety, social and political issues, according to the nature of design.)
4) Ability to develop, select and use modern techniques and tools necessary for engineering applications; ability to use information technologies effectively.
5) Ability to design experiments, conduct experiments, collect data, analyze and interpret results for examination of engineering problems.
6) The ability to work effectively in disciplinary and multidisciplinary teams; individual work skill.
7) Effective communication skills in Turkish oral and written communication; at least one foreign language knowledge.
8) Awareness of the need for lifelong learning; access to knowledge, ability to follow developments in science and technology, and constant self-renewal.
9) Professional and ethical responsibility.
10) Information on project management and practices in business life such as risk management and change management; awareness about entrepreneurship, innovation and sustainable development.
11) Information on the effects of engineering applications on health, environment and safety in the universal and social dimensions and the problems of the times; awareness of the legal consequences of engineering solutions.

Course - Learning Outcome Relationship

No Effect 1 Lowest 2 Low 3 Average 4 High 5 Highest
           
Program Outcomes Level of Contribution
1) Sufficient knowledge in mathematics, science and engineering related to their branches; the ability to apply theoretical and practical knowledge in these areas to model and solve engineering problems.
2) The ability to identify, formulate, and solve complex engineering problems; selecting and applying appropriate analysis and modeling methods for this purpose.
3) The ability to design a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; the ability to apply modern design methods for this purpose. (Realistic constraints and conditions include such issues as economy, environmental issues, sustainability, manufacturability, ethics, health, safety, social and political issues, according to the nature of design.)
4) Ability to develop, select and use modern techniques and tools necessary for engineering applications; ability to use information technologies effectively.
5) Ability to design experiments, conduct experiments, collect data, analyze and interpret results for examination of engineering problems.
6) The ability to work effectively in disciplinary and multidisciplinary teams; individual work skill.
7) Effective communication skills in Turkish oral and written communication; at least one foreign language knowledge.
8) Awareness of the need for lifelong learning; access to knowledge, ability to follow developments in science and technology, and constant self-renewal.
9) Professional and ethical responsibility.
10) Information on project management and practices in business life such as risk management and change management; awareness about entrepreneurship, innovation and sustainable development.
11) Information on the effects of engineering applications on health, environment and safety in the universal and social dimensions and the problems of the times; awareness of the legal consequences of engineering solutions.

Learning Activity and Teaching Methods

Lesson
Project preparation

Assessment & Grading Methods and Criteria

Written Exam (Open-ended questions, multiple choice, true-false, matching, fill in the blanks, sequencing)
Group project

Assessment & Grading

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

Workload and ECTS Credit Grading

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