413 9119 / 5440 9119

Course Detail

img
Database Administration 3 Months

Database administration

Course Information

  • Total Students 15 per class
  • Course Duration 3 Months

Description

Draw and interpret data models; Write simple and efective SQL statements; Design appropriate user interfaces; Produce working schemas

Course Outline

Title
1. Data management and application development techniques (e.g. Forms generators and programming tools). Programming environments applicable to a recognised DBMS
2. Comparison of a data-centred approach with file-based approach.
3. Data integrity and quality control. Transaction processing.
4. Logical and physical data independence how it is achieved.
5. Entity relationship diagrams and conceptual modelling
6. Relationship constraints and translation to relational model.
7. Functional Dependency theory and Normalisation.
8.Relational modelling
9. Simple relational algebra programs. Features of relational algebra in SQL.
10. Standards and basic structure of SQL for data definition, views, updates, insertion and referential integrity constraints.
11. Concurrency, recovery and database integrity
11. Client-server model as a distributed database architecture.