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 need step by step solutions to case study, Need step by step soluti...

Need step by step solutions to case study 2-1 (auto-assembly)

ERP, DETAIL THE WORKFLOW OF HRM THAT DEPLOYES ERP

DETAIL THE WORKFLOW OF HRM THAT DEPLOYES ERP

Measures to prevent accidents, Measures  to prevent Accidents 1. Prope...

Measures  to prevent Accidents 1. Proper Selection  of Workers: A scientific selection  of workers  is more  important from safety  point  of view.  The attitude  and  aptitu

Display the demand data, The demand for a product for the past 30 periods i...

The demand for a product for the past 30 periods is shown below. Determine the reorder point, R, and order-up-to-level, S, for this product for the next 6 periods (periods 31-36).

Explain what is the stocks required rate of return, GD inc has preferred st...

GD inc has preferred stock outstanding that pays a dividend of $5 at the end of each year. The preferred sells for $50 a share. What is the stocks required rate of return? Show wor

Design of a website for a tertiary educational institution, Question: T...

Question: The importance of having a properly designed website cannot be overemphasized. Poor user interface design is often the reason why so many websites are never used. Gen

Explain about the supply chain management according to kilty, Q. Explain ab...

Q. Explain about the Supply chain management according to Kilty? According to Kilty supply chain management: It involves the movement of products, services, and information

Tangibility & intangibility scale - service delivery system, Tangibility & ...

Tangibility & Intangibility Scale - Service Delivery System Products are things, services are ideas and concepts. From the figure you can see that there is no such thing as a

Five forms of waste within manufacturing organisations, Describe FIVE forms...

Describe FIVE forms of waste within manufacturing organisations that lean process improvement aims to eliminate. Inventory (all components, work in progress and ended produ

Explain when you go shopping for a new computer, When you go shopping for a...

When you go shopping for a new computer, is your real objective to import a computer into your apartment, or is it to export cash from your wallet? What does this tell you about th

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