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

Define evaluation of the merits or reliability of the source, Share a sourc...

Share a source you are planning to use in writing your Resource Scheduling Methods Analysis Paper. Provide an APA citation for the source. Provide a brief summary of the source, an

Find the probability of event, The probability of Event 1 is P and the prob...

The probability of Event 1 is P and the probability of Event 2 is (1-p),for what values of P would you choose A?B?C? Values in the table are payoffs. Choice /Event Event 1 Event2

#title, Ask question #Mi.. Explain how the consideration of environmental a...

Ask question #Mi.. Explain how the consideration of environmental assesments AND ORGANISATION position provide a modeling framework for strategic planning of operations.

Describe corruption and bribery, Corruption and bribery are common in some ...

Corruption and bribery are common in some countries. Would you simply avoid locating in such a country, or locate there and deal with it? If the latter, how would you deal with it?

Compute the probability that the unit will not last weeks, I am falling beh...

I am falling behind in my homework and need some help please. There are three short questions: 1) A computer has three main modules that have individual reliabilities of 0.77, 0.87

Explain travel time of a community, A bank is planning to serve the rural c...

A bank is planning to serve the rural communities shown in figure 10.8 with automated teller machines (ATMs). The travel time in minutes between communities in the service area is

Economical management of a company, Consider a fast-food restaurant that is...

Consider a fast-food restaurant that is trying to improve its service during the 12:00 - 2:00 lunch period.  Right now the restaurant employs 5 different single-channel queues, but

Explain stakeholder relationships and social responsibility, Watch this Vid...

Watch this Video "Blue jean waste". Describe your reaction to this video and how you would respond if you were a leader of one of the corporations involved. In your journal entry

Explain toyota-production-system-principle, Some information about the toyo...

Some information about the toyota-production-system-principle just in case

#title., Ask questiondiscuss the advisability of using modular assemblies i...

Ask questiondiscuss the advisability of using modular assemblies in manufacturing. what are the advantages and disadvantages #Minimum 100 words accepted

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