First Cycle - Faculty of Engineering - Computer Engineering (English)
Y : Year of Study S : Semester
Course Unit Code Course Unit Title Type of Course Y S ECTS
CSE3055 Database Systems Compulsory 3 5 7
Objectives of the Course
This couse aims to introduce the basic concepts of database design to the students. Besides teaching database theory in the lectures, MS SQL Server will be used in the lab. Students will develop a working database system as term project.
Learning Outcomes
1 Understand that there could be ethically unacceptable database development requests
2 Acquire the skills for "making the user talk" in the database development process
3 Understand the concepts of logical and physical database modeling processes
4 Comprehend the concrete concepts for database applications and abstracting them in the process of developing working databases
5 Understand database types with an emphasis on the relational databases which are the most commonly used
Mode of Delivery
Formal Education
Course Contents
Introduction and objectives; The database environment; Introduction to SQL: Single tables; Advanced SQL: Several tables; The database development process; Modeling data in the organizaton and E-R model; Enhanced E-R model; Logical database design and the relational model; Physical database design and performance; The client/server database environment; The Internet database environment; Data Warehousing & concurrency.
Weekly Detailed Course Contents
Week Theoretical Practice Laboratory
1 Introduction and objectives
2 The database environment
3 Introduction to SQL: Single tables
4 Advanced SQL: Several tables
5 The database development process
6 Modeling data in the organizaton and E-R model
7 Enhanced E-R model
8 Midterm
9 Logical database design and the relational model
10 Logical database design and the relational model
11 Physical database design and performance
12 Physical database design and performance
13 The client/server database environment
14 The Internet database environment
15 Data Warehousing & concurrency
16 Study Week
17 Final
Recommended or Required Reading
1. Modern Database Management (9th Edition) by J.A. Hoffer, M.B. Prescott, & F.R. McFadden, Prentice-Hall, 2009.
2. Database System Concepts (5th Edition) by A. Silberschatz, H.F. Korth, & S. Sudarshan, McGraw Hill, 2006.
3. Fundamentals of Database Systems (5th Edition) by R. Elmasri & S.B. Navathe, Addison Wesley, 2007.
Planned Learning Activities and Teaching Methods
Lecture, presentation, question & answer, problem solving, discussion, lab application
Assessment
AssessmentQuantityWeight
Term (or Year) Learning Activities60
End Of Term (or Year) Learning Activities40
Total100
Term (or Year) Learning ActivitiesQuantityWeight
Midterm Exam150
Project150
Total100
End Of Term (or Year) Learning ActivitiesQuantityWeight
Final Exam1100
Total100
Language of Instruction
English
Work Placement(s)
None
Workload Calculation
Activities Number Time (hours) Total Work Load (hours)
Theoretical 3 14 42
Applied 2 14 28
Midterm Preparation 1 20 20
Final Preparation 1 30 30
Project 1 30 30
Total 8 108 150
Contribution of Learning Outcomes to Programme Outcomes
PO 1PO 2PO 3PO 4PO 5PO 6PO 7PO 8PO 9PO 10PO 11PO 12PO 13PO 14PO 15PO 16
LO 10000000000000000
LO 20000000000000000
LO 30000000000000000
LO 40000000000000000
LO 50000000000000000

^