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

Human resource manager for a coordinated system, You have been named human ...

You have been named human resource manager for a company that has 180 employees and no formal base pay system. What steps will you take to develope such a coordinated system?

Analyze on the price of heating oil, Question For the financial year 20...

Question For the financial year 2012-2013, it has been decided the equalization of the tax on heating oil with the tax on fuel, thus increasing the price of heating oil. Do you

Explain service quality addresses, 1. Can some please help me with these f...

1. Can some please help me with these fill in's? I am not sure I have the right answers One Way to identidy goals is to identify best practices through a process known as________

Describe functions you would include in this sswg, As the System Safety Eng...

As the System Safety Engineer for your firm, you are writing a System Safety Working Group (SSWG) charter. List 6 individuals/functions you would include in this SSWG and the reaso

What are the characteristics of service organisations, What are the charact...

What are the characteristics of service organisations? The characteristics of service organisations are as given below: a. Intangibility for illustrations no physical subs

Confidence interval of the population mean life, A sample of 36 "AA" Alkali...

A sample of 36 "AA" Alkaline batteries has a mean life of 6 months. The standard deviation of the population is known to be 3 months. Find the 95% confidence interval of the popual

Explain concepts in the world of marketing, In the world of marketing, ____...

In the world of marketing, _____ are ideas about products or services. (Points : 3) concepts notions perceptions impressions theories

Explain the impacts of consumerism, Describe the impacts of consumerism in ...

Describe the impacts of consumerism in regards to information technology, claims management, and member services when dealing with healthcare providers.

Explain schematic model of the sequence, Which of the following models uses...

Which of the following models uses a schematic model of the sequence of steps in a problem and the conditions and consequences of each step?

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