Details of this Paper

All 3 parts Solution

Description

solution


Question

This is one assignment that is separated into 3 parts. Ill separate each part.;After you have analyzed the existing material used by the company for their day-to-day duties, the current Access database, and the additional requirements that the current system does not meet, the following requirements entity/attributes have been compiled;? Customer information is tracked using ?standard? attributes.;? A customer may purchase products or services, if they purchase products or services, the following is tracked;o Product purchased;o Date of purchase;o Total of purchase;? A supplier may sell products or services, if they sold products or services, the following is tracked;o Product sold;o Date of sale;o Total of sale;o Is item purchased available for resale;? Your company wants to keep the number of tables storing address information to a bare minimum (read this as 1).;? Customers can be both a "supplier" and "someone that purchased services," and it is not required that they be either.;? Employee information is tracked using standard attributes.;? An employee will either be considered customer interfacing or internal support.;? If the employee is customer facing, the following information is tracked;o Customer for interaction (note that a customer will only interface with a single employee);o Product specialty;o Hours of training;o Commission rate;? If the employee is internal support, then the following is tracked;o Salary;o Support area;? An employee can be either customer facing or internal support, but not both.;? Your company wants to keep the number of tables storing generic employee information to a bare minimum (read this as 1).;? Finally, the company wants to track products or services offered. This should be a single table with typical attributes that describe inventory.;? Every customer that either makes a purchase or sells goods to the company must be associated with an employee.;? Every transaction that a customer makes with the company is stored/tracked, A customer may buy or sell many products, and a product is sold to more than one customer.;Create an enhanced ERD to meet these requirements. Ensure that entities are properly defined and appropriate attributes are listed for each entity. Also, ensure that all entities are properly related.;Add your ERD as a screenshot to a Word document, and provide supporting discussion about the need for the enhanced diagram tools and the reasoning behind the multiplicity for the relationships.;Part 2: Analyze the following table and reorganize the table into Boyce-Codd Normal Form, at each step describing what is needed to move to the next Normal Form and why each step meets the Normal Form requirements.;? Show unnormalized table given and progression through the normal forms up to Boyce Codd in logical data models.;? Include explanation of how each normal form is met as you progress through the process of breaking down this unnormalized table to tables meeting Boyce Codd normal form.;Part 3: In addition, transform your data model (your EERD created in Part 1) into a logical model, to third normal form. Describe why each table is in third Normal Form. In your logical data model identify the primary keys in each table as bolded and underlined and each foreign key as italicized and underlined.;? Logical Data Model for the supplied table(Part 1) with a description of how it moved through UNF to 1NF to 2NF to 3NF and Boyce Codd.;? Logical Data Model for Part 2 with a description of how each table is in third normal form.

 

Paper#64951 | Written in 18-Jul-2015

Price : $43
SiteLock