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

Steps in work measurement, Steps in  work Measurement: The  various s...

Steps in  work Measurement: The  various steps  are : 1. Break the job  into elements: 2. Record the observed time  for each  element  by means  of time  study  synthesi

Operations management, Operations Management refers to those activities whi...

Operations Management refers to those activities which are more or less directly concerned with the creation and delivery of goods and services. The course is intended to give you

Define the parameters and the potential implications, The internet is a sta...

The internet is a staple of the modern office. Some companies are concerned that the Internet (and its e-mail application) lead to increased theft of time in the workplace. But, ot

Define customer benefits, In this writing assignment, you will create a bro...

In this writing assignment, you will create a brochure advertising your services as a data repository. Research commercial data repositories. Be sure to understand this business mo

Explain briefly how a leader can recognize regressive cycle, Describe brief...

Describe briefly how a leader can recognize a regressive cycle and what should the leader's response be?

Explain ethnocentric, Select an MNE with which you are familiar and determi...

Select an MNE with which you are familiar and determine which staffing approach (ethnocentric, polycentric, geocentric, or regiocentric) would be most beneficial to that enterprise

Describe how the uniform commercial code, Explain how the Uniform Commercia...

Explain how the Uniform Commercial Code treats goods that were fraudulently obtained.estion here

Explain developing the project plan, In terms of developing the project pla...

In terms of developing the project plan, identify which, if any, of the project steps are more integral to the project plan than any others. Support your response

How to prove inadequate for governing the new nation, Why did the Articles ...

Why did the Articles of Confederation prove inadequate for governing the new nation? (Think about: national unity under the Articles; lack of an executive branch; economic issues

How to view intermingling of management, The chapter notes that in 2010, in...

The chapter notes that in 2010, in roughly two-thirds of U.S. firms, the CEO is also the chair of the board of directors. More broadly this can be viewed as an intermingling of man

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