A Queensland based car parts retailer wish to improve their customers' experience by offering an online information system called My Workshop. Through My Workshop, customers will be able to find and then purchase the right parts for their vehicles with ease by entering their vehicle registration number and the state that their vehicle is registered. Each state is associated with a code. For example, QLD is the code for Queensland. A registration number may be registered in different states, so a vehicle can only be identified by the combination of state and registration number. To find suitable parts for a vehicle, My Workshop needs to know its make (i.e. the manufacturer of the vehicle, e.g., Toyota), model (e.g. Corolla), year of manufacture (e.g. 2010), series number (e.g. ZRE152R) or chassis number, engine (e.g. 1.8 litre, 2ZRFE 1416V DOHC VVT MPFI {100KW} ), and details (e.g. 05/2007 09/2012 4 Door Hatchback FWD AT MT Japan). The following table shows some examples (For simplicity, only three vehicles are listed here). Car parts are grouped under several categories and displayed accordingly. Customers can browse each category, and then add desirable parts to their shopping cart. The allocated with a unique part code, and it also has a meaningful name, and may have a description. A part is manufactured by a manufacturer. A part can belong to two different categories. \begin{tabular}{|l|l|l|l|} \hline Category number:09212 & name: Suspension \\ \multicolumn{1}{|c|}{ Part name } & Mamfacturer & Description \\ \hline part code & Pane & \\ \hline \end{tabular} Quantity sold and net revenue for each month is also totaled. This table is updated on a monthly basis. Your task is to design the conceptual information models for the above scenario, using two different modelling languages, that each characterize an effective and efficient way to represent the information described in the above scenario. See the Deliverables section below for more details of what is required. DELIVERABLES: You are required to submit the following items for Task 1: 1. A list of elementary facts that fully and explicitly verbalise the fact types contained in the scenario description. 2. A conceptual schema model produced using the Object Role Modelling (ORM) language, which fully captures all of the fact types and any necessary constraints. Include all relevant fact types (unary or binary), entities, uniqueness constraints (internal or external), mandatory role constraints (simple or disjunctive), value constraints, etc. If a fact type or subtype is derived, include it on the diagram and provide its derivation rule. Derivation rules may be specified informally using any notation that conveys the intended meaning. You must also discuss Step 4 and 5. For example, why here you have One-to-One relationships, Mandatory constraints, etc. Hint: See below, a starting point for your model. Complete the drawing of the ORM conceptual schema proposed below for the universe of discourse specified in the scenario by performing all steps of the Conceptual Schema Design Procedure, as requested above. 3. A conceptual schema model produced using the Entity Relationship Diagram (ERD) language, using the Barker notation, which fully captures all of the fact types and any necessary constraints. 4. A textual description of the ERD model, prepared for the business owner, as an aid to communicating and understanding the less obvious features of the model 5. A textual description of the ORM model, prepared for the business owner, as an aid to communicating and understanding the less obvious features of the model First, compare and contrast the two languages used to model the scenario in Step 1. Then, discuss the following questions: Did you find one language easier to use than the other? Were there any aspects of the scenario that were difficult to model? In your opinion, did one language produce a "better" model in terms of the quality criteria? A Queensland based car parts retailer wish to improve their customers' experience by offering an online information system called My Workshop. Through My Workshop, customers will be able to find and then purchase the right parts for their vehicles with ease by entering their vehicle registration number and the state that their vehicle is registered. Each state is associated with a code. For example, QLD is the code for Queensland. A registration number may be registered in different states, so a vehicle can only be identified by the combination of state and registration number. To find suitable parts for a vehicle, My Workshop needs to know its make (i.e. the manufacturer of the vehicle, e.g., Toyota), model (e.g. Corolla), year of manufacture (e.g. 2010), series number (e.g. ZRE152R) or chassis number, engine (e.g. 1.8 litre, 2ZRFE 1416V DOHC VVT MPFI {100KW} ), and details (e.g. 05/2007 09/2012 4 Door Hatchback FWD AT MT Japan). The following table shows some examples (For simplicity, only three vehicles are listed here). Car parts are grouped under several categories and displayed accordingly. Customers can browse each category, and then add desirable parts to their shopping cart. The allocated with a unique part code, and it also has a meaningful name, and may have a description. A part is manufactured by a manufacturer. A part can belong to two different categories. \begin{tabular}{|l|l|l|l|} \hline Category number:09212 & name: Suspension \\ \multicolumn{1}{|c|}{ Part name } & Mamfacturer & Description \\ \hline part code & Pane & \\ \hline \end{tabular} Quantity sold and net revenue for each month is also totaled. This table is updated on a monthly basis. Your task is to design the conceptual information models for the above scenario, using two different modelling languages, that each characterize an effective and efficient way to represent the information described in the above scenario. See the Deliverables section below for more details of what is required. DELIVERABLES: You are required to submit the following items for Task 1: 1. A list of elementary facts that fully and explicitly verbalise the fact types contained in the scenario description. 2. A conceptual schema model produced using the Object Role Modelling (ORM) language, which fully captures all of the fact types and any necessary constraints. Include all relevant fact types (unary or binary), entities, uniqueness constraints (internal or external), mandatory role constraints (simple or disjunctive), value constraints, etc. If a fact type or subtype is derived, include it on the diagram and provide its derivation rule. Derivation rules may be specified informally using any notation that conveys the intended meaning. You must also discuss Step 4 and 5. For example, why here you have One-to-One relationships, Mandatory constraints, etc. Hint: See below, a starting point for your model. Complete the drawing of the ORM conceptual schema proposed below for the universe of discourse specified in the scenario by performing all steps of the Conceptual Schema Design Procedure, as requested above. 3. A conceptual schema model produced using the Entity Relationship Diagram (ERD) language, using the Barker notation, which fully captures all of the fact types and any necessary constraints. 4. A textual description of the ERD model, prepared for the business owner, as an aid to communicating and understanding the less obvious features of the model 5. A textual description of the ORM model, prepared for the business owner, as an aid to communicating and understanding the less obvious features of the model First, compare and contrast the two languages used to model the scenario in Step 1. Then, discuss the following questions: Did you find one language easier to use than the other? Were there any aspects of the scenario that were difficult to model? In your opinion, did one language produce a "better" model in terms of the quality criteria