COURSE INFORMATION
Course CodeCourse TitleL+P HourSemesterECTS
CENG 301DATABASE MANAGEMENT & MODELING3 + 25th Semester7

COURSE DESCRIPTION
Course Level Bachelor's Degree
Course Type Compulsory
Course Objective The aim of the course is to make students have the ability of database modelling based on standards and technologies. At the end of this course, students will be able to identify database processing systems, understand the components of a database application and use Structured Query Language (SQL) to query relational databases.
Course Content Database management software. The relational model: Data structure, data integrity, relational algebra. Data manipulation by using SQL. Transaction management: Recovery, concurrency. Relational database theory: Dependencies, normal forms. SQL data definition, other features. DBMS architectures and implementations. Query optimization. Procedural extensions to SQL: PL/SQL, database triggers. DBMSs, OQL. Distributed databases, distributed architectures and ODBC. Databases and the Web, Java database programming - JDBC, SQLJ, databases and XML. ORACLE9i. A real-world application project is performed by students.
Prerequisites No the prerequisite of lesson.
Corequisite No the corequisite of lesson.
Mode of Delivery Face to face

COURSE LEARNING OUTCOMES
1Explains database concepts
2Explains database design
3Queries data in tables
4Explains SQL server architecture
5Lists concurrency controls
6Explains working with connected servers and web services

COURSE'S CONTRIBUTION TO PROGRAM
PO 01PO 02PO 03PO 04PO 05PO 06PO 07PO 08PO 09PO 10PO 11PO 12
LO 015 555  3  5 
LO 025 555  3  5 
LO 035 555  3  5 
LO 045 555  3  5 
LO 055 555  3  5 
LO 065 555  3  5 
Sub Total30 303030  18  30 
Contribution505550030050

ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION
ActivitiesQuantityDuration (Hour)Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)14570
Hours for off-the-classroom study (Pre-study, practice)14342
Assignments188
Mid-terms188
Laboratory15230
Final examination199
Presentation / Seminar Preparation122
Report / Project11313
Total Work Load

ECTS Credit of the Course






182

7

COURSE DETAILS
 Select Year   


 Course TermNoInstructors
Details 2018-2019 Fall1BEDİA SÜNDÜZ KILIÇ
Details 2018-2019 Fall2BEDİA SÜNDÜZ KILIÇ

Course Details
Course Code:  CENG 301 Course Title:  DATABASE MANAGEMENT & MODELING
L+P Hour : 3 + 2   Course Code : 1   Language Of Instruction: Turkish Course Semester :  2018-2019 Fall
Course Coordinator :  LECTURER BEDİA SÜNDÜZ KILIÇ E-Mail:  bskilic@pau.edu.tr Phone Number : 
Course Location MUH A0327, MUH A0435,
Goals : The aim of the course is to make students have the ability of database modelling based on standards and technologies. At the end of this course, students will be able to identify database processing systems, understand the components of a database application and use Structured Query Language (SQL) to query relational databases.
Content : Database management software. The relational model: Data structure, data integrity, relational algebra. Data manipulation by using SQL. Transaction management: Recovery, concurrency. Relational database theory: Dependencies, normal forms. SQL data definition, other features. DBMS architectures and implementations. Query optimization. Procedural extensions to SQL: PL/SQL, database triggers. DBMSs, OQL. Distributed databases, distributed architectures and ODBC. Databases and the Web, Java database programming - JDBC, SQLJ, databases and XML. ORACLE9i. A real-world application project is performed by students.
Attendance : %70
Topics
WeeksTopics
1 Introduction to Database Topics
2 Fundemantals of Relational Database
3 Database design according to normalization rules
4 SQL Server Interface and DDL
5 SQL Queries
6 Queries with multiple tables, View and Index
7 Complex Query Examples and DML
8 T-SQL, Stored Procedure
9 Function and Trigger
10 Midterm Exam
11 Transactions
12 SQL User Types and User Management
13 Project Presentations
14 Project Presentations
Materials
Materials are not specified.
Resources
Course Assessment
Assesment MethodsPercentage (%)Assesment Methods Title
Final Exam35Final Exam
Midterm Exam35Midterm Exam
Project30Project
L+P: Lecture and Practice
PQ: Program Learning Outcomes
LO: Course Learning Outcomes
© 2021 PAU