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 technology meets the requisite market potential, Pharma Blitz devel...

Pharma Blitz develops and markets new technological products to be used in health care. The development of a new product operates as follows. When a new technology meets the requis

LINE BALANCING, What do you understand by “line balancing”? What happens if...

What do you understand by “line balancing”? What happens if balance doesn’t exist?

Explain types of organizational culture, Choose two specific features of or...

Choose two specific features of organizational structure described in chapters 5, 6, 8, and/or 9 and discuss how these specific features might lead to specific types of organizatio

Explain evaluating corporate contributions, In one paragraph supported by y...

In one paragraph supported by your text and other research, describe the criteria you would use if you were a manager charged with evaluating corporate contributions to decide whet

Explain the management-research question hierarchy, Build the management-re...

Build the management-research question hierarchy for penton media

Operation management case study assignment, Problem- 1) Many Institution...

Problem- 1) Many Institutional Models: There are a variety of organizational forms that are assumed by the Manipal hospitals for carrying on their work. The Manipal hospitals ca

Explain whole foods market has a mission, 1. What evidence do you find in t...

1. What evidence do you find in this case, either explicitly or implicitly, that indicates that Whole Foods Market has a mission, core values, or is practicing decision-making that

Game theory, Consider the following parlor game to be played between two pl...

Consider the following parlor game to be played between two players. Each player begins with three chips: one red, one white, and one blue. Each chip can be used only once. To beg

Explain benefits and variable pay, Benefits and Variable Pay Please respond...

Benefits and Variable Pay Please respond to the following- • Analyze the types of benefits usually available in the health care industry and determine which benefits are most im

What is communication in an organisation structure, What is Communication i...

What is Communication in an organisation structure. Communication: An organisation structure gives channels for the flow of information on that the decisions of the organisat

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