1. (12 points) Produce your conceptual model using the Crow's Foot notation by following the procedures below: a. Extract (or define) business rules from the data--please keep in mind that your business rules are an important source (1) to define data types and integrity, (2) to infer events (or weak entities), and (3) to determine cardinality. i. Please list up business rules about primary key and foreign key (3 points) ii. Please list up business rules about cardinality (4 points) b. Determine strong entities. C. Construct a relationship matrix (You can use Word or Excel) (2 points). i. Inferred events in terms of verbs) will be your weak entities. d. Draw a Crow's Foot diagram (You can use Visio or Lucidchart). i. Display primary key (1 point)/foreign key (1 point)/cardinality (1 point). i.e.,) a Crow's Foot by Visio I Patents imento Invent NO to D Istent No MO Title Invest de State 2. (15 points) Convert your conceptual model using DDL (Data Definition Language) into a physical model (use SQL Server). a. Create strong entities by following naming convention- Table YourFirstLastName (i.e., Movies JaebongSon) 1. Entity integrity must be implemented b. Create weak entities 1. Referential integrity must be implemented il. Entity integrity must be implemented c. Draw your physical model using SQL Server 1.e.,) an ERD by SQL Server (3 points) Your screenshot of data retrieval (No DML is required-i.e., INSERT INTO ... VALUES ...; Only screenshots of data retrieval are needed) a. Data Insertion i. Insert data into your strong entities ii. Then, insert data into your weak entities iii. Retrieve data from each table using SELECT ... FROM ... (No need to join tables at this moment) 1. One screenshot per table is required. i.e.,) a screenshot of data retrieval 1 2 3 4 Empl No Full Name Phone No Age 125 Maria Martinez 720-541-1328 22 126 Jaebong Son 877-755-7756 43 23 James Smith 520-112-3321 34 Robert Garcia 530-343-7734 67 Department Marketing Consulting Sales (NA) 2525 1. (12 points) Produce your conceptual model using the Crow's Foot notation by following the procedures below: a. Extract (or define) business rules from the data--please keep in mind that your business rules are an important source (1) to define data types and integrity, (2) to infer events (or weak entities), and (3) to determine cardinality. i. Please list up business rules about primary key and foreign key (3 points) ii. Please list up business rules about cardinality (4 points) b. Determine strong entities. C. Construct a relationship matrix (You can use Word or Excel) (2 points). i. Inferred events in terms of verbs) will be your weak entities. d. Draw a Crow's Foot diagram (You can use Visio or Lucidchart). i. Display primary key (1 point)/foreign key (1 point)/cardinality (1 point). i.e.,) a Crow's Foot by Visio I Patents imento Invent NO to D Istent No MO Title Invest de State 2. (15 points) Convert your conceptual model using DDL (Data Definition Language) into a physical model (use SQL Server). a. Create strong entities by following naming convention- Table YourFirstLastName (i.e., Movies JaebongSon) 1. Entity integrity must be implemented b. Create weak entities 1. Referential integrity must be implemented il. Entity integrity must be implemented c. Draw your physical model using SQL Server 1.e.,) an ERD by SQL Server (3 points) Your screenshot of data retrieval (No DML is required-i.e., INSERT INTO ... VALUES ...; Only screenshots of data retrieval are needed) a. Data Insertion i. Insert data into your strong entities ii. Then, insert data into your weak entities iii. Retrieve data from each table using SELECT ... FROM ... (No need to join tables at this moment) 1. One screenshot per table is required. i.e.,) a screenshot of data retrieval 1 2 3 4 Empl No Full Name Phone No Age 125 Maria Martinez 720-541-1328 22 126 Jaebong Son 877-755-7756 43 23 James Smith 520-112-3321 34 Robert Garcia 530-343-7734 67 Department Marketing Consulting Sales (NA) 2525