A retailer, Continental Palms Retail (CPR), plans to create a database system to keep track of...

A retailer, Continental Palms Retail (CPR), plans to create a database system to keep track of the information about its inventory.

CPR has several warehouses across the country. Each warehouse is uniquely named. CPR also wants to record the location, city, state, zip, and space (in cubic meters) of each warehouse. There are several warehouses in any single city.

CPR stores its products in the warehouses. A product may be stored in multiple warehouses. A warehouse may store multiple products. The quantity of a product in a warehouse needs to be recorded.

Every product has a unique UPC number. Other information about a product includes a name, a buying price, an approximate selling price, and a size (in cubic meters).

CPR also keeps track of the information about the manufacturers of products. Every product has a single manufacturer, but a manufacturer may manufacture multiple products. Each manufacturer has a unique name, an address (street, city, state, zip), and a contact phone number.

The requirements of CPR also indicate that there are the following full Functional Dependencies:

• UPC -> Name, Buying_Price, Selling_Price, Size, Manufacturer_Name, MStreet, MCity, MState, MZip, MPhone • Manufacturer_Name -> MStreet, MCity, MState, MZip, MPhone • Warehouse_Name -> WLocation, WCity, WState, WZip, WSpace • UPC, Warehouse_Name -> Quantity

A consulting company named Database Experts has designed the following relation data model for CPR. Product (UPC, Name, Buying_Price, Selling_Price, Size, Manufacturer_Name, MStreet, MCity, MState, MZip, MPhone, Warehouse_Name, WLocation, WCity, WState, WZip, WSpace, Quantity)

Although the designers at Database Experts claim that their design is superior in all aspects, CPR gives you a fair chance to justify your position. Now it’s your time to do the following.

(1) Show them what normal form their relation is in and why.

(2) Rescue their “bad” design using normalization. Decompose their relation Product into multiple smaller relations that are all in 3NF. Underline the primary key of each of your relations.

Solutions

Expert Solution

PLEASE GIVE IT A THUMBS UP, I SERIOUSLY NEED ONE, IF YOU NEED ANY MODIFICATION THEN LET ME KNOW, I WILL DO IT FOR YOU

1. The above connection is in 1st Normal Form since it permits just nuclear qualities.

2. The following is the chart of change of above table into third Normal structure tables according to the cycle. Underneath we can see the given table and afterward from this we determined second ordinary structure on the grounds that first typical structure decide is that it doesn't not have non-prime ascribes . so we partitioned into second .

The second is additionally isolated into third Normal structure since it is having transtive relationship. So at long last the standardized relations we get into as third typical structure.

venereology answered 1 year ago

Next > < Previous

Related Solutions

1. A cosmetic product retailer needs to create a database to keep track of the information...

1. A cosmetic product retailer needs to create a database to keep track of the information for its business operations. The company has a web site that posts all its products. The product information includes product ID, product name, description, and unit price. The company also needs to keep track of customers’ information, including customer names, their shipping addresses, and the email address. The company creates an account for each customer for identification and tracking purpose. A customer can purchase...

Using c++ Design a system to keep track of employee data. The system should keep track...

Using c++ Design a system to keep track of employee data. The system should keep track of an employee’s name, ID number and hourly pay rate in a class called Employee. You may also store any additional data you may need, (hint: you need something extra). This data is stored in a file (user selectable) with the id number, hourly pay rate, and the employee’s full name (example): 17 5.25 Daniel Katz 18 6.75 John F. Jones Start your main...

Consider the following set of requirements for a UNIVERSITY database that is used to keep track...

Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. (a) The university keeps track of each student's name, student number, social security number, current address and phone, permanent address and phone, birthdate, sex, class (freshman, sophomore, ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address, and to...

Design a database through the EER diagram to keep track of the teams and games of...

Design a database through the EER diagram to keep track of the teams and games of a sport league. Assume that the following requirements are collected (the English description of cardinal ration and partial/complete participate is NOT required, but you still need to provide the total/partial and cardino ration in your EER diagram) : The database has a collection of TEAM. Each Team has a unique name, players, and owner. The database also keeps the records of PLAYERS. Each player...

Ava wants to use a database to keep track of the data recordsfor her insurance...

Ava wants to use a database to keep track of the data records for her insurance company and to enforce the following business policies/requirements: USE MS ACCESS TO CREATE A DATABASE & RELATIONASHIP-Every customer must be uniquely identified.-A customer can have many insurance policies.-Every insurance policy must be uniquely identified.-An insurance policy must belong to a valid customer.-Every customer must be served by a valid insurance agent (employee).-An insurance agent (employees) serves many customers.-Every insurance agent (employee) must be uniquely...

Scenario: An auto shop is designing a database to keep track of repairs. So far, we...

Scenario: An auto shop is designing a database to keep track of repairs. So far, we have this UNF relation, with some sample data shown. Normalize to 1NF. REPAIRS: # VIN, Make, Model, Year, ( Mileage, Date, Problem, Technician, Cost ) VIN Make Model Year Mileage Date Problem Technician Cost 15386355 Ford Taurus 2000 128242 6/6/2014 Won’t start Gary $300 15386355 Ford Taurus 2000 129680 6/20/2014 Tail light out Trisha 43532934 Honda Civic 2010 38002 6/18/2014 Brakes slow Gary $240...

Scenario: A builder needs a database to keep track of contractors he hires for various projects....

Scenario: A builder needs a database to keep track of contractors he hires for various projects. So far, we have this 2NF relation, with sample data shown. Normalize to 3NF. CONTRACTOR: # ConID, Lname, Fname, JobTitle, Company, Street, City, State, Zip, CompanyPhone, CellPhone ConID Lname Fname JobTitle Company Street City State Zip Phone CellPhone 2 Garcia Mary Carpenter Construct Co 123 Main Portland OR 97204 823-1234 645-5423 14 Jones Tomas Welder Construct Co 123 Main Portland OR 97204 823-1234 344-3475...

C# The Zookeepers need a system to keep track of all their animals. They need to...

C# The Zookeepers need a system to keep track of all their animals. They need to be able to enter all their animals into the system in a way that allows them to identify and locate them. This requires identifying them by species, age and one characteristic unique to their species. There are three cages and the user must input information about the animal in each one. After accepting input for all three cages, the program should output the contents...

Database Design and SQL The following relations keep track of airline flight information: Flights (flno: integer,...

Database Design and SQL The following relations keep track of airline flight information: Flights (flno: integer, from : string, to: string, distance: integer, departs: time, arrive: time, price: integer) Aircraft (aid: integer, aname : string, cruisingrange: integer) Certified (eid: integer, aid: integer) Employees (eid: integer, ename : string, salary: integer) The Employees relation describe pilots and other kinds of employees as well. Every pilot is certified for some aircraft and only pilots are certified to fly. Based on the schemas,...

/////////////////JAVA PLEASE///////////////////////////////// Create a class called GVdate to keep track of a calendar date including month,...

/////////////////JAVA PLEASE///////////////////////////////// Create a class called GVdate to keep track of a calendar date including month, day and year. You can do simple things like checking if it is your birthday, advancing to the next day, checking if a given date is valid and checking if it is a leap year. Class Fields/Instance Variables Provide appropriate names and data types for each of the private instance variables: the month, day and year (int) two final integers that represent YOUR birthday (month...

Subjects