Describe designing a database and relational schema, Operation Management

Assignment Help:

You viewed two video resources, Designing a Database and Relational Schema of the "Priscilla/Dave" project. At the end of the logical design phase, there were five tables (Pet, PetOwner, IdTag, PetFood, and Toy). (a) Find the names of pets owned by anyone whose first name is John. Note: Use the SELECT command. (b) As there is a many-to-many relationship (between Pet and Toy) that cannot be expressed in a Relational database, an additional table (PetToy) was introduced that links the two tables. Thus, the final design is: Priscilla is interested in providing additional services to her customers, as well as having a better control on her toys and food suppliers. For additional services, she wants to add to the database the names of veterinary doctors in the neighbourhood. Each customer could choose the vet he or she wants to work with, and that vet will treat all the customers' pets. Priscilla also likes to add supplier data to her database. Each PetFood item is supplied by just one Food Supplier (but a supplier can supply many food items). A Toy can be supplied by multiple Toy Suppliers. A Toy Supplier can supply many Toys. Extend the design to include Veterinarians, Pet Suppliers, and toy Suppliers.


Related Discussions:- Describe designing a database and relational schema

Explain what assignment minimizes the total traffic flow, Please kindly sho...

Please kindly show step by step solutions. Six processes are to be laid out in six areas along a long corridor at Linda Babat Accounting Services. The distance between adjacent

Explain the production plant capable of making per week, Kamal's Roti Facto...

Kamal's Roti Factory makes Rotis and delivers them to various restaurants and delis around Brooklyn. The production plant made 200,000 Rotis last week. The production plant operate

Describe why managers should know about research, Q1. Explain why managers ...

Q1. Explain why managers should know about research. Q2. BrokenViolin956 Read the entrepreneur's dilemma and the questions that follow. Identify the legal issue(s) and apply

Describe views of organizational conflict, Discuss three barriers to effect...

Discuss three barriers to effective oral communication and possible remedies. Discuss 3 views of organizational conflict. When is conflict "good?" When is conflict "bad?"

Find what is the labour productivity per dollar, Klein Karpet cleaned 65 ru...

Klein Karpet cleaned 65 rungs in October, consuming the following resources: Labour: 520 hours at$13 per hour Solvent: 100 gallons at $5 per gallon Machine rental: 20 days at $50 p

Is true that a mpc can run independent of the operation plan, Which of the ...

Which of the following is true? MPC can run independent of the operation plan. Business failure can result from poor MPC performance. In PAC, order release directly affect

Decision making process for ethical solution, Profits have been decreasing ...

Profits have been decreasing and power plant executives are considering whether to use a production process that decreases costs (and therefore increases profits) but adds to the p

Explain defect and passed inspection, A manager states that his process is ...

A manager states that his process is really working well. Out of 1,500 parts, 1,477 were produced free of a particular defect and passed inspection. Based upon Six-Sigma theory, ho

Explain ford and google companies similar and different, But from the outsi...

But from the outside, it's getting harder every day to articulate what Google is. Is it a Web company? A software company? Something else entirely? How are the situations for Fo

Explain two firms with similar problems but from different, In this assignm...

In this assignment, you will prepare an in-depth comparative analysis research paper between two different firms operating in two different countries but which have similar challen

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd