Assignment $5$ is to be completed after Module $5.$ It is worth $9\%$ of your final mark, and is graded with a total of $40$ marks, $10$ per question.

The assignment is based on the Erehwon Fabrications case study presented in the attached document $($attached below$).$ Use this information to answer the four questions following.

Work to be Submitted

Submit a $.$zip file named COMP$3611\_$Assignment$5$ that contains:

A Word document $($question $1)$

Conceptual data model diagram $($question $2)$

Logical data model diagram $($question $3)$

Physical data model diagram $($question $4)$

Instructions

Read the Erehwon Fabrications case study $($attached below$).$ Using the information provided, start to identify the entity types and associated attributes. Use your analysis of the case study to create six $(6)$ user views:

Two $(2)$ specific to the job function of the Personnel Officer

Two $(2)$ specific to the job function of the Line Supervisor.

Two $(2)$ specific to the job function of the Managing Director.

The six views created must be different and appropriate to the job function of the individual that can access the view. This may be done textually or in a format similar to Figure $16\mathrm{.}4.$ This work should be done in a Microsoft Word document. Record any assumptions that you make in specifying the views.

Create a conceptual data model that supports these user views and the rest of the case study. This may be done in a drawing tool such as Microsoft Visio rather than Oracle Data Modeler $($see Figures $16\mathrm{.}5$ and $16\mathrm{.}5$ plus Exercise $16\mathrm{.}16$ solution as examples$).$

Create a logical data model for a relational schema using Oracle Data Modeler or other drawing tool such as Microsoft Visio. This may also be done in a Microsoft Word document showing the relations $($see Figure $17\mathrm{.}3$ or Exercise $17\mathrm{.}10$ solution as examples$).$

Create a physical $($relational$)$ database design using Oracle Data Modeler or other drawing tool such as Microsoft Visio. A DDL script is not acceptable.