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

1    Draw an appropriate ER diagram
Use the symbols as prescribed in your unit-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 unit text book