D ATA B A S E
MODELING AND
DESIGN
SYLLABUS
Dr. Bilgin Avenoğlu
Lectures
• Monday: 09:20 - 12:10
• Classroom: PA-01
Syllabus / Introduction to Databases
Content Conceptual Data Modeling and Database
Design
Conceptual Data Modeling and Database
• Database system concepts and architecture. Design
Relational DB Design by ER- to Relational
• Relational data model and SQL. Mapping
• Database normalization. The Relational Data Model and SQL
• Indexing. The Relational Data Model and SQL
• Transaction processing. Advanced SQL
• Concurrency control. Midterm
Database Design Theory and
Normalization
File Structures, Hashing, Indexing, and
Physical Database Design
File Structures, Hashing, Indexing, and
Physical Database Design
Introduction to Transaction Processing
Concepts and Theory
Introduction to Transaction Processing
Concepts and Theory
Concurrency Control, and Recovery
Learning Outcomes
1. Understand database concepts and applications.
2. Recognize and use contemporary logical design methods and tools for databases.
3. Derive a physical design for a database from its logical design.
4. Understand the SQL data definition and SQL data manipulation languages.
5. Understand the concepts of constraints and produce well-structured database using functional
dependencies and normalization.
6. Install, configure, and interact with a relational database management system.
7. Explain data structures and algorithms used to efficiently store and retrieve information in database
systems.
8. Analyze techniques for transaction processing, concurrency control, backup and recovery that
maintain data integrity in database systems.
9. Develop team spirit and professional attitude towards the development of database applications.
Evaluation
• Classroom Activity: %10
• Midterm: %40 —> 6th of April
• Final: %50
Grading
Midterm
Attendance
• %60 (7 days) participation is mandatory.
• If you can’t meet this requirement, yo will not be allowed to take the FINAL exam
• I may take attendance in different hours.
• First hour, second hour or third hour.
• You must be in the classroom when I take the attendance.
• I may take attendance for each hour.
• You must be in the classroom for at least two hours.
Late Assignment Submission Policy
• Late assignments will have 10% of the maximum score deducted for each 24-
hour period after the due date that the assignment is late.
• No assignment will be accepted more than 3 days late.
Books
THE END
Dr. Bilgin Avenoğlu