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

Define save money before announcing the restructuring plans, Should GM have...

Should GM have taken any additional steps to save money before announcing the restructuring plans?

Explain and contrast the rights of bond holders, Describe and contrast the ...

Describe and contrast the rights of bond holders and preferred stockholders. Which has the best position in a default, which one would you buy all other things being equal?

Explain field of construction management, Discuss how the transformation pr...

Discuss how the transformation process applies to the field of construction management

Advantages of production planning and control, Advantages of Production Pla...

Advantages of Production Planning and Control 1. Higher productivity: The productivity can be improved by taking care of production methods and time. 2. Removal of Hurdles

Explain why do companies that advertise their csr policies, 1. Why do compa...

1. Why do companies that advertise their CSR policies so often face serious controversies anyway 2. Identify an area in which Apple is regarded as responsible to a stakeholder

Explain how does a leader differ from a manager, How does a leader differ f...

How does a leader differ from a manager and when would it be more advantageous to be a manager rather than a leader?

Explain why employees join unions, Over which of the principle reasons why ...

Over which of the principle reasons why employees join unions does a supervisor have the most direct control?

Describe the ways in which culture and technology coincide, Discuss the way...

Discuss the ways in which culture and technology coincide. Give an example from your own experience or the experience of others where culture and technology have impacted one anoth

Explain what is the probability that you will make money, The owner of Fire...

The owner of Firewood-2-Go is considering buying a hydraulic wood splitter which sells for $50000. He figures it will cost an additional $80 per cord to purchase and split wood wit

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