Grading Rubric for CSIS 325 Module 7 Lab 7 Based on 40-point maximum Criteria Content 70% Lab Questions Levels of Achievement Advanced 90-100% Proficient 70-89% Developing 1-69% Not present 25 to 28 Points 20 to 24 points 1 to 19 points 0 points At least 10 to 8 of the questions were answered correctly Structure 30% Screenshots First Normal Form (1NF) At least 7 to 5 of the questions At least 4 to 1 of the questions Did not attempt questions were answered correctly

Subject:SociologyPrice:12.89 Bought3

Share With

Grading Rubric for CSIS 325 Module 7 Lab 7 Based on 40-point maximum Criteria Content 70% Lab Questions Levels of Achievement Advanced 90-100% Proficient 70-89% Developing 1-69% Not present 25 to 28 Points 20 to 24 points 1 to 19 points 0 points At least 10 to 8 of the questions were answered correctly Structure 30% Screenshots First Normal Form (1NF) At least 7 to 5 of the questions At least 4 to 1 of the questions Did not attempt questions were answered correctly. were answered correctly. or none of the questions were answered correctly. Advanced 90-100% Proficient 70-89% Developing 1-69% Not present 4 points 3 points 1 to 2 points 0 points Screenshot is provided and includes three of the following four characteristics for 1NF: Screenshot is provided and includes one to two of the following four characteristics for 1NF: No screenshots displaying the 1NF table is provided. 1. It should only have single (atomic) valued attributes/columns. 2. Values stored in a column should be of the same domain 3. All the columns in a table should have unique names. 4. And the order in which data is stored, does not matter. 1. It should only have single (atomic) valued attributes/columns. 2. Values stored in a column should be of the same domain 3. All the columns in a table should have unique names. 4. And the order in which data is stored, does not matter. Screenshot displays the 1NF and include all four of the following characteristics: 1. It should only have single (atomic) valued attributes/columns. 2. Values stored in a column should be of the same domain 3. All the columns in a table should have unique names. 4. And the order in which data is stored, does not matter. Screenshots Second Normal Form (2NF) Screenshots Third Normal Form (3NF) 4 points 3 points 1 to 2 points 0 points Screenshot displays the 2NF and include both of the following characteristics: Screenshot is provided and includes one of the following two characteristics for 2NF: Screenshot is provided and No screenshots displaying includes none of the following the 2NF table is provided. characteristics for 2NF: 1. It should be in the First Normal form. 2. And, it should not have Partial Dependency. 1. It should be in the First Normal form. 2. And, it should not have Partial Dependency. 1. It should be in the First Normal form. 2. And, it should not have Partial Dependency. 4 points 3 points 1 to 2 points 0 points Screenshot displays the 3NF and include both of the following characteristics: Screenshot is provided and includes one of the following two characteristics for 3NF: Screenshot is provided and includes none of the following characteristics for 3NF: No screenshots displaying the 3NF table is provided. 1. It is in the Second Normal form. 2. And, it doesn't have Transitive Dependency. 1. It is in the Second Normal form. 2. And, it doesn't have Transitive Dependency. 1. It is in the Second Normal form. 2. And, it doesn't have Transitive Dependency CSIS 325 Lab 7 Normalization The following table is un-normalized. The original data set is in the Normalization Lab Data.xls file in your lab folder. For each question that requires you to re-write tables, re-write them in the Excel workbook and copy/paste your new table(s) in the appropriate sections below. Tables must include all data (not merely column headings). To make your results more readable, paste your tables as bitmaps or screenshots. To receive credit for these questions, your tables must be easily readable. You may refer to the Normalization_Example.xls file as an example on how to approach this task. This file located in your lab folder. First EmpID Name 253 987 52 333 586 Last Name Hours Worked Date 1/15/2018 8 1/16/2018 8 14566 Central Road Jameston Enterprises - WO #1 Oliver Queen Jameston Enterprises 1/17/2018 4 Peter Parker Metropolis Metropolis, IL 23456 Bruce Wayne 1/18/2018 4 Gatelle, Inc. - License Bruce Wayne Gatelle, Inc. 1/15/2018 8 1/16/2018 8 1/17/2018 8 123 Oak Lane 1/18/2018 8 Bruce Wayne Gotham Gotham, NY 45632 1/19/2018 8 Quartz United - Software Upgrade Clark Kent Quartz United 1/15/2018 8 1/16/2018 4 14566 Central Road Acme, LLC - WO #2 Peter Parker Acme, LLC 1/17/2018 8 Clark Kent Metropolis Metropolis, IL 23456 Bruce Wayne Jones & Jones - WO #1 Clark Kent Jones & Jones 1/16/2018 4 Jones & Jones - Maintenance Clark Kent Jones & Jones 1/15/2018 8 Brierwood, Inc. - T&M Luke Skywalker Brierwood, Inc. 1/16/2018 8 1/17/2018 8 123 Oak Lane Lightsaber, LLC - Fixed Price Luke Skywalker Lightsaber, LLC 1/18/2018 8 Luke Skywalker Gotham Gotham, NY 45632 Oliver Queen Quartz United - License Clark Kent Quartz United 1/19/2018 8 Houndson, Ltd. - Custom Oliver Queen Houndson, Ltd. 1/15/2017 4 Jameston Enterprises - WO #1 Oliver Queen Jameston Enterprises 1/15/2017 4 Brierwood, Inc. - T&M Luke Skywalker Brierwood, Inc. 1/16/2017 4 1/17/2017 4 14566 Central Road Brierwood, Inc. - License Luke Skywalker Brierwood, Inc. 1/16/2017 4 1/17/2017 4 Oliver Queen Metropolis Metropolis, IL 23456 Bruce Wayne Office Office Address Supervisor Project Acme, LLC - WO #1 Project Manager Peter Parker Question #1: In the space below, re-write the table above so that it is in first normal form. Question #2: What is the primary key of the 1NF table you just constructed? Question #3: Identify the functional dependencies in the 1NF table you constructed. Client Acme, LLC Question #4: Describe any insertion anomalies that can occur in your 1NF table. Question #5: Describe any deletion anomalies that can occur in your 1NF table. Question #6: Describe any modification anomalies that can occur in your 1NF table. Question #7: Based on your 1NF table, in the space below, re-write the table so that it is in second normal form. You may add ID fields to any new tables you create and use those IDs as foreign keys in other tables as appropriate. (10 points) Question #8: What is the primary key of each of the 2NF tables you just constructed? Question #9: Identify the functional dependencies in the 2NF table(s) you constructed. Question #10: In the space below, re-write the 2NF table(s) so that they are in 3NF. Question #11: What is the primary key of each of the 3NF tables you just constructed? Question #12: Identify the functional dependencies in the 3NF table(s) you constructed. Question #13: Are all of your tables in BCNF? Why or why not? First EmpID Name Last Name 253 Peter Parker 987 Bruce Wayne 52 Clark Kent 333 Luke Office Office Address Supervisor 14566 Central Road Metropolis Metropolis, IL 23456 Bruce Wayne Gotham 123 Oak Lane Gotham, NY 45632 14566 Central Road Metropolis Metropolis, IL 23456 Bruce Wayne Skywalker Gotham 123 Oak Lane Gotham, NY 45632 Oliver Queen 586 Oliver Queen 14566 Central Road Metropolis Metropolis, IL 23456 Bruce Wayne Project Project Manager Acme, LLC - WO #1 Peter Parker Jameston Enterprises - WO #1 Oliver Queen Gatelle, Inc. - License Client Date Acme, LLC Hours Worked 1/15/2018 1/16/2018 Jameston Enterprises 1/17/2018 1/18/2018 8 8 4 4 Bruce Wayne Gatelle, Inc. 1/15/2018 1/16/2018 1/17/2018 1/18/2018 1/19/2018 8 8 8 8 8 Quartz United - Software Upgrade Clark Kent Quartz United Acme, LLC - WO #2 Jones & Jones - WO #1 Peter Parker Clark Kent Acme, LLC Jones & Jones 1/15/2018 1/16/2018 1/17/2018 1/16/2018 8 4 8 4 Jones & Jones - Maintenance Brierwood, Inc. - T&M Clark Kent Jones & Jones Luke Skywalker Brierwood, Inc. Lightsaber, LLC - Fixed Price Quartz United - License Luke Skywalker Lightsaber, LLC Clark Kent Quartz United 1/15/2018 1/16/2018 1/17/2018 1/18/2018 1/19/2018 8 8 8 8 8 Houndson, Ltd. - Custom Jameston Enterprises - WO #1 Brierwood, Inc. - T&M Brierwood, Inc. - License Oliver Queen Houndson, Ltd. 1/15/2017 Oliver Queen Jameston Enterprises 1/15/2017 Luke Skywalker Brierwood, Inc.