Print

COURSE INFORMATION
Course CodeCourse TitleL+P HourSemesterECTS
BSO 312DATABASE MANAGEMENT SYSTEM2 + 26th Semester 

COURSE DESCRIPTION
Course Level Bachelor's Degree
Course Type Compulsory
Course Objective 1.Comprehend database systems and data structures. 2. Design database using relational database. 3. Use database query language. 4. Develop application software using database management system.
Course Content Components of database systems, Data Base Management Systems (DBMS), DBMS architectures, data modelling, conceptual models, logical models, physical models, relational database design, functional dependencies, normalization, relational algebra, structural query language (SQL), data definition language, data manipulation language, data query language, functions, data grouping, data control language.
Prerequisites No the prerequisite of lesson.
Corequisite No the corequisite of lesson.
Mode of Delivery Face to Face

COURSE LEARNING OUTCOMES
1Interprets database systems and data models.
2Uses database management systems.
3Designs and optimizes databases, using the relational database structure.
4Sets up and manages relational databases.
5Uses database query language.
6Develops various application software which use databases.

COURSE'S CONTRIBUTION TO PROGRAM
PO 01PO 02PO 03PO 04PO 05PO 06PO 07PO 08PO 09PO 10PO 11PO 12PO 13
LO 0013454433355442
LO 0025544533355444
LO 0035455543344342
LO 0045444543344344
LO 0054544543344444
LO 0065555553345454
Sub Total27272726292318182627222520
Contribution5554543345443

ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION
ActivitiesQuantityDuration (Hour)Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)14456
Hours for off-the-classroom study (Pre-study, practice)14114
Assignments14040
Mid-terms11717
Laboratory14114
Final examination199
Total Work Load

ECTS Credit of the Course






150

COURSE DETAILS
 Select Year   


 Course TermNoInstructors
Details 2012-2013 Spring1MELTEM BALABAN
Details 2011-2012 Spring1MELTEM BALABAN
Details 2010-2011 Spring1MELTEM BALABAN
Details 2009-2010 Spring1MELTEM BALABAN
Details 2008-2009 Spring1MELTEM BALABAN
Details 2007-2008 Spring1MELTEM BALABAN
Details 2006-2007 Spring1MELTEM BALABAN


Print

Course Details
Course Code Course Title L+P Hour Course Code Language Of Instruction Course Semester
BSO 312 DATABASE MANAGEMENT SYSTEM 2 + 2 1 Turkish 2012-2013 Spring
Course Coordinator  E-Mail  Phone Number  Course Location Attendance
Lecturer MELTEM BALABAN mbalaban@pau.edu.tr TEF A0102 TEF A0420 %
Goals 1.Comprehend database systems and data structures. 2. Design database using relational database. 3. Use database query language. 4. Develop application software using database management system.
Content Components of database systems, Data Base Management Systems (DBMS), DBMS architectures, data modelling, conceptual models, logical models, physical models, relational database design, functional dependencies, normalization, relational algebra, structural query language (SQL), data definition language, data manipulation language, data query language, functions, data grouping, data control language.
Topics
WeeksTopics
1 Introduction
2 Introduction
3 Relational Database Design
4 Relational Database Design
5 Relational Algebra
6 SQL-Structured Query Language
7 SQL-Structured Query Language
8 SQL Functions
9 SQL Functions
10 Data Grouping
11 Multiple Tables
12 Complex Queries
13 DML Operations
14 Database Objects/User Access Rights
Materials
Materials are not specified.
Resources
ResourcesResources Language
Yalçın Özkan, Veri Tabanı Sistemleri,Alfa Yayınları,2006Türkçe
Nergiz Ergil Çağıltay,Gül Tokdemir,Veritabanı Sistemleri Dersi,Ada Matbaacılık,2010Türkçe
Osman Gürkan,Access 2007,Nirvana Yayınları,2009Türkçe
Course Assessment
Assesment MethodsPercentage (%)Assesment Methods Title
Final Exam50Final Exam
Midterm Exam25Midterm Exam
Homework25Homework
L+P: Lecture and Practice
PQ: Program Learning Outcomes
LO: Course Learning Outcomes