Problem:
Question 1- Create an Entity Relationship Diagram (ERD) to represent the data requirements of the business. Use Microsoft Word or Visio to create this ERD. Note: if using Visio to create your ERD to save your assignment as a VSD file rather than as a Word document.
Question 2- Each entity must be named and the identifier(s) (primary key) listed. Include associate entities and supply identifiers for these also. If a primary key identifier is not specifically mentioned, create one! Make sure that you include identifiers for the associative entities also.
Question 3- Resolve Many-to-Many relationships into two relationships.
Question 4- All cardinalities and modalities should be clearly marked on the ERD. Attributes other than the identifiers may be included.
Submit your ERD in a Word document.
Please can anyone help me to answer these question in detail.