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. |
