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 lincoln electric company don''t want to join a union, Why doesn't L...

Why doesn't Lincoln Electric Company want to join a union?

Describe why variable pay-for-performance plans, Discuss why variable pay-f...

Discuss why variable pay-for-performance plans have become popular and what elements are needed to make them successful.

Describe the factors influencing customer behaviour, Question : Show or...

Question : Show origin of Collaborative Planning, Replenishment, and Forecasting (CPFR) Origin from CFAR How CFAR standard was renamed CPFR Continuing improvements

Define how each it project supports bill''s umuc pizza, Explain how each IT...

Explain how each IT project listed above specifically improves and/or supports Bill's UMUC Pizza business

Explain intangible assets and human capital, Companies are now more and mor...

Companies are now more and more interested in using intangible assets and human capital as a way to gain an advantage over competitors. True False

Discuss the relationship between companies and profit motive, Discuss the r...

Discuss the relationship between these four features of capitalism. Companies, profit motive, competition and private property.

Explain major priorities associated with operations strategy, What are the ...

What are the major priorities associated with operations strategy? How has their relationship to each other changed over the years?

Transportation and assignment problem, Transportation and Assignment Proble...

Transportation and Assignment Problem: Transportation  problem is the  problem of determining the minimum  cost for  allocating a product from  several supply sources to sever

Objectionable about psychological tests preemployment screen, Utilitarians ...

Utilitarians would not find anything inherently objectionable about psychological tests as long as the interests of all parties were taken into account and given equal consideratio

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