1. FIRST CYCLE - BACHELOR'S DEGREE
  2. FACULTY OF ENGINEERING
  3. COMPUTER ENGINEERING DEPARTMENT
  4. 253 Computer Engineering
Course Information Course Learning Outcomes Course's Contribution To Program ECTS Workload Course Details
Print

COURSE INFORMATION
Course CodeCourse TitleL+P HourSemesterECTS
CENG 313DATABASE MANAGEMENT AND MODELING3 + 05th Semester4,5

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 a relational database management system
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 0015 321   1 2 
LO 00251452   3 4 
LO 00352322   2 2 
LO 0045 222   1 2 
LO 0055 322   1 2 
LO 0065 121   1 3 
Sub Total303161510   9 15 
Contribution513320002030

ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION
ActivitiesQuantityDuration (Hour)Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)14342
Hours for off-the-classroom study (Pre-study, practice)14114
Mid-terms11010
Final examination11010
Report / Project14141
Total Work Load

ECTS Credit of the Course





117

4,5
COURSE DETAILS
 Select Year   


 Course TermNoInstructors
Details 2023-2024 Fall1FATMANA ŞENTÜRK


Print

Course Details
Course Code Course Title L+P Hour Course Code Language Of Instruction Course Semester
CENG 313 DATABASE MANAGEMENT AND MODELING 3 + 0 1 Turkish 2023-2024 Fall
Course Coordinator  E-Mail  Phone Number  Course Location Attendance
Asts. Prof. Dr. FATMANA ŞENTÜRK fatmanas@pau.edu.tr MUH A0327 %60
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.
Topics
WeeksTopics
1 Introduction to Database Concepts
2 Database Types, Relational Database Design
3 ER Diagrams and Normalization
4 SQL Server Interface, Database Objects
5 T-SQL and SQL Queries
6 Index and Views
7 Stored Procedure and Functions
8 Triggers
9 Transactions and Backup
10 User Types and User Management
11 No-SQL Databases
12 No-SQL Databases
13 Project Presentation
14 Project Presentation
Materials
Materials are not specified.
Resources
Course Assessment
Assesment MethodsPercentage (%)Assesment Methods Title
Final Exam50Final Exam
Midterm Exam35Midterm Exam
Quiz15Quiz
L+P: Lecture and Practice
PQ: Program Learning Outcomes
LO: Course Learning Outcomes