SIT103 - Introduction to Database Design
Unit details
| Enrolment modes: | (B, G, X) |
|---|---|
| EFTSL value: | 0.125 |
| Unit chair: | J Coldwell |
| Corequisite: | SIT010 |
| Incompatible with: | MSC217 |
| Contact hours: | 2 x 1 hour lectures, 1 x 2 hour practical per week |
Note:Online teaching methods require internet access. Please refer to the most current computer specifications. | |
Content
This unit will provide a solid foundation for the design, implementation and management of database systems. Data modelling is introduced, focusing on entity-relationship (ER) modelling. The skills required to construct such ER diagrams will be explored, with a focus on ensuring that the semantics of the model match those of the real-world it is representing. The relational data model will be presented and the functionality it affords will be explored. The process of constructing, maintaining and retrieving information from the database using SQL will be a focus of this unit. Key implementation and management concepts, including transaction management and concurrency control, and database backup and recovery will be investigated. The impact of new technologies on database design, particularly the Internet, will be covered briefly.