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 the roles of the defense contract management agency, What are the r...

What are the roles and responsibilities of the Defense Contract Management Agency

Describe the general environmental challenges, 1. Describe and discuss an o...

1. Describe and discuss an organization's task environment. Discuss how the elements within the task environment would impact an organization such as Microsoft Corporation. 2. Disc

Management as a process, Management as a process Much has been written...

Management as a process Much has been written of management as a process of 'getting things done through people', but the seminal work was that of the French engineer and indu

Compute sample size to confirm or not the findings, If a pilot test reveale...

If a pilot test revealed 45% perceived poor service quality, and we decide the interval range is + 10 percent with a 95% confidence level, what is the calculated sample size to con

Explain personal computers and airline travel, Are the following global ind...

Are the following global industries or multi domestic industries: bulk chemicals, pharmaceuticals, branded food products, moviemaking, television manufacture, personal computers an

Define deming and crosbys views, Compare and contrast Deming and Crosbys vi...

Compare and contrast Deming and Crosbys views on the cost associated with a lost customer.

Explain what strategic objectives in traditional approach, Lincoln electric...

Lincoln electric is gradually moving toward using a more traditional approach to pay, putting less emphasis on earnings at risk. What strategic objectives would lead the company to

Which coca-cola products are main likely to lose customers, Some industry a...

Some industry analysts think soft-drink companies should develop products that will bring new customers into the market rather than just creating variants on the old. They warn tha

Describe what do the results of the questionnaire suggest, How do you react...

How do you react to conflict? Do you have a typical style as a leader when dealing with a conflict situation? Complete the Conflict Style Questionnaire. What do the results of the

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