İstanbul KültürUniversity

Department of Computer Engineering




Module Code: CS 532



Module Name:  Introduction to Database Management Systems (DBMS)


Level: 3 (Sem.5)



Credit Value: (3+2) 4 Credit/hours


Course Description and Rationale

The Databases module is designed to enable the student to understand the concepts inherent in the use of a database as an information storage and retrieval tool, and to appreciate the concept of a relational database and the need for the implementation of appropriate design activities in order to exploit its power.



Aims and Objectives

To enable the student to appreciate the advantages and disadvantages in the use of a computerised database.


To develop student awareness of the flow of management information within a business as a context for the implementation of information systems.


To enable the student to appreciate the importance of the design phase in the implementation of relational database systems.


To introduce the student to the techniques involved in the implementation of relational database systems.


To provide the student with the opportunity to develop core skills such as communication, task management and problem solving skills.



Module Co-ordinator

Yrd.Doç.Dr. Kemal YÜKSEK







CS431 Structured System Analysis & Design


Learning Outcomes

Upon completion of this course module, the student should have an understanding of the following:


· The advantages and disadvantages of database use

· Management Information and the role of databases

· Fields, attributes, data types, tabular representation and entities

· Relational databases

· Entity relationships and the entity object model

· Using Relational Database Management Systems

· Creating entities

· Normalisation

· Understanding SQL




Learning Outcomes (Practical)

·         Hands-on experience of a DBMS software product (ACCESS2000)

·         Customisation of a DBMS sofware product

·         Database application development in relation to a set of user requirements.


Learning Strategies

The module will be delivered in a series of lectures, supported by practical sessions in a computing laboratory and self-directed study  on the part of the student.


The lectures will consist of delivery of the course material and will contain supporting  material for the practicals.


The practical sessions will consist of "hands-on" use of appropriate systems and software in the resolution of data storage and retrieval  problems (MS ACCESS database software system).



Assessment Details

The module will be assessed by an in-course assessment and by an end of semester examination.


The in-course assessment will comprise the practicals and an assignment based on the analysis of a business data storage and retrieval problem  using industry standard IT tools.


The end of semester examination will cover the theoretical part of the module which includes structures of databases and analysing data for the design and development of relational database management systems.


Course Module Assessment


Assessment No.

Assessment Type*



Submission Week












Assignment I:

Topic 1-25 Access 2000, An Advanced Course for Student

Assignment II:  Database development













W 14




Written Examination




2 hr











Outline Teaching Schedule

1) Introduction to databases, database processing

2) Introduction to database development

3) Data models, entity relationship model

4) Relational model

5) Relational data and data manipulation

6) Database design

7) Database application development

8) ) Database application development

9) Database forms and reports

10) Introduction to SQL

11) Normalisation

12) Relational implementation of personal databases

13) Managing Information Systems

14) Review of the semesters’s subjects





"ACCESS 2000 An Advanced Course for Student, Coles, S., Rowley, J., DPP, 2000.

“Introduction to Relational Databases”, C.J. Date

"Database Processing", Kroenke, D. M., Prentice-Hall, 1998.

 “Relational Database Principles” Colin Ritchie



"Data Processing and Information Technology", French, C. S., DPP, 1993.

"Database Design", Batini, C., Ceri, S., Navathe, S., Addison-Wesley, 1991.

"The Practical SQL Handbook", Bowman, J. S., Emerson, S. L., Darnovsky, M., Addison-Wesley, 1993.






Home Department

Computer Engineering







Degree Award(s)

Module Status



Computer Engineering



Computer Science



Information Systems





Date of initial approval:



Date set for re-validation: