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 operations information systems, Distinguish between management info...

Distinguish between management information systems and operations information systems

Alternative structures discuss likely benefits to dominos, Evaluate alterna...

Evaluate alternative structures to determine which one would be most appropriate for Domino's to consider and discuss likely benefits Dominos would realize from adopting that struc

Explain collected information on the number of customers, Rosa's Italian re...

Rosa's Italian restaurant wants to develop forecasts of daily demand for the next week. The restaurant is closed on Mondays and experiences a seasonal pattern for the other six day

Fixed position layout - process design, Fixed-position layout This co...

Fixed-position layout This configuration is typically used for low-volume, project-type operations where the product being produced is massive, and movement of the material f

Focused improvement programmes - improving productivity, Focused Improvemen...

Focused Improvement Programmes - Improving Productivity Allan Lawlor (1985), Director of Action Learning Associates (ALA) suggests - based on his experiences in industry and

Explain financial statements of mcdonald''s and wendy''s, The following fig...

The following figures are taken from the 2003 financial statements of McDonald's and Wendy's. Figures are in million dollars. McDonalds Wendy's Inventory $129.4 $54.4 Reve

#title., Ask questiondiscuss the advisability of using modular assemblies i...

Ask questiondiscuss the advisability of using modular assemblies in manufacturing. what are the advantages and disadvantages #Minimum 100 words accepted

Define relationship among the different levels of management, 1. Show graph...

1. Show graphically, and explain, the relationship between the different levels of management, types of problems, and types of decisions. What do we mean by the term "bounded ratio

Explain goals should not be clearly articulated, Clearly-defined goals are ...

Clearly-defined goals are the essence of great teamwork. Which of the following statements is most true about how goals should be articulated by teams: a. Goals should not be clear

Explain the processing times for the five job, Suppose SPT rule is being us...

Suppose SPT rule is being used in a "dynamic" scheduling problem. There are five jobs A,B,C,D, and E ready to be processed at the present time. The processing times for the five jo

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