- Normalize each example.
- Following the instructions to create normalized data tables and ER diagrams.
B D E F G H L M Part 1 of 4 Normalize the following data to 3NF. 1. Modify the data tables 5 2. Add sample records. 3. Create an ER diagram of the relations between tables. 7 8 Notes 9 Include each of the tables you would need to represent all of the data listed below. 10 Indicate a primary key field for each table. 11 . Do add field(s) as and if needed to create a primary key or as and if needed to provide needed information. 12 Do indicate the relationship between tables by indicating the FKs. 13 Do eliminate field(s) that are unnecessary. 14 If your modification includes adding a field or a table, do not leave it blank -all fields and tables must contain complete data. 15 . Analyze the relations between tables and create an ER diagram with PKS, FKs, and joins that represents these relationships. Include the diagram on this tab. 16 Include the ER diagram on this tab. 17 18 Data BEFORE normalization 19 Student Name Program(s) of Interest 20 21 Maya Lee Accounting, Business Management 22 Sam Rukowski Digital Media Arts 23 Su Smith Digital Media Arts, Information Systems 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Part 1 Part 2 Part 3 Part 4 + B D E G H I K L M N 0 P Part 2 of 4 Normalize the following data to 3NF. 1. Modify the data tables 2. Add sample records. 3. Create an ER diagram of the relations between tables. 7 8 Notes 9 Include each of the tables you would need to represent all of the data listed below. 10 Indicate a primary key field for each table. 11 Do add field(s) as and if needed to create a primary key or as and if needed to provide needed information. 12 . Do indicate the relationship between tables by indicating the FKS. 13 . Do eliminate field(s) that arelunnecessary. 14 If your modification includes adding a field or a table, do not leave it blank -all fields and tables must contain complete data. 15 . Analyze the relations between tables and create an ER diagram with PKS, FKs, and joins that represents these relationships. Include the diagram on this tab. 16 Include the ER diagram on this tab. 17 18 Data BEFORE normalization 19 TutorFirstName TutorLastName TutorSubject1 TutorSubiecta TutorSubject3 20 21 Larry Jones BUSIT103 ENGL101 PROG110 22 Jin Peters ENGL 101 23 Marta Foye BUSIT103 BUSITIOS 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Part 1 Part 2 Part 3 Part 4 + D E F Part 3 of 4 Leaf 3 Normalize the following data to 3NF. 1. Modify the data tables 2. Add sample records. 3. Create an ER diagram of the relations between tables. 7 8 Notes 9 Include each of the tables you would need to represent all of the data listed below. 10 Indicate a primary key field for each table. 11 . Do add field(s) as and if needed to create a primary key or as and if needed to provide needed information. 12 . Do indicate the relationship between tables by indicating the FKs. 13 Do eliminate field(s) that are unnecessary. 14 If your modification includes adding a field ctr a table, do not leave it blank-all fields and tables must contain complete data. 15 . Analyze the relations between tables and create an ER diagram with PKS, FKs, and joins that represents these relationships. Include the diagram on this tab. 16 Include the ER diagram on this tab. 17 18 Data BEFORE normalization Crop family planted in Garden Bed1 Crop family planted in GardenBed2 Season Crop family planted in GardenBed3 Crop family planted in GardenBed4 19 (Location: NW corner of field) (Location: NE comer of field) (Location: SW comer of field) (Location: Se corner of field) 20 21 Spring 2014 Legume Roots Fruit 22 Spring 2015 Fruit Legume Leaf 23 Spring 2016 Roots Legume Leaf 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Part 1 Part 2 Part 3 Part 4 + B C D E G . J L . N 0 P Q R Part 4 of 4 Normalize the following data to 3NF. 1. Modify the data tables 2. Add sample records. 3. Create an ER diagram of the relations between tables. 7 8 Notes 9 Include each of the tables you would need to represent all of the data listed below. 10 Indicate a primary key field for each table. 11 . Do add field(s) as and if needed to create a primary key or as and if needed to provide needed information. 12 Do indicate the relationship between tables by indicating the FKs. 13 Do eliminate field(s) that are unnecessary. 14 If your modification includes adding a field or a table, do not leave it blank -all fields and tables must contain complete data. 15 . Analyze the relations between tables and create an ER diagram with PKS, FKs, and joins that represents these relationships. Include the diagram on this tab. 16 . Include the ER diagram on the stab. 17 18 Data BEFORE normalization 19 ContactID FirstName LastName DayPhone Mobile Phone Evening Phone 20 21 1 Jin Peters |(206)222-1234 (206) 222-1235 22 2 Larry Jones (206) 222-1235 (206) 222-1236 (425) 499-8909 23 3 Marta Foye 11425) 564-9876 24 4 Ann Harris (425) 564-9877 (425) 564-9878 25 5 Sam Wu (425) 564-9878 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Part 1 Part 2 Part 3 Part 4 + B D E F G H L M Part 1 of 4 Normalize the following data to 3NF. 1. Modify the data tables 5 2. Add sample records. 3. Create an ER diagram of the relations between tables. 7 8 Notes 9 Include each of the tables you would need to represent all of the data listed below. 10 Indicate a primary key field for each table. 11 . Do add field(s) as and if needed to create a primary key or as and if needed to provide needed information. 12 Do indicate the relationship between tables by indicating the FKs. 13 Do eliminate field(s) that are unnecessary. 14 If your modification includes adding a field or a table, do not leave it blank -all fields and tables must contain complete data. 15 . Analyze the relations between tables and create an ER diagram with PKS, FKs, and joins that represents these relationships. Include the diagram on this tab. 16 Include the ER diagram on this tab. 17 18 Data BEFORE normalization 19 Student Name Program(s) of Interest 20 21 Maya Lee Accounting, Business Management 22 Sam Rukowski Digital Media Arts 23 Su Smith Digital Media Arts, Information Systems 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Part 1 Part 2 Part 3 Part 4 + B D E G H I K L M N 0 P Part 2 of 4 Normalize the following data to 3NF. 1. Modify the data tables 2. Add sample records. 3. Create an ER diagram of the relations between tables. 7 8 Notes 9 Include each of the tables you would need to represent all of the data listed below. 10 Indicate a primary key field for each table. 11 Do add field(s) as and if needed to create a primary key or as and if needed to provide needed information. 12 . Do indicate the relationship between tables by indicating the FKS. 13 . Do eliminate field(s) that arelunnecessary. 14 If your modification includes adding a field or a table, do not leave it blank -all fields and tables must contain complete data. 15 . Analyze the relations between tables and create an ER diagram with PKS, FKs, and joins that represents these relationships. Include the diagram on this tab. 16 Include the ER diagram on this tab. 17 18 Data BEFORE normalization 19 TutorFirstName TutorLastName TutorSubject1 TutorSubiecta TutorSubject3 20 21 Larry Jones BUSIT103 ENGL101 PROG110 22 Jin Peters ENGL 101 23 Marta Foye BUSIT103 BUSITIOS 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Part 1 Part 2 Part 3 Part 4 + D E F Part 3 of 4 Leaf 3 Normalize the following data to 3NF. 1. Modify the data tables 2. Add sample records. 3. Create an ER diagram of the relations between tables. 7 8 Notes 9 Include each of the tables you would need to represent all of the data listed below. 10 Indicate a primary key field for each table. 11 . Do add field(s) as and if needed to create a primary key or as and if needed to provide needed information. 12 . Do indicate the relationship between tables by indicating the FKs. 13 Do eliminate field(s) that are unnecessary. 14 If your modification includes adding a field ctr a table, do not leave it blank-all fields and tables must contain complete data. 15 . Analyze the relations between tables and create an ER diagram with PKS, FKs, and joins that represents these relationships. Include the diagram on this tab. 16 Include the ER diagram on this tab. 17 18 Data BEFORE normalization Crop family planted in Garden Bed1 Crop family planted in GardenBed2 Season Crop family planted in GardenBed3 Crop family planted in GardenBed4 19 (Location: NW corner of field) (Location: NE comer of field) (Location: SW comer of field) (Location: Se corner of field) 20 21 Spring 2014 Legume Roots Fruit 22 Spring 2015 Fruit Legume Leaf 23 Spring 2016 Roots Legume Leaf 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Part 1 Part 2 Part 3 Part 4 + B C D E G . J L . N 0 P Q R Part 4 of 4 Normalize the following data to 3NF. 1. Modify the data tables 2. Add sample records. 3. Create an ER diagram of the relations between tables. 7 8 Notes 9 Include each of the tables you would need to represent all of the data listed below. 10 Indicate a primary key field for each table. 11 . Do add field(s) as and if needed to create a primary key or as and if needed to provide needed information. 12 Do indicate the relationship between tables by indicating the FKs. 13 Do eliminate field(s) that are unnecessary. 14 If your modification includes adding a field or a table, do not leave it blank -all fields and tables must contain complete data. 15 . Analyze the relations between tables and create an ER diagram with PKS, FKs, and joins that represents these relationships. Include the diagram on this tab. 16 . Include the ER diagram on the stab. 17 18 Data BEFORE normalization 19 ContactID FirstName LastName DayPhone Mobile Phone Evening Phone 20 21 1 Jin Peters |(206)222-1234 (206) 222-1235 22 2 Larry Jones (206) 222-1235 (206) 222-1236 (425) 499-8909 23 3 Marta Foye 11425) 564-9876 24 4 Ann Harris (425) 564-9877 (425) 564-9878 25 5 Sam Wu (425) 564-9878 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Part 1 Part 2 Part 3 Part 4 +
