Part 1For Part 1, review the SRS and identify all the data fields that must be captured for the database. Once you have you have identified all of the data fields, go through the list to consolidate and eliminate any redundant fields. It is not crucial that they are in the correct tables yet because that will be completed in Part 2 of this assignment. Note the data types and sizes for each of the fields. Section 6 of the SRS provides you with a list of the required tables, along with some of the data fields that must be captured. Refer to the SRS Review video (linked in the Resources in Week 1) of a walk-through of Section 6.
Complete the following steps for Part 1 of this assignment:
Analyze the documents and determine the data fields necessary for the database.
Consolidate and eliminate redundant data fields.
Determine the data type and size for each field.
Place your information in an MS Word document. Name your document, following this pattern: LastName_Week4.docx.
Part 2For Part 2, create an ERD that applies business rules and processes to the database design. Use the data fields you defined in Part 1 as a basis to normalize the database, one normal form at a time. You are not required to submit each normal form because the list of required tables was already provided to you. However, it is informative to go through the normalization steps for each required table. Explain your database design choices based on the business processes from the SRS. Extend the ERD to include the column data types, sizes, and keys based on MySQL.
Complete the following steps for Part 2 of this assignment:
Create an ERD and apply business constraints.
Paste your ERD into your MS Word document.
Normalize the data showing the ERD normalized in 3NF.
Accurately define the column data types and keys for each data field.
Explain the ERD and defend your design choices.
Add this information to your MS Word document
Database Requirments
he minimum tables that are required for the database include:
Customer (consists of customer related information including first name, last name, email address, address, city, state, zip code and phone number).
Employee (consists of employee information; table data is provided in EmployeeList.csv).
Order (consists of high-level order information such as the order date, the customer who ordered it, and the employee who entered it into the system).
Order Details (links the order and product tables together; includes the quantity of products ordered).
Product (product information including the product name, description, price, and quantity currently available).
Category (list of the categories for the furniture products).