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 aggregate planning in manufacturing, What is the major difference b...

What is the major difference between aggregate planning in manufacturing and aggregate planning in services? Provide and explain to examples.

Explain objective functions for an lp model equivalent, Are the following o...

Are the following objective functions for an LP model equivalent? That is, if they are both used, one at a time, to solve a problem with exactly the same constraints, will the opti

Explain briefly the vrooms expectancy theory of motivation, Question 1: ...

Question 1: More and more organizations are showing greater reliance on team building and team work as opposed to individual work. Please discuss. i. Give characteristics o

Compute the value of the tax shield that the cost-depletion, You have a lea...

You have a lease on an oil and gas property with 87.5% NRI that delivers your firm annual profits of $400,000 for five years, with equal production in each year (you will need to t

Qn, a firm whether to make or buy a part required in its operation. cost an...

a firm whether to make or buy a part required in its operation. cost and volume estimate are as follows annual fixed cost make $15000 buy none, variable cost make $60 buy $80, annu

Calculate the expected value of perfect information, Clay Why bark, a soft-...

Clay Why bark, a soft-drink vendor at Hard Rock Cafe%u2019s annual Rockfest, created a table of conditional values for the various alternatives (stocking decision) and states of na

Describe what the customer''s expectations, Explain what the customer's exp...

Explain what the customer's expectations are concerning the salesperson's attitude toward competition

What leadership is give answer in thirty seconds, If someone asked you to t...

If someone asked you to tell them what leadership is, and you only had thirty seconds to answer, what would you say?

Introduction of operation management, Operations management is the manageme...

Operations management is the management of the productive resources of the firm which includes raw materials, human resources, land, equipment and facilities in the manufacture of

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