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.