Question: 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 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.
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 Yes Liam Luski 1/01/2021 B.1.1.7 Australia 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 UK YesStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
