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

Find loan payment than the lease payment, Sutton Corporation, which has a z...

Sutton Corporation, which has a zero tax rate due to tax loss carry-forwards, is considering a 5-year, $6,000,000 bank loan to finance service equipment. The loan has an interest r

Explain how do these survey methods compare, • Discuss the advantages and d...

• Discuss the advantages and disadvantages of self-administered interviewing, face-to-face interviewing, and telephone interviewing. • What is necessary for the success of each

Why evaluate training programs is required by company, What can be done to ...

What can be done to motivate companies to evaluate training programs?

Explain capacity planning and how a company benefits, Please give your opin...

Please give your opinion on the paragraph below in just a few short sentences. Advertisers use case studies to add credibility to what they're saying their product is capable of do

Explain what assignment minimizes the total traffic flow, Six processes are...

Six processes are to be laid out in six areas along a long corridor at Linda Babat Accounting Services. The distance between adjacent work centres is 40 feet. The number of trips b

Explain what the earliest the project can be completed, The following table...

The following table shows the activity details of a project. What the earliest the project can be completed? Activity Days Predecessor ctivities A 4 - B 5 - C 3 A D 5 A E

Advocacy of a focused factory - operations strategy, 1. Explain the quandar...

1. Explain the quandary experienced by Skinner (1969,1974) and his advocacy of a 'focused factory'. Answer: Skinner argued that the trade-off concept is based on the quandary th

Explain hired assuming a 80 percent target utilization rate, The process fo...

The process for renewing a driver's license at the Archer County Courthouse is as follows. First, the clerk fills out the application; then the clerk takes the driver's picture, an

Explain what is the maximum effective capacity of the system, The roller co...

The roller coaster at Treasure Island Amusement Park consists of 15 cars, each of which can carry up to three passengers. According to a time study each run takes 1.5 minutes and t

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