Pamukkale University
University is the guide to life
Welcome to PAU;
Prospective Student
Our Students
Our Staff
TR
Information Package & Course Catalogue
Home Page
About University
Name And Address
Acedemic Authorities
General Discription
Academic Calendar
General Admission Requirements
Recognition of Prior Learning
General Registration Procedures
ECTS Credit Allocation
Academic Guidance
Information For Students
Cost Of Living
Accommodation
Meals
Medical Facilities
Facilities for Special Needs Students
Insurance
Financial Support for Students
Student Affairs
Learning Facilities
International Programs
Language Courses
Internships
Sports Facilities and Leisure Activities
Student Associations
Practical Information for Mobile Students
Degree Programmes
FIRST CYCLE - BACHELOR'S DEGREE
FACULTY OF TECHNICAL EDUCATION
EDUCATION OF ELECTRONIC AND COMPUTER DEPARTMENT
405 Department of Computer Systems Education
Course Information
Course Learning Outcomes
Course's Contribution To Program
ECTS Workload
Course Details
Print
COURSE INFORMATION
Course Code
Course Title
L+P Hour
Semester
ECTS
BSO 312
DATABASE MANAGEMENT SYSTEM
2 + 2
6th 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
1
Interprets database systems and data models.
2
Uses database management systems.
3
Designs and optimizes databases, using the relational database structure.
4
Sets up and manages relational databases.
5
Uses database query language.
6
Develops various application software which use databases.
COURSE'S CONTRIBUTION TO PROGRAM
PO 01
PO 02
PO 03
PO 04
PO 05
PO 06
PO 07
PO 08
PO 09
PO 10
PO 11
PO 12
PO 13
LO 001
3
4
5
4
4
3
3
3
5
5
4
4
2
LO 002
5
5
4
4
5
3
3
3
5
5
4
4
4
LO 003
5
4
5
5
5
4
3
3
4
4
3
4
2
LO 004
5
4
4
4
5
4
3
3
4
4
3
4
4
LO 005
4
5
4
4
5
4
3
3
4
4
4
4
4
LO 006
5
5
5
5
5
5
3
3
4
5
4
5
4
Sub Total
27
27
27
26
29
23
18
18
26
27
22
25
20
Contribution
5
5
5
4
5
4
3
3
4
5
4
4
3
ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION
Activities
Quantity
Duration (Hour)
Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)
14
4
56
Hours for off-the-classroom study (Pre-study, practice)
14
1
14
Assignments
1
40
40
Mid-terms
1
17
17
Laboratory
14
1
14
Final examination
1
9
9
Total Work Load
ECTS Credit of the Course
150
COURSE DETAILS
Select Year
All Years
2012-2013 Spring
2011-2012 Spring
2010-2011 Spring
2009-2010 Spring
2008-2009 Summer
2008-2009 Spring
2007-2008 Summer
2007-2008 Spring
2006-2007 Spring
Course Term
No
Instructors
Details
2012-2013 Spring
1
MELTEM BALABAN
Details
2011-2012 Spring
1
MELTEM BALABAN
Details
2010-2011 Spring
1
MELTEM BALABAN
Details
2009-2010 Spring
1
MELTEM BALABAN
Details
2008-2009 Spring
1
MELTEM BALABAN
Details
2007-2008 Spring
1
MELTEM BALABAN
Details
2006-2007 Spring
1
MELTEM 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
Weeks
Topics
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
Resources
Resources Language
Yalçın Özkan, Veri Tabanı Sistemleri,Alfa Yayınları,2006
Türkçe
Nergiz Ergil Çağıltay,Gül Tokdemir,Veritabanı Sistemleri Dersi,Ada Matbaacılık,2010
Türkçe
Osman Gürkan,Access 2007,Nirvana Yayınları,2009
Türkçe
Course Assessment
Assesment Methods
Percentage (%)
Assesment Methods Title
Final Exam
50
Final Exam
Midterm Exam
25
Midterm Exam
Homework
25
Homework
L+P:
Lecture and Practice
PQ:
Program Learning Outcomes
LO:
Course Learning Outcomes
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##
Home Page
About University
Name And Address
Acedemic Authorities
General Discription
Academic Calendar
General Admission Requirements
Recognition of Prior Learning
General Registration Procedures
ECTS Credit Allocation
Academic Guidance
Information For Students
Cost Of Living
Accommodation
Meals
Medical Facilities
Facilities for Special Needs Students
Insurance
Financial Support for Students
Student Affairs
Learning Facilities
International Programs
Language Courses
Internships
Sports Facilities and Leisure Activities
Student Associations
Practical Information for Mobile Students
Degree Programmes