Theteacher.info's complete student
workbook on relational database modelling and normalisation
Student workbook
We have created a Student Workbook that takes you through all of the steps needed to fully understand and apply relational database modelling. You have to start at the beginning with this topic and that is what we have done, beginning with flat files, then working through high level design and E-R diagrams, logical schema and then setting up the design. We show you lots of examples, simple ones to start with and then more complex ones, building up your knowledge step-by-step and getting you to do practice designs. The booklet represents approximately 8 hours of work. The topics covered include:
-
- What is a relational database and why bother?
- Flat files
- Improving the flat file design
- E-R diagrams and normalisation together
- One-to-many relationships
- Many-to-many relationships
- Resolving many-to-many relationships
- One-to-one relationships
- Producing E-R diagrams
- Summary of E-R diagrams
- Using normalisation to produce a relational database design0
- Setting up the Analysis Table
- UNF to 1 NF
- 1 NF to 2NF
- 2NF to 3NF
- Normalising a bank’s customer database
- Normalising a student record database
- Normalising a stock database
- Normalising an employment agency database
- Normalising a travel agency database
- An alternative notation
- Summary of normalisation
- Further reading
- Answers to all questions
You can get access to the Student workbook here.