https://www.stuvia.com/
https://www.stuvia.com
C-170 Data Management Application Performace Assessment.
https://www.stuvia.com/
C-170 Data Management Application Assessment
A. Construct a normalized model to represent the donut shop smartphone application database
that supports the scenario above by doing the following:
1. Using the attached “Sales Order Form” (unnormalized order form) for the donut ordering
database as a reference, produce the final logical schema for this database by doing the
following:
Note: You can design the tables for the following prompts using any method of your
choice (e.g., using a drawing tool using tables).
a. Design one table that is in first normal form and fulfills the following requirements:
• The table should have a primary key that uniquely identifies the records.
• The values in each of the columns should be atomic.
• There should be no repeating groups.
• Do not include the calculated attributes/fields (Line Total, Subtotal, Sales Tax and
Total) in your normalization diagrams.
i. Explain how you designed the table (suggested length of 1 paragraph).
b. Design three tables that are in second normal form and fulfill the following
requirements:
• The tables should meet all of the requirements for the first normal form.
• All functional dependencies should be removed from the tables.
• Each of the tables should have all primary and/or foreign keys designated.
• Do not include the calculated attributes/fields (Line Total, Subtotal, Sales Tax and
Total) in your normalization diagrams.
i. Explain how you designed the tables (suggested length of 1 paragraph).
Nitro Software, Inc.
100
This study source was downloaded by 100000818837220 from PortableonDocument
CourseHero.com Lane
02-05-2022 15:25:48 GMT -06:00
Wonderland
https://www.coursehero.com/file/68277323/C-170-Data-Management-Application-Performace-Assessmentdocx/
,https://www.stuvia.com/
https://www.stuvia.com
C-170 Data Management Application Performace Assessment.
https://www.stuvia.com/
c. Design four normalized tables that are in third normal form and fulfill the following
requirements:
• The tables should meet all of the requirements for the first and second normal
forms.
• All transitive dependencies should be removed from the tables.
• Each of the tables should have all primary and/or foreign keys designated.
• Do not include the calculated attributes/fields (Line Total, Subtotal, Sales Tax and
Total) in your normalization diagrams.
• There should be four resulting tables: one for customer information, one for donut
information, one for order information and one for order line item information.
i. Explain how you designed the tables (suggested length of 1 paragraph).
Nitro Software, Inc.
100
This study source was downloaded by 100000818837220 from PortableonDocument
CourseHero.com Lane
02-05-2022 15:25:48 GMT -06:00
Wonderland
https://www.coursehero.com/file/68277323/C-170-Data-Management-Application-Performace-Assessmentdocx/
https://www.stuvia.com
C-170 Data Management Application Performace Assessment.
https://www.stuvia.com/
C-170 Data Management Application Assessment
A. Construct a normalized model to represent the donut shop smartphone application database
that supports the scenario above by doing the following:
1. Using the attached “Sales Order Form” (unnormalized order form) for the donut ordering
database as a reference, produce the final logical schema for this database by doing the
following:
Note: You can design the tables for the following prompts using any method of your
choice (e.g., using a drawing tool using tables).
a. Design one table that is in first normal form and fulfills the following requirements:
• The table should have a primary key that uniquely identifies the records.
• The values in each of the columns should be atomic.
• There should be no repeating groups.
• Do not include the calculated attributes/fields (Line Total, Subtotal, Sales Tax and
Total) in your normalization diagrams.
i. Explain how you designed the table (suggested length of 1 paragraph).
b. Design three tables that are in second normal form and fulfill the following
requirements:
• The tables should meet all of the requirements for the first normal form.
• All functional dependencies should be removed from the tables.
• Each of the tables should have all primary and/or foreign keys designated.
• Do not include the calculated attributes/fields (Line Total, Subtotal, Sales Tax and
Total) in your normalization diagrams.
i. Explain how you designed the tables (suggested length of 1 paragraph).
Nitro Software, Inc.
100
This study source was downloaded by 100000818837220 from PortableonDocument
CourseHero.com Lane
02-05-2022 15:25:48 GMT -06:00
Wonderland
https://www.coursehero.com/file/68277323/C-170-Data-Management-Application-Performace-Assessmentdocx/
,https://www.stuvia.com/
https://www.stuvia.com
C-170 Data Management Application Performace Assessment.
https://www.stuvia.com/
c. Design four normalized tables that are in third normal form and fulfill the following
requirements:
• The tables should meet all of the requirements for the first and second normal
forms.
• All transitive dependencies should be removed from the tables.
• Each of the tables should have all primary and/or foreign keys designated.
• Do not include the calculated attributes/fields (Line Total, Subtotal, Sales Tax and
Total) in your normalization diagrams.
• There should be four resulting tables: one for customer information, one for donut
information, one for order information and one for order line item information.
i. Explain how you designed the tables (suggested length of 1 paragraph).
Nitro Software, Inc.
100
This study source was downloaded by 100000818837220 from PortableonDocument
CourseHero.com Lane
02-05-2022 15:25:48 GMT -06:00
Wonderland
https://www.coursehero.com/file/68277323/C-170-Data-Management-Application-Performace-Assessmentdocx/
