I have attached Assignment 3 for reference - Please read the Question carefully. This is Assignment 4 that is requires Assignment 3 as a reference to solve Assignment 4. Do the following:

1. Map the ER diagram created in Assignment 3 into a relational schema
2. Show several records in each relation (create tables in either Excel or Access) showing sample data.
3. Mark/Write:
   1. The values that indicate mandatory participation on the 1 side.
   2. The values that indicate optional participation on the M side.

Evaluation Criteria

Your submission should include the following:

1. Original ERD (created in ERDPlus) from Assignment 3
2. Relational Schema mapping of the ERD from the diagram in step 1 above.
3. Two relations with sample data
4. Two statements:
   1. What are the values that indicate mandatory participation on the 1 side of the relationship.
   2. What the values that indicate the optional participation on the M side of the relationship BELOW is Assignmen 3 for reference Assignment 3 : Question

      You a paper and pencil to draw the required diagrams. You will learn how to use ERDPlus at the end of this week. The diagrams use the same shapes and connections mentioned in the book (the modified version of the standard Chen ER notation).

   3. Create the ER diagrams for a scenario based on these requirements:
      1. A health care organization keeps track of its doctors and outpatient locations.
      2. For each doctor it keeps track of the DoctorID (unique), DoctorName, and DoctorYearOfMDGraduation (year of graduating from medical school).
      3. For each outpatient location it keeps track of the OLID (unique) and OLName, and the following additional requirement:
      4. Each doctor works at exactly one outpatient location, and each outpatient location can have between none (rehab and minor health issues only) and many doctors working at it.

   4. Evaluation Criteria

      Your submission should have two diagrams, one for questions 1-3 (above) and one diagram for question 4.

      The first diagram (ERD) will have two entities and their attributes (3 and 2). The entities have a relationship. Make sure you draw the type of the relationship based on what you learned so far.

      The second diagram will be similar except for the type of relationship (hint).