COURSE UNIT TITLE

: DATABASE MANAGEMENT

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
BIL 2004 DATABASE MANAGEMENT COMPULSORY 2 2 0 5

Offered By

Computer Science

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

PROFESSOR DOCTOR EMEL KURUOĞLU KANDEMIR

Offered to

Computer Science

Course Objective

Targets of this course includes preparing student to be able to design, create and use a database system and applications. Primary objectives are user requirements analysis, normalization, conceptual and physical database design, understanding of data definition and data manipulation for relational and other database models, to have experience in database management applications and using SQL.

Learning Outcomes of the Course Unit

1   Learning data and database concepts
2   Developing the data model for the related field
3   Designing conceptual model of a database
4   Construction and administration of a database
5   Data manipulation and query by using SQL language

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Database concepts, history, Data Types
2 Data models, Relational Data Model, Relations - Relation types
3 Database Management System, Database Administrator and tasks, Introduction to MS Access, tables, relations, queries
4 Normalization
5 ER Diagrams
6 SQL - Structured Query Language, SELECT statement, Introduction to MS SQL Server, database and table creation
7 SQL Applications
8 SQL Applications
9 UNION and JOIN operations
10 SQL exercises
11 CREATE TABLE, INSERT INTO, UPDATE, DELETE, DROP statements
12 SQL exercises
13 Database and table creation, user operations, View, Trigger, Stored Procedures
14 Applications

Recomended or Required Reading

Textbook(s): Hansen, G. W., Hansen, J. V., Database Management and Design, Prentice Hall; 2nd edition, 1995
Supplementary Book(s):
- Ramakrishnan R. and Gehrke J., Database Management Systems, 3rd edition, 2007.
- Silberschatz A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th edition, McGraw-Hill, 2005.
- Sreelatha P. and Sreedevi M., Database Management System, Harshwardhan Publication, ISBN 978-93-90284-702, 2023.
- Wilfried Lemahieu, Seppe vanden Broucke, Bart Baesens, Principles of Database Management, The Practical Guide to Storing, Managing and Analyzing Big and Small Data, University Printing House, Cambridge CB2 8BS, United Kingdom, 2018.

Planned Learning Activities and Teaching Methods

The course is taught in a lecture, class presentation and discussion format.

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 VZ Vize
2 FN Final
3 BNS BNS VZ * 0.40 + FN * 0.60
4 BUT Bütünleme Notu
5 BBN Bütünleme Sonu Başarı Notu VZ * 0.40 + BUT * 0.60


*** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

Further Notes About Assessment Methods

None

Assessment Criteria

Assessment of the exams.

Language of Instruction

Turkish

Course Policies and Rules

Students will come to the class in time. Attending the 70% of the classes are mandotary.

Contact Details for the Lecturer(s)

E-mail: emel.kuruoglu@deu.edu.tr
Tel: 0 - 232 - 301 95 10

Office Hours

Will be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 14 2 28
Tutorials 14 2 28
Preparations before/after weekly lectures 14 2 28
Preparation for midterm exam 1 15 15
Preparation for final exam 1 20 20
Final 1 2 2
Midterm 1 1 1
TOTAL WORKLOAD (hours) 122

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13
LO.1423
LO.2523432
LO.35335442
LO.45335352
LO.55355555