Question: SCENARIO Use the data as shown in Table 1 and Table 2 to come up an ORM information/data model for Task 1 requirements. Table 1

SCENARIO Use the data as shown in Table 1 andSCENARIO Use the data as shown in Table 1 and

SCENARIO Use the data as shown in Table 1 and Table 2 to come up an ORM information/data model for Task 1 requirements. Table 1 - COVID Variants known to be originated with date and country information Date known to Covid Variant Country Originated be originated SARS-CoV-2 China Dec. 2019 B.1.1.7 UK Oct. 2020 B.1.351 South Aftrica Jan. 2021 P.1 Brazil Jan. 2021 Table 2 - Patients' details infected by various COVID variants, the country they belong to and outcomes after infections Patient Name Date effected Varient Country Recovered Death Jason Li 18/12/2019 SARS-CoV-2 China Yes Ramesh Lal 19/01/2020 SARS-CoV-2 India Yes John Smith 20/12/2020 B.1.1.7 UK Yes Liam Luski 1/01/2021 B.1.1.7 Australia Yes Enzokuhle Dlamini 15/01/2021 B.1.1.7 South Africa Yes Robert Smith 20/01/2021 B.1.351 UK Yes Christopher Mission 2/02/2021 P.1 US Yes TASK 1 (15 Marks) Your task is to design an information (data) model that suggests an effective and efficient way for storing data of an Australian government agency working in the health area. As you are an expert in ORM, you decide to develop an ORM model. Complete the drawing of the ORM conceptual schema for the universe of discourse as specified in the tables as shown in scenario above by performing steps 1-5 as described below of the Conceptual Schema Design Procedure. CSDP Step 1: Transform familiar examples into elementary facts and apply quality checks. CSDP Step 2: Draw the fact types and apply a population check. CSDP Step 3: Check for entity types to be combined and note any arithmetic derivations. CSDP Step 4: Add uniqueness constraints and check the arity (length) of fact types. CSDP Step 5: Add mandatory role constraints

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!