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

Describe a work breakdown structure, A Work Breakdown Structure (WBS) compo...

A Work Breakdown Structure (WBS) component is a term that simply refers to an entry in the WBS that can be at any level.

Production and operation management, What do you understand by “line balanc...

What do you understand by “line balancing”? What happens if balance doesn’t exist?

Explain allowable standard deviation in the temperature, Rachel loves to ba...

Rachel loves to bake cookies, but she has an old oven that has trouble maintaining a constant temperature. if the acceptable temperature range for making the cookies is 350 plus or

Describe americans doing business in china, 1. Americans doing business in ...

1. Americans doing business in China. 2. What are the pros and cons of doing business in China? 3. What kind of strategy do the Chinese use? 4. Rules for doing bunnies in China. 5.

Explain arbitration and judicial resolution of disputes, The difference bet...

The difference between arbitration and judicial resolution of disputes

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

Sequencing problem, what mean passing time is not allowed in sequencing pro...

what mean passing time is not allowed in sequencing problem in operation research

Explain yellow pages listed a funeral home under what, In 1980 the Yellow P...

In 1980 the Yellow Pages listed a Funeral Home under what

Define service and manufacturing organizations, Identify and discuss five d...

Identify and discuss five differences between service and manufacturing organizations.

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