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

Through television marketing how do consumers select quality, Through telev...

Through television marketing how do consumers perceive different brands as being the best quality?

Explain quality improvement process, A fishbone diagram as part of a six-si...

A fishbone diagram as part of a six-sigma quality improvement process might be found in which DMAIC category?

Determine the process capability indices and p chart control, 1. If the des...

1. If the design tolerance limits for the process are 9.7/11.2, determine the process capability indices C p and C pk . Comment on the values obtained.  2. 1000 items produced

Explain benefit of taking the money versus losing control, Your new small b...

Your new small business has really grown, but now it needs a substantial infusion of capital. A venture capitalist firm has agreed to invest the money you need. In return, the vent

Explain supermarket is monitored using a range, Checkout time at a supermar...

Checkout time at a supermarket is monitored using a range and mean chart. Six samples which contain 20 observations per sample have been collected and the sample means and sample r

Explain concept of sustainability in operations management, Explain the con...

Explain the concept of sustainability in operations management. The concept of sustainability within operations management: Sustainability in operations management is regarding

Elements, what are the elements of production forecasting?

what are the elements of production forecasting?

DISCUSSION, Has the growth of self-directed teams to manage work in organi...

Has the growth of self-directed teams to manage work in organizations changed the need for strategic, tactical, and operational decision making in business? Explain why or why not

Explain ethical problems and increase of competitive, Can someone give me s...

Can someone give me some ideas of how to implement a turnaround strategy for a United Way due to the fact that they have some ethical problems and increase of competitive.

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