Print

COURSE INFORMATION
Course CodeCourse TitleL+P HourSemesterECTS
CBPG 108DATABASE I3 + 12nd Semester6

COURSE DESCRIPTION
Course Level Associate's Degree
Course Type Compulsory
Course Objective With this course, students, data base designing, creating, querying, data base administrative functions, gain qualifications.
Course Content Database Needs Analysis Normalization Normalization Normalization Installing the Database Tools Creating tables and determine the characteristics of Creating tables and determine the characteristics of Creating tables and determine the characteristics of Create and use the kinds of queries Create and use the kinds of queries Prepare tables associated with the query Prepare tables associated with the query Using DML queries Using DML queries User queries Writing Writing Queries View Writing Trigger Queries Writing Trigger Queries Writing Queries Sub-Programme Make Transaction Processing Writing Queries Index
Prerequisites No the prerequisite of lesson.
Corequisite No the corequisite of lesson.
Mode of Delivery Face to Face

COURSE LEARNING OUTCOMES
1Database design
2Creating database
3Querying the database

COURSE'S CONTRIBUTION TO PROGRAM
PO 01PO 02PO 03PO 04PO 05PO 06PO 07PO 08PO 09PO 10PO 11PO 12PO 13PO 14PO 15PO 16PO 17PO 18PO 19
LO 0011   5  5 4         
LO 0021   5  5 2         
LO 0031   5  5 3         
Sub Total3   15  15 9         
Contribution1000500503000000000

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)14456
Mid-terms11010
Final examination11010
Report / Project11414
Quiz2510
Total Work Load

ECTS Credit of the Course






156

6
COURSE DETAILS
 Select Year   


 Course TermNoInstructors
Details 2023-2024 Spring1ALİ COŞKUN
Details 2022-2023 Spring1ALİ COŞKUN
Details 2021-2022 Spring1ALİ COŞKUN
Details 2020-2021 Spring1ALİ COŞKUN
Details 2019-2020 Spring1ALİ COŞKUN
Details 2018-2019 Spring1ALİ COŞKUN
Details 2017-2018 Spring1ALİ COŞKUN
Details 2016-2017 Spring1ALİ COŞKUN
Details 2015-2016 Spring1ALİ COŞKUN
Details 2014-2015 Spring1ALİ COŞKUN
Details 2013-2014 Summer1ALİ COŞKUN
Details 2013-2014 Summer1ALİ COŞKUN
Details 2013-2014 Spring1ALİ COŞKUN
Details 2012-2013 Summer1ALİ COŞKUN
Details 2012-2013 Summer1ALİ COŞKUN
Details 2012-2013 Summer1ALİ COŞKUN
Details 2012-2013 Spring1ALİ COŞKUN
Details 2011-2012 Summer1ALİ COŞKUN
Details 2011-2012 Spring1ALİ COŞKUN


Print

Course Details
Course Code Course Title L+P Hour Course Code Language Of Instruction Course Semester
CBPG 108 DATABASE I 3 + 1 1 Turkish 2023-2024 Spring
Course Coordinator  E-Mail  Phone Number  Course Location Attendance
Lecturer ALİ COŞKUN alicoskun@pau.edu.tr ÇMYO A0064 %70
Goals With this course, students, data base designing, creating, querying, data base administrative functions, gain qualifications.
Content Database Needs Analysis Normalization Normalization Normalization Installing the Database Tools Creating tables and determine the characteristics of Creating tables and determine the characteristics of Creating tables and determine the characteristics of Create and use the kinds of queries Create and use the kinds of queries Prepare tables associated with the query Prepare tables associated with the query Using DML queries Using DML queries User queries Writing Writing Queries View Writing Trigger Queries Writing Trigger Queries Writing Queries Sub-Programme Make Transaction Processing Writing Queries Index
Topics
WeeksTopics
1 Introduction to data base
2 Basic Concepts
3 Relational Database Design
4 Normalization
5 Example Database Application
6 SQL - Structured Query Language
7 Single-Table Queries
8 Arithmetic Operators and Functions
9 Query grouping
10 Query on multiple tables
11 Old Queries
12 Views
13 Use of index
14 Project Presentation
Materials
Materials are not specified.
Resources
ResourcesResources Language
Veri Tabamı Yönetim Sistemleri -1 - Turgut Özseven - Murathan YayıneviTürkçe
Course Assessment
Assesment MethodsPercentage (%)Assesment Methods Title
Final Exam45Final Exam
Midterm Exam40Midterm Exam
Project15Project
L+P: Lecture and Practice
PQ: Program Learning Outcomes
LO: Course Learning Outcomes