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 interpret the meaning of the p-value in this problem, Initially, th...

Initially, the mean turnaround time for a stress test was 68 hours. After incorporating changes into the stress-test process, the quality improvement team collected a sample of 50

Describe the peculiarity of location selection, Question 1: How is Brea...

Question 1: How is Break-even Analysis significant to investment, as well as, operational decisions Assumptions Importance of Break-even Analysis for operational deci

Define disputes and the contractual means used for resolving, What is the c...

What is the cause of disputes and the contractual means used for resolving them?

Memo motion and micro motion recording, Memo Motion and Micro Motion Record...

Memo Motion and Micro Motion Recording Originally based on cine-photography, nowadays video-recording technology is used to record patterns of movement in process activities.

Explain what are some types of software that can help, What are some types ...

What are some types of software that can help us protect employee information? How does this software interact with our current HR technology? Explain from a conceptual stand

Operation management, Please help me in getting answer for the following qu...

Please help me in getting answer for the following question, please send me your answer to Question : 18 carpets were observed closely and the number of defects in their texture

Explain panel interviewing and its strengths and weaknesses, You're going t...

You're going to have to stretch your imagination for this question:. Assume you're involved in a panel interview team. Identify one strength and one weakness in this interview appr

Explain how much would land''s end buy, (Land's End) Geoff Gullo owns a sma...

(Land's End) Geoff Gullo owns a small firm that manufactures 'Gullo Sunglasses'. He has the opportunity to sell a particular seasonal model to Land's End. Geoff offers Land's End

Explain items selected from a population is called, A subset of items selec...

A subset of items selected from a population is called which of the following? Sample Statistic Census Parameter

Generate a decision tree to help expando, Expando, Inc., is considering the...

Expando, Inc., is considering the possibility of building an additional factory that would produce a new addition to its product line. The company is currently considering two opti

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