COIS342

Course Number :

COIS 342

Name :

Databases

Credits :

4

Contact Hours :

42 Hrs. Lecture

28 Hrs. Lab

Course Coordinator’s Name :

Dr. Ahmed Hamza

Text Book :

Fundamentals of Database Systems 6th Addison-Wesley Publishing Company, USA ©2010 ISBN:0136086209-9780136086208.

Other References :

Concepts of Database Management by Pratt, Philip J. & Adamski, Joseph J., 7th Edition ,Thomson Learning, 2011, ISBN 10:1423901479, ISBN-13:9781423901471

1. Synopsis :

This course provides the students with an introduction to the core concepts in data and information management. It includes comprehensive coverage of the relational model, relational algebra, and SQL. The course will also include coverage of basic database administration tasks and key concepts of data quality and data security. In addition to developing database applications, the course helps the students understand how large-scale packaged systems are highly dependent on the use of DBMSs. Building on the transactional database understanding.

1. Prerequisites :

COIT 260-Fundamentals of Computing

1. Type of Course : :

Core

A

B

C

D

E

F

G

H

I

J

X

X

X

Number

Description

Duration in weeks

1

Introduction to Database Systems

1

2

Types of database management systems

1

3

Basic file processing and Physical data storage concepts

1

4

Database System Concepts and Architecture

1

5

Database System Concepts and Architecture..Cont.

1

6

The Relational Data Model and Relational Database Constraints

1

7

Relational Algebra and Relational Calculus

1

8

Relational Algebra and Relational Calculus..Cont.

1

9

Data modeling using the Entity-Relationship Model(Real world examples)

1

10

Enhanced Entity-Relationship (EER) Modeling

1

11

Enhanced Entity-Relationship (EER) Modeling..Cont.

1

12

ER-and-EER-to-Relational Mapping

1

13

Functional Dependences and Normalization

1

14

Functional Dependences and Normalization..Cont.

1