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 logos and ethos and pathos, Explain what Logos, Ethos and Pathos ar...

Explain what Logos, Ethos and Pathos are and their relevance to being understood. Also discuss their preferred order of use. Construct an example following this model. Grading r

Explain must prepare a budget for a change initiative, Change plans must co...

Change plans must consider the use of a companys resources to maximize potential and ensure success. Financial resources are a definite consideration for any plan or objective. I

Explain women understand the importance of behaving similar, The program, "...

The program, "Bully Broads" is designed to help Answer men understand the controlling nature of women. Women understand how their perception of what it takes to get ahead can be vi

Describe katie''s liability, Katie is a 17-year-old (a minor) who graduated...

Katie is a 17-year-old (a minor) who graduated from high school two months ago. In August, she started attending a university 150 miles from home and has contracted to rent an apar

Explain should galanz have evolved from being an oem, Should Galanz have ev...

Should Galanz have evolved from being an OEM to being an OBM?Is Galanz structured to compete as an OEM? Why or why not?

Describe the difference between consumer products, Explain the difference b...

Explain the difference between consumer products and business products. Why are some products difficult to categorize as one or the other? Give an example of a business product, a

Explain national cattlemens beef association advertises beef, When the Nati...

When the National Cattlemens Beef Association advertises Beef, Its Whats for Dinner, it is trying to stimulate _____ demand. selective primary derived generic second

Explain the skills of an engineer and an engineer manager, Compare the skil...

Compare the skills of an engineer and an engineer manager

Explain how is ace products organized, Steffi Graf has assumed leadership o...

Steffi Graf has assumed leadership of Ace Products after many years of loyal service. Ace Products is an international manufacturer of copiers, printers, and fax machines. Historic

Explain training idea using any web 2.0 tools, Reading the Over 120 UCLA Ho...

Reading the Over 120 UCLA Hospital Staff Saw Celebrity Health Records article, what training could you as a manager put into place to avoid this situation? Present your training id

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