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

Negative feedback in open system, Negative Feedback in Open System A u...

Negative Feedback in Open System A ubiquitous feature of all open systems is feedback. This is necessary for a system to maintain dynamic equilibrium despite being subjected t

Explain what are the optimal solution values of x and y, Suppose the firm i...

Suppose the firm in this example considers a second product that has a unit profit of $5 and requires 2 hours for each unit produced. Assume total production capacity remains 40. U

Introduction of operations strategy, Introduction of Operations Strategy ...

Introduction of Operations Strategy The term strategy, given in the Collins English Dictionary is, 'the art or science of the planning and conduct of a war; generalship; a lon

Explain what are the correlation coefficient, Mark Gershon, owner of a musi...

Mark Gershon, owner of a musical instrument dis-tributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 du

Simplex method , Q3. Solve the following Linear Programming Problem using S...

Q3. Solve the following Linear Programming Problem using Simple method. Maximize Z= 3x1 + 2X2 Subject to the constraints: X1+ X2 4 X1+ X2 2 X1, X2 0

Get a financial analysis of coca cola comparing the past 5y, Where can i fi...

Where can i find a financial analysis of coca cola comparing the past 5yrs from 2009-2013. Something in a word format would be help

Explain what is the current state of hrm, What is the current state of HRM-...

What is the current state of HRM-r related technologies in your organization? What are organizational leaders' positions as they relate to using HRM-r related technologies (for

Depict conclusions regarding both the long term, Complete a SWOT analysis f...

Complete a SWOT analysis for McDonald's to include SO, WO, ST, and WT Strategies, then develop a SPACE matrix for McDonald's. Using these matrices, draw conclusions regarding both

Define what differences exist in their operations strategies, Using the inf...

Using the information about Pal's Sudden Service provided in this chapter, apply Hill's generic strategy framework in a similar fashion as the McDonald's example. How do the strate

Explain objective functions for an lp model equivalent, Are the following o...

Are the following objective functions for an LP model equivalent? That is, if they are both used, one at a time, to solve a problem with exactly the same constraints, will the opti

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