YBS 303


Course Title Course Code Program Level
DATABASE MANAGEMENT SYSTEMS I (ENGLISH) YBS 303 Management Information Systems B.A. / B.Sc.

Course Term
(Course Semester)
Teaching and Learning Methods
Credits
Theory Practice Lab Projects/Field Work Seminars/Workshops Other Total Credits ECTS Credits
05
(Fall)
42 84 126 3 5

Teaching Staff Doç.Dr. Alaattin Parlakkılıç
Language of Instruction İngilizce (English)
Type Of Course Compulsory
Prerequisites -
Recommended Optional Programme Component
Course Objectives • Be familiar with database architecture • Master the design of retrieval queries • Master normalization principles • Be familiar with the design of a relational database • Be familiar with embedded SQL queries
Course Content Provides fundamental knowledge of, and practical experience with, database concepts. Includes study of information concepts and the realization of those concepts using the relational data model. Practical experience gained designing and constructing data models and using SQL to interface to both multi-user DBMS packages and to desktop DBMS packages Access 2016.
Learning Outcomes (LO) 1. Differentiate database systems from file systems by enumerating the features provided by database systems and describe each in both function and benefit. 2. Define the terminology, features, classifications, and characteristics embodied in database systems. 3. Analyze an information storage problem and derive an information model expressed in the form of an entity relation diagram and other optional analysis forms, such as a data dictionary. 4. Demonstrate an understanding of the relational data model. 5. Transform an information model into a relational database schema and to use a data definition language and/or utilities to implement the schema using a DBMS. 6. Formulate, using relational algebra, solutions to a broad range of query problems. 7. Formulate, using SQL, solutions to a broad range of query and data update problems. 8. Demonstrate an understanding of normalization theory and apply such knowledge to the normalization of a database. 9. Use an SQL interface of a multi-user relational DBMS package to create, secure, populate, maintain, and query a database. 10. Use a desktop database package to create, populate, maintain, and query a database. 11. Demonstrate a rudimentary understanding of programmatic interfaces to a database and be able to use the basic functions of one such interface.
Mode of Delivery Face to face
Course Outline
Week Topics
1. Week Introduction to DB Management
2. Week Conceptual Design & Data Modeling using E-R Diagrams
3. Week The Relational Model (& more ER)
4. Week Conceptial design
5. Week Physical design
6. Week Normalization
7. Week Mid term Exam
8. Week Relational Algebra & Relational Calculus
9. Week Access 2016 and its usage
10. Week Introduction to Sql
11. Week SQL: Select, Project, Join
12. Week SQL: Intersect, Union, Except
13. Week Data Manipulation Language
14. Week Advanced Sql
Assessment
  Percentage(%)
Mid-term (%) 40
Quizes (%)
Homeworks/Term papers (%)
Practice (%)
Labs (%)
Projects/Field Work (%)
Seminars/Workshops (%)
Final (%) 60
Other (%)
Total(%) 100
Course Book (s) and/or References Concepts of Database Management" (8th Ed) (ISBN: 1285427106)
Work Placement(s)
The Relationship between Program Qualifications (PQ) and Course Learning Outcomes (LO)