1 Draw an appropriate ER diagram Use the symbols as prescribed in your course-textbook to draw the ER diagram (ERD) for the above case study. Your ERD must • show all necessary entities, attributes...

1    Draw an appropriate ER diagram
Use the symbols as prescribed in your course-textbook to draw the ER diagram (ERD) for the above case study.
Your ERD must
•    show all necessary entities, attributes and relationships
•    show identifiers/identifying attributes as necessary
•    show multi-valued attributes, if any
•    show participation and cardinality
•    show associative entities, if appropriate
•    show weak entities, if any
•    use the notation described in the set text
•    use consistent and appropriate naming for entities and attributes  as specified in the course text book


Some business rules or other aspects of the case study may not be clear to you when you read the case study. If this is the case, then you should either approach your lecturer or tutor for clarification, or you may simply make an assumption and then develop your ERD accordingly. For example, the case stud