Apply 1NF, 2NF and 3NF in database as in Figure 1 below. Criteria Able to identify...

    

Transcribed Image Text:

Apply 1NF, 2NF and 3NF in database as in Figure 1 below. Criteria Able to identify keys Able to identify dependencies Able to transform to 2NF Able to transform to 3NF Weight 1 1 1 1 Bad (1Mark) The list of identify list does make sense at all. The list of identify list does make sense at all. 2NF does make sense at all. 3NF does make sense at all. Weak (2Marks) The identify list was very superficial and poorly done. The identify list was very superficial and poorly done. 2NF was very superficial and poorly done. 3NF was very superficial and poorly done. Moderate (3 Mark) Basic/Minimal identify Basic/Minimal identify Basic/Minimal 2NF Basic/Minimal 3NF Good identify but there is a space to add more Good (4Marks) points/answer S. Good identify but there is a space to add more points/answer S. Good 2NF but there is a space to add more points/answer S. Good 3NF but there is a space to add more points/answer S. Excellent (5 Marks) Excellent identify completely. Excellent identify completely. Excellent 2NF completely. Excellent 3NF completely. Total Marks 5 5 Invoice details Inv. no. 123 123 123 124 124 Date Customer 01/29/2018 John Public 01/29/2018 John Public 01/29/2018 John Public 01/30/2018 Jane Doe 01/30/2018 Jane Doe Cust. no. 11 11 11 12 12 Address 35 Wood Lane, Springfield, ME 04487 35 Wood Lane, Springfield, ME 04487 35 Wood Lane, Springfield, ME 04487 72 Windy Road, Springfield, ME 04487 Inv. item no. 1 2 3 1 72 Windy Road, Springfield, ME 2 04487 Product Monitor Chair Mousepad 4-0023-D 12 Laptop Prod no. Headset 2-0023-D 10 5-0023-D 1 1-0023-D 2 3-0023-D 2 $200 50 $120 $1,200 $75 ASSIGNMENT 2 TBTM 2033 DATABASE SYSTEM Normalization is a database design technique that reduces data redundancy and eliminates undesirable characteristics like Insertion, Update and Deletion Anomalies. Normalization rules divides larger tables into smaller tables and links them using relationships. The purpose Normalization in SQL is to eliminate redundant (repetitive) data and ensure data is stored logically. Here is a list of Normal Forms: . 1NF (First Normal Form) 2NF (Second Normal Form) 3NF (Third Normal Form) BCNF (Boyce-Codd Normal Form) 4NF (Fourth Normal Form) 02/24/2021 QUESTION Apply 1NF, 2NF and 3NF in database as in Figure 1 below. Apply 1NF, 2NF and 3NF in database as in Figure 1 below. Criteria Able to identify keys Able to identify dependencies Able to transform to 2NF Able to transform to 3NF Weight 1 1 1 1 Bad (1Mark) The list of identify list does make sense at all. The list of identify list does make sense at all. 2NF does make sense at all. 3NF does make sense at all. Weak (2Marks) The identify list was very superficial and poorly done. The identify list was very superficial and poorly done. 2NF was very superficial and poorly done. 3NF was very superficial and poorly done. Moderate (3 Mark) Basic/Minimal identify Basic/Minimal identify Basic/Minimal 2NF Basic/Minimal 3NF Good identify but there is a space to add more Good (4Marks) points/answer S. Good identify but there is a space to add more points/answer S. Good 2NF but there is a space to add more points/answer S. Good 3NF but there is a space to add more points/answer S. Excellent (5 Marks) Excellent identify completely. Excellent identify completely. Excellent 2NF completely. Excellent 3NF completely. Total Marks 5 5 Invoice details Inv. no. 123 123 123 124 124 Date Customer 01/29/2018 John Public 01/29/2018 John Public 01/29/2018 John Public 01/30/2018 Jane Doe 01/30/2018 Jane Doe Cust. no. 11 11 11 12 12 Address 35 Wood Lane, Springfield, ME 04487 35 Wood Lane, Springfield, ME 04487 35 Wood Lane, Springfield, ME 04487 72 Windy Road, Springfield, ME 04487 Inv. item no. 1 2 3 1 72 Windy Road, Springfield, ME 2 04487 Product Monitor Chair Mousepad 4-0023-D 12 Laptop Prod no. Headset 2-0023-D 10 5-0023-D 1 1-0023-D 2 3-0023-D 2 $200 50 $120 $1,200 $75 ASSIGNMENT 2 TBTM 2033 DATABASE SYSTEM Normalization is a database design technique that reduces data redundancy and eliminates undesirable characteristics like Insertion, Update and Deletion Anomalies. Normalization rules divides larger tables into smaller tables and links them using relationships. The purpose Normalization in SQL is to eliminate redundant (repetitive) data and ensure data is stored logically. Here is a list of Normal Forms: . 1NF (First Normal Form) 2NF (Second Normal Form) 3NF (Third Normal Form) BCNF (Boyce-Codd Normal Form) 4NF (Fourth Normal Form) 02/24/2021 QUESTION Apply 1NF, 2NF and 3NF in database as in Figure 1 below.

Answer rating: 100% (QA)

Normalization in databases is the process of structuring a relational database in accordance with a series of socalled normal forms in order to reduce ... View the full answer