Lesson plan / DATABASE SYSTEMS

Lesson Information

Course Credit 3.0
Course ECTS Credit 4.0
Teaching Language of Instruction İngilizce
Level of Course Bachelor's Degree, TYYÇ: Level 6, EQF-LLL: Level 6, QF-EHEA: First Cycle
Type of Course Compulsory
Mode of Delivery Face-to-face
Does the course require compulsory or optional work experience? Z
Course Coordinator Prof. Dr. ALİ GÜNEŞ
Instructor (s)
Course Assistant

Purpose and Content

The aim of the course Upon completion of this course, participants will have gained knowledge of SQL concepts, database system concepts and the ability to: • understand user requirements/views • analyze existing and future data processing needs • develop an enterprise data model that reflects the organization's fundamental business rules • develop and refine the conceptual data model, including all entities, relationships, attributes, and business rules • integrate and merge database views into conceptual model • apply normalization techniques • identify data integrity and security requirements • derive a physical design from the logical design taking into account application, hardware, operating system, and data communications networks requirements • utilize prototyping as a rapid application development (RAD) method to implement a PC database (e.g., Microsoft Access® for the PC)
Course Content This course covers SQL and fundamentals of database architecture, database management systems, and database systems. Principles and methodologies of database design, and techniques for database application development

Weekly Course Subjects

1Introduction Database Environment Database Development Process
2Modeling Data in the Organization Enhanced E-R Model and Business Rules
3Logical Database Design and the Relational Model Physical Database Design and Performance The Software Engineering Process and Relational Databases
4SQL Advanced SQL
5Getting Started with SQL in Access Beginning SQL Commands in Access
6Client/Server Database Environment Internet Database Environment Data Warehousing Creating and Populating Tables
7SQL Joins SQL Functions
8SQL Query Development and Derived Structures SQL Set Operations
9SQL Joins versus Subqueries SQL Aggregation and GROUP BY
10SQL Correlated Subqueries SQL Indexes and Constraints on Tables
11Data and Database Administration Distributed Databases
12Object-Oriented Data Modeling Object-Oriented Database Development
13Capstone Project
14Capstone Project

Resources

1-1-1. Hoffer, Prescott & McFadden, (2005). Modern Database Management (7th ed.) Prentice-Hall, Inc. ISBN: 0-13-145320-3.
2. Bagui, S. & Earp, R (2004). Learning SQL A Step-by-Step Guide Using Access®. Addison-Wesley Publishing. ISBN: 0-32-111904-5.