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

Flow Time, You know that our average weekly sales are $2,500 and the flow t...

You know that our average weekly sales are $2,500 and the flow time is half day. Surely with this information, you should have no problem maintaining an inventory level of $400 to

Describe in terms of developing a project plan, In terms of developing a pr...

In terms of developing a project plan, specifically recommend how this resource could expedite that process.

Explain early european explorations of the americas, Need information on th...

Need information on this; did not receive my textbook as of yet European Explorations Debate the pros and cons of the early European explorations of the Americas. Should thes

Explain methods of ''on - the job training'' for managers, Explain methods ...

Explain methods of 'On - the Job Training' for Managers. Methods of 'On - the Job Training' for Managers : (i) Experience: In this method a person who is to do something a

Explain collaboration solutions in the face of economic, Why are unions exp...

Why are unions exploring new collaboration solutions in the face of economic/work adversity?

Describe communication skills, From the scenarios, we see that Chris and Er...

From the scenarios, we see that Chris and Erica have different communication styles that could potentially have a negative impact on the business. Suggest at least two strategies t

Explain bill what they mean for his umuc pizza business, Explain Porter's F...

Explain Porter's Five Forces Model and how Bill can use it to analyze his current business and his expansion. Be sure to address each of the 5 forces and explain to Bill what they

Explain objective of value stream mapping is to improve data, 1) Bill of ma...

1) Bill of material errors can cause serious problems for MRP system calculations of dependant demands 2) No matter what forecasting technique is used, the probability of a prod

Explain team prior to raising a follow-on fund, How should foster position ...

How should foster position herself and her team prior to raising a follow-on fund?

Explain flight reservations and vacation packages, Which strategy does this...

Which strategy does this exemplify? Kayak and Orbitz provide their customers with a variety of travel options including flight reservations, vacation packages, flight and hotel opt

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