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

Linear programming, Premier coatings Zambia ‘PCZ’ produce both interior and...

Premier coatings Zambia ‘PCZ’ produce both interior and exterior paints from two raw materials, Ml and M2. A market survey indicates that the daily demand for interior paint cannot

Control charts, 1. Identify the appropriate control charts to use with each...

1. Identify the appropriate control charts to use with each scenario and state WHY . a. A hospital is trying to improve its image by changing its menu offerings. It offers a qu

Explain morale, Explain Morale. Morale: It is a measure of extent whi...

Explain Morale. Morale: It is a measure of extent which level as either high or low of voluntary cooperation illustrated by a individual or a work group and of the intensity

Explain how can differences in the cultures of two countries, How can diffe...

How can differences in the cultures of two countries create ethical issues in our business operations? A key to answering this question is to first understand culture, particularly

Explain sql commands that are used for data manipulation, What is the role ...

What is the role of structure query language (SQL) in database object creation and information management in a relational database? Identify three SQL commands that are used for da

Explain what are the steps for process improvement, What are the steps for ...

What are the steps for process improvement? And examples of companies that have used this.

Define the main considerations regarding logistics alliances, What are the ...

What are the major considerations regarding logistics alliances, for: a) initiation? b) implementation? c) maintenance? d) termination?

Explain matrix organization isn''t working, Your company's matrix organizat...

Your company's matrix organization isn't working; decisions are taking too long and it seems to you that instead of best solutions you're getting compromises. As CEO what would you

Explain activity immediate predecessor normal time, The Scott Corey account...

The Scott Corey accounting firm is installing a new computer system, and several things must be done to make sure the system works properly. The following table provides informatio

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