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 project management at the phoenician video case, Project Management...

Project Management at the Phoenician video case Many times, project decision makers do not rely solely on financial hurdles, such as return on investment or internal rates of re

Explain logos and ethos and pathos, Explain what Logos, Ethos and Pathos ar...

Explain what Logos, Ethos and Pathos are and their relevance to being understood. Also discuss their preferred order of use. Construct an example following this model. Grading r

Describe your views on the international cultural impact, Explain your view...

Explain your views on the 'international cultural impact' of the current banking crisis and support your answer. If it is your opinion that there is no 'international cultural impa

Compute the shape yield percentage, You punch multiple parts from a sheet o...

You punch multiple parts from a sheet of Aluminium. The sheet is a 1728 square-inches rectangle and you get 18 parts that are 70 square-inches each. The machine is old so you inclu

Find the feasible solution of transportation problem, Example: Find the fe...

Example: Find the feasible solution of  followings  transportation  problem by VAM and optimize  it by  stepping  stone methods. Availability  of Warehouse

Explain inventory turnover, Baker Mfg. inc. wish to compare its inventory t...

Baker Mfg. inc. wish to compare its inventory turnover to those of industry leaders, who have turnover of about 13 times per year and 8% of their assets invested in inventory. 1. B

Automation trends in operations management, how automation helps in trends ...

how automation helps in trends of operations management

Explain chooses to refurbish the equipment, Ski Boards, Inc., wants to ente...

Ski Boards, Inc., wants to enter the market quickly with a new finish on its ski boards. It has three choices: (a) refurbish the old equipment at a cost of $800, (b) make major mod

Procedure of production control, Procedure of Production Control 1. C...

Procedure of Production Control 1. Control  of activities : It  involves  the  release of manufacturing  orders, setting  plans  in motion  at assigned times  by means of  d

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