Course Description

Candidates will be able to demonstrate their competence in, and their ability to:
> Draw and interpret data models
> Write simple and effective SQL statements
> Design appropriate user interfaces
> Produce working schemes

What you" ll learn in this course?

• Data management and application development techniques (e.g Forms generators and programming tools). Programming environments applicable to a recognised DBMS.

• Comparison of data centered approach with file-based approach.

• Data integrity and quality control. Transaction processing.

• Logical and physical data independence how it is achieved.

• Entity relationship diagrams and conceptual modelling.

• Relationship constraints and translation to relational model.

• Functional Dependency theory and Normalisation.

• Relational modelling

• Simple relational algebro programs. Features of relational algebraic and SQL.

• Standards and basic structure of SQL for data definition, views, updates, insertion and referential integrity constraints.

• Concurrency, recovery and database integrity.

• Client-server model as a distributed database architecture.