Provide a discussion of normalisation including the normal form that each entity is in, a list of relationships with all table names, primary and foreign keys, and attributes indicating their type and purpose.
Design a relational database for a provided scenario utilising tools and techniques including ER diagrams, relation models and normalisation
Describe relational algebra and its relationship to Structured Query Language (SQL)
Design and implement a relational database using a database management system.
A course type can have only one type of pre requisite.
The bank detail for the Monthly payment will be saved whether it is regular or automatic.
There may be many courses of a course type.
A member may join many courses and take any number classes.
Each course type will have a name.
Each course of specific course type will also have a name.