Question: Lab 4 First Normal Form (pts. 3) Submission requirements: Note: Wo ck submitted must belong to you, if it matches with someone else, your work

Lab 4 First Normal Form (pts. 3) Submission requirements: Note: Wo ck submitted must belong to you, if it matches with someone else, your work will be graded as 0 and will be reported to Associate Dean. - Use any software to draw ERD. Take screen capture of the data model and embed it under the question. - Complete rest of the questions in the same document. Resave the document with your name_lab\#_fl__(Eg_Amrit_lab\#_fb) - SUBMIT ONLY WORD DOCUMENT, PDF or COPY PASTE YOUR ANSWER IN THE TEXT AREA PROVIDED. - Submit the document in link provided in assignment section. OR complete the lab manually and submit the hardcopy. Note: if there is many to many relationship exists between entities, it must be resolved. INIOICE table: Based on the unnormalized data given in the Invoice table, Analyse the given attributes for 1st Normal form, If they are not in 1st NF then make the necessary changes to correct them. a. Perform this task, two ways: 1. Single table solution and List the violations that will be created by using single table solution (pts 1.5): a. Updating: b. Insertion: c. Deletion: 2. Elimination of multivalued attribute into a separate entity. Draw the correct data model to relate the entities. (pts 1.5)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
