FIND A SOLUTION AT Academic Writers Bay
ome Improvement Warehouse is a store that sells home improvement products. All orders are picked up from the store. Each order must be sold to a specific customer. Each customer must have at least one order associated with him/her, and each customer is assigned a specific sales rep. Each sales rep belongs to a specific department, but it is possible to have a department with no employees. Each sales rep is assigned to a commission class and earns the same commission rate for each of his/her sales, regardless of the sale amount or the department to which he/she belongs. It is possible to have a commission class to which no employees belong. Product prices may vary from order-to-order. Each product belongs to a single category, but some categories may not have products that belong to them.
You may use Excel or PowerPoint, but it is recommended that you use Visio or another drawing/diagramming program to create the diagrams.
Complete the following based on the information provided above and the data provided on the previous page:
1. FIRST NORMAL FORM (1NF) – 15 points:
a. Convert the table above to 1NF (double-click the table to access the data, eliminate repeating groups, then select and underline the appropriate PK). Choose an appropriate name for the table.
b. Show the table structure format (list the table name followed by its attributes, in parentheses, with the primary key underlined).
c. Create a dependency diagram for the table (primary key should be underlined).
2. SECOND NORMAL FORM (2NF) – 20 points:
List each key component on a separate line then write the original key on the last line.
Convert to 2NF, choose appropriate names for the new tables, and show the table structure format for each one in 2NF.
Create the dependency diagrams for each 2NF table.
3. THIRD NORMAL FORM (3NF) – 25 points:
Convert to 3NF, choose appropriate names for the new tables, and show the table structure format for each one in 3NF.
Create the dependency diagrams for the resulting tables.
4. ENTITY-RELATIONSHIP MODEL – 30 points:
Using Chen notation, create an ERD showing all of the 3NF tables above. You must show the entities, relationships, connectivity, participation, and cardinality (it is not necessary to show the attributes on the ERD). In addition, depict any composite (bridge/linking) tables with a diamond inside the entity rectangle.
Based on the ERD created in step 4a, use Microsoft Access to create a relational schema showing the entities, their attributes, and the connectivity of the relationships. The PKs must be underlined or highlighted.
5. BUSINESS RULES – 10 points:
Write business rules to identify and describe the relationships among the entities. Each pair of business rules will have the following format:
Each A is always related to one or more B’s.
Each B is always related to one or more A’s.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER