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 full capacity and with product demand rising, Develop a decision tr...

Develop a decision tree for the case of a company is operating at full capacity and with product demand rising. The choice is between new equipment and overtime. A 20% rise in sale

OPERATTION MANAGEMENT, DISCUSS THE ADVISABILITY OF USING MODULAR ASSEMBLIES...

DISCUSS THE ADVISABILITY OF USING MODULAR ASSEMBLIES IN MANFACTURING

Electronic executive information systems, Electronic Executive Information ...

Electronic Executive Information Systems (EIS) and Expert Systems (ES) are examples of  Decision based software.

Explain what would they have to learn elsewhere, What kinds of information ...

What kinds of information do you think recruiters can legitimately expect to learn on a social networking site? What would they have to learn elsewhere? How do you protect yourself

Quality control, power electronic buys 45ohm resistor, standard deviation f...

power electronic buys 45ohm resistor, standard deviation for this register is 4ohm.sample size of n=

Explain enterprisewide analytical capabilities, Knowledge: List the reasons...

Knowledge: List the reasons a business would need consistently updated enterprisewide analytical capabilities

Explain what must the beta of this stock be, A stock has an expected return...

A stock has an expected return of 10.2 percent, the risk-free rate is 4.5 percent, and the market risk premium is 8.5 percent. What must the beta of this stock be?

Explain what benefit would using the optimal order quantity, Garden Variety...

Garden Variety Flower Shop uses 760 clay pots a month. The pots are purchased at $2 each. Annual carrying costs per pot are estimated to be 30 percent of cost, and ordering costs a

Suppose the number of requests for week, An electrical contractor's records...

An electrical contractor's records during the last 5 weeks indicate the number of actual job requests. Predict the number of requests for week 6 using each of the below methods:

Explain what effective leadership means, Describe what effective leadership...

Describe what effective leadership means to you. Who determines a leader's effectiveness? Provide details and examples to support your thoughts.

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