COURSE SCHEDULE

Week 1:

Basic concepts and definitions, Traditional File Processing Systems, History of databases,
Comparison of database approach and traditional file processing systems (advantages, disadvantages)


Week2:

Range of database applications, Components of a database environment,Database development within Information Systems Development, Information System Architecture(Overview), Information Engineering(Overview), Info System planning(Overview),Systems Development Life Cycle (SDLC), Process of SDLC in detail and its mapping to Database development process, Rapid Application development methods,

Week3:

Three Schema architecture of Database Development, Three tiered Database Location Architecture,

Week4:

Overview of Business Rules, Database Names and definitions, Translating Business rules to database model, E-R Model Notations and Diagram

Week5:

E-R Model constructs in detail ,Entities - their naming conventions and definitions,Relationships - their naming conventions and definitions,Attributes ¡V their naming conventions and definitions,Types of entities, types of attributes, types of relationships, cardinality constraints, multiple relationships,

Week6:

Concept of supertype and subtype entities. attribute inheritance, supertype - subtype relationships, Generalization specialization

Week7:

Supertype - subtype constraints, completeness constraints, Disjointness constraints, the concept of subtype discriminator, supertype-subtype hierarchies

Week8:

Entity Clustering concept, Business Rules revisited - classification of business rules,structural assertions, action assertions,Logical Database Design and Relational Data Modeling

Week9:

Exercise ER diagrams and End Problems
Related SQL concepts

Week10:

Relational data structure, Relational keys, Properties of relations in a relational model, Multivalued attributes - removing them from tables.Integrity constraints, Referential integrity constraints,

Week11:

creating relational tables, well-structured relations,
transforming EER into relations ,Mapping regular entities, weak entities, composite and multi-valued attributes,Mapping binary relationship ( one-to-one, one-to-many, many-to-many), Mapping associative entities, Mapping unary relationships(one-to-many, many-to-many), Mapping ternary and n-ary relationships, Mapping supertype/subtype relationships.

Week12:

Introduction to Normalization: Steps in normalization, functional dependencies and keys (determinants, candidate keys),Basic Normal forms of relations:
„X 1st Normal Form,
„X 2nd Normal Form,
„X 3rd Normal Form,
Normalizing Summary Data
Merging Relation, View Integration Problems (Homonyms, synonyms, Transitive dependencies, supertype/subtype relationships), Defining Relational keys.

Week13:

Physical Database Design and Performance
Introduction
Physical Database design Process
Data Volume and Usage Analysis
Designing Fields, choosing data types

Week14:

Designing Physical files(Unordered , ordered, hashed files),Designing Physical Records and Denormalization

Week15:

Managing Data security,Backing up database
Recovery of databases,

Week16:

Database architectures,Controlling concurrent access,Distributed database