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

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 Yes

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!