DATABASES II

The course includes analytical approach and study of database (DB) systems and their practical use, and further familiarity with the subject, so as to deepen the student to concepts already taught in the introductory course Databases I and to learn new concepts and knowledge areas related to the subject. Upon completion of this course, the student will be able to apply its knowledge to design a normalized DB and optimize its performance as well as to implement DBs in one of the major DB Management Systems, using SQL, security techniques and integrity constraints.

Objectives

Upon completion of this course the student will be able to apply his knowledge to design a normalized DB and optimize its performance. Also, you can implement the NW at one of the major NW Systems Management market, using SQL, security and integrity techniques.

Prerequisites

Data Bases I

Syllabus

<ul> <li> Higher Normal Forms (4th KM, 5th AF) <li> The Entity-Relationship Model <li> Relational Calculus I <li> Relational Calculus II <li> Opinions <li> Recovery <li> concurrency <li> Security <li> Integrity </ ul>