Ondokuz Mayıs Üniversitesi Bilgi Paketi - Ders Kataloğu

Description of Individual Course Units

Course Unit CodeCourse Unit TitleType of CourseYearSemesterECTS
HRT336 Database Design 927006 3 6 5
Level of Course Unit
First Cycle
Objectives of the Course
The main objectives of this course are to provide the knowledge on consepts and principles of database design and to familiarize the students with a DBMS by hands-on experiences.
Name of Lecturer(s)
Doç. Dr. Derya ÖZTÜRK
Learning Outcomes
  1. Understand database concepts and applications.
  2. Understand data models.
  3. Develop a conceptual data model.
  4. Develop a logical database design based on the relational data model and normalisation.
  5. Implement SQL: Data definition, constraints, queries and operations in SQL
Mode of Delivery
Formal Education
Prerequisites and co-requisities
None
Recommended Optional Programme Components
None
Recommended or Required Reading
Ercil Çağıltay, N., Tokdemir, G., 2010, Veritabanı Sistemleri Dersi: Teoriden Pratiğe,Ada Matbaacılık, Ankara.
Elmasri, R., Navathe, S. B, 2000, Fundamentals of Database Systems, Second Edition, Benjamin Cummings, Redwood City, California.
Planned Learning Activities and Teaching Methods
Language of Instruction
Turkish
Work Placement(s)
None
Course Contents
Database design; Relational database model; Conceptual modelling; Logical modelling; Physical modelling
Weekly Detailed Course Contents
Week Theoretical Practice Laboratory
1.Importance of data, database and database management
2.Database management (DBM)
3.- Database models: Hierarchical, Network, Relational, Object-oriented model
4.Phases in database life cycle (DBLC): Conceptual, logical and physical database design
5.Requirements Gathering and Analysis- Information gathering techniques- Specification of requirements
6.Conceptual Database Design Using Entity Relationship Model:- Identify entities, attributes, primary keys, relationships and business rules for an application
7.Conceptual Database Design Using Entity Relationship Model:- Create Entity Relationship Diagram
8.Logical Database Design:-Transformation of ER models into relational database model
9.Logical Database Design:-Transformation of ER models into relational database model
10.MIDTERM EXAM
11.Logical Database Design:- Normalize data to First Normal Form (1NF), Second Normal Form (2NF), Third Normal Form (3NF)
12.Design, creation, and management of relational databases using Microsoft Access
13.Data definition, constraints, queries and operations in SQL
14.Data definition, constraints, queries and operations in SQL
15.
16.
Assessment Methods and Criteria
Term (or Year) Learning ActivitiesQuantityWeight (%)
Midterm Examination1100
SUM100
End Of Term (or Year) Learning ActivitiesQuantityWeight (%)
Final Examination1100
SUM100
Term (or Year) Learning Activities40
End Of Term (or Year) Learning Activities60
SUM100
Workload Calculation
ActivitiesQuantityTime(hours)Total Workload(hours)
Midterm Examination122
Final Examination122
Attending Lectures14342
Self Study14342
Individual Study for Mid term Examination11717
Individual Study for Final Examination12020
SUM125