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 technical or intellectual intelligence, It has been suggested that ...

It has been suggested that emotional intelligence is more important to good leadership than technical or intellectual intelligence. Do you agree or disagree with this suggestion? W

Explain how many customers could be served per hour, Greg Davis, a business...

Greg Davis, a business major at the University of South Carolina (USC), has opened Six Points Saco (SPS), a specialty subs-taco restaurant, at the rim of the USC campus. SPS has gr

Explain what is a decision, In your readings you were shown sources where d...

In your readings you were shown sources where decision tools can be found. Please refer to the "What is a Decision?" lecture and select "Click to Explore." In the list provided, yo

Explain research on leader-member exchange, Write a 750-1,000-word paper th...

Write a 750-1,000-word paper that analyzes the two leadership case studies, "Coach Knight: A Will to Win" and "Coach K: A Matter of the Heart." Address the following questions a

Explain computer criminals become more innovative, Identify potential ethic...

Identify potential ethical challenges that may be faced by security professionals as technology advances, applications become more mobile, and computer criminals become more innova

What are the advantages of process mapping, What are the advantages of proc...

What are the advantages of process mapping? Advantages of process mapping are as follows: a. It can be used for structured ‘walk by testing to confirm knowing of workflow, c

Explain turnovers are undesirable and to be avoided, Do you believe all tur...

Do you believe all turnovers are undesirable and to be avoided?

What the act of consciously choosing from alternatives, The act of consciou...

The act of consciously choosing from alternatives is called a dilemma. a quandary decision making. a paradox. a predicament.

Explain step of customer needs and expectations, Beginning with the step of...

Beginning with the step of customer needs and expectations (expected quality), identify and describe the remaining steps in the customer-driven quality life cycle. (Hint: drawing a

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