Question

In: Computer Science

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 multiple products with different quantities in one order. The company’s products have many prospective customers. The company needs to keep track of information for all orders it received, including the order date, invoice number, and information about products purchased in an order such as IDs of products, and quantities, etc. Company’s products are stocked in several warehouses. So company also needs to keep track of the information about each warehouse such as its name, address, manager, telephone, etc. a. Create an E/R model for this scenario. In your E/R model you need to show the names of entities, names of attributes, keys and the name(s) of relationship(s). Also indicate maximum and minimum cardinalities You may hand-draw the ER model and insert its image here.

Expert Solution

ER Diagram of above Description:

here, PK indicates for Primary Keys and FK indicates for Foreign Keys.

Description of ERD:

1. Each Entity contains Primary Key as a Unique Key.

2.All the entities are have relationships with other with their foreign keys.

3.Minimum ans Maximum Cardinality are represented by 1 or N to every relationships.

4.Relationships:

Customer to Products (one to many)

Customer to Account (one to many)

Customer to order (one to many)

Account yo order (one to many)

Order to Products (one to many)

WareHouse to Products (one to many)

Manager to Warehouse (one to many)

5. Entities and their Attributes are shown in above Diagram.

If you have any doubt regarding this question please ask mein comments

//THANK YOU:-)

venereology answered 1 year ago

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....

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...

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,...

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...

1.Create a Database in Access with the information The database must include: Database name: Monaco Enterprise Mark...

1.Create a Database in Access with the information The database must include: Database name: Monaco Enterprise Mark Johnson #87451 Table name: Contacts Delete the Primary key. Fields name and data type are (remember to choose the data type): Field Name Data Types Employee Name Short text Name Short text Last Name Short Text Work Yes/No 2.Go to the “Datasheet View” and enter the data. * Remember to save the table. 3.Move the last name field after the employee name. 4.The (data)...

You are going to create a console based program to keep track of a small business...

You are going to create a console based program to keep track of a small business that sells Doodads. First you will need to create a class Doodad that keeps track of two integers and two Strings. Next, create a constructor for the Doodad. Next, add getters and setters for each of the fields (two integers and two Strings). You need to use Doodad.java (see the starter code) Inside your main method ask the user to read in the two...

A law firm proposed the following table to keep track the information about cases and the...

A law firm proposed the following table to keep track the information about cases and the lawyers who handle the cases: CASE (caseNumber, caseDescription, lawyerInCharge, caseAssistant, beginningdate, endingDate, lawyerRate, accumulatedHours, clientsName., clientPhone, clientAdress, clientType, laywerPhone, caseResultDescription, clientCurrentPayment, paymentMethod, salary, bonus) Among above attributes, caseNumber, is the ID of the case lawyerInCharge is the name of the lawyer (a single person) who in charge of the case. NOTE : There may be also several staffs in the firm serve as the...