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 does not fall in the resulting confidence interval, If the point es...

If the point estimate in a paired difference estimation example does not fall in the resulting confidence interval, the decision maker can conclude that the two populations likely

Causes of poor lighting, 1. Flickering tubes: This condition which may b...

1. Flickering tubes: This condition which may be due to defective conditions or by tube which has reached its working life, creates eyestrain. 2. A. Misadjusted Refle

Importance of performance measurement, Importance of performance measuremen...

Importance of performance measurement  1. Research reveals that many institutional investors are basing their decisions, in part, on a review of company's non financial perfor

Industrial society - operations function, Industrial Society - Operations F...

Industrial Society - Operations Function In the industrial society, estimated during the period of growth of industrialisation roughly 1820-1920, machines and the production o

Explain production and distribution of pharmaceutical, Carrington inc is an...

Carrington inc is an international company engaged in the production and distribution of pharmaceutical. Is the Peterson operation successful? To the degree that it can be judged a

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 productivity in terms of management, Explain Productivity in terms ...

Explain Productivity in terms of management. Productivity may be defined as the ratio in between output and input. Output implies the amount produced or the no. of items prod

Explain what are the advantages and disadvantages of each, Would you rather...

Would you rather work for a supervisor high in need for achievement, affiliation, or power? Why? What are the advantages and disadvantages of each? Explain

Operating budget, The copy center in the College of Business at State Unive...

The copy center in the College of Business at State University has become an increasingly contentious item among the college administration. Department heads have complained to

Design of work systems, A worker machine operation was found to involve 3.5...

A worker machine operation was found to involve 3.5 minutes of machine time per cycle in the course of 40 cycles of stopwatch study. The workers time averaged 2.3 minutes per cycle

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