DATAΒΑSES

Nowadays,Databases,either in a standalone setting or as an essential part of MIS,are invaluable assets of modern world class enterprises. The course presents, from both a theoretical and a practical viewpoint, the methodology for designing, implementing and optimizing Databases.

Objectives

At the end of the course the student should be able to design a database and both to implement and exploit it using an RDBMS (practicing on Microsoft Office Access)

Prerequisites

There are no prerequisite courses. It is, however, recommended that students have at least a basic knowledge of Office Automation

Syllabus

1.Describe the relational model, as well as other ones like network, hierarchical and object oriented models. 2.Use the Entity-Relation Diagram 3.Access data (Relational Algebra, SQ L,queries, etc.). 4.Describe Functional Dependencies and Normalization. 5.Describe modern RDBMs (distributed, multimedia , etc.). 6.Describe Database Security (privileges, security levels)