İstanbul KültürUniversity

Department of Computer Engineering

COURSE MODULE INFORMATION

2003/2004

 

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

 

 

Semester

5

 

Prerequisites

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*

Weight

(Points)

Submission Week

(assignments)

Length

(exam)

 

1

 

 

2

 

 

3

Assignment I:

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

Assignment II:  Database development

Attendance

25

 

 

 

20

 

5

W13

 

 

 

W 14

 

 

4

Written Examination

50

 

 

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

 

 

Reading

 

"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

 

Recommended:

"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

 

 

Awards

 

 

 

Degree Award(s)

Module Status

 

 

Computer Engineering

Core

Option

Computer Science

Core

Option

Information Systems

Core

Option

 

 

Date of initial approval:

 

 

Date set for re-validation: