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 performance review nick received from warren, 1) You've had a varie...

1) You've had a variety of weekly leaders in this class, and you've all turned in Status Reports. What can you do to improve that process and better evaluate and manage your teamma

Describe views of organizational conflict, Discuss three barriers to effect...

Discuss three barriers to effective oral communication and possible remedies. Discuss 3 views of organizational conflict. When is conflict "good?" When is conflict "bad?"

Explain continuous inventory system, 1. A reduction in the number of kanban...

1. A reduction in the number of kanbans (given a constant container size) requires A. A reduction in safety stock and/or lead time B. A decrease in safety stock and/or lead t

Experiments indicate which the change will lower the average, A bank has re...

A bank has recently taken over the billing function of a company. An agreement stipulates that the bank should process 99.2% of the bills within 4 hours. A study of the current pro

Explain which style did you find most effective, Think back to teachers you...

Think back to teachers you have had, and identify one each who fits a supportive style, directive style, participative style, and achievement-oriented style according to the path-g

Depict a p-chart based on the questionnaire results, 1. A shirt manufacture...

1. A shirt manufacturer buys cloth by the 100-yard roll from a supplier. For setting up a control chart to manage the irregularities (e.g., loose threads and tears), the followi

Describe imagine that you are the release that might result, Search the new...

Search the news for a current event/ issue/ crises a company is dealing with today. Imagine that you are the release that might result in a favourable article. Follow the format su

Examine any new products in this marketplace, Assess how technology and the...

Assess how technology and the changing demands of customers have impacted the movie rental business. Suggest a strategy for Netflix's to prevent a new entrant into the marketplace

Explain supply chain activities, Compile a list of major system life-cycle ...

Compile a list of major system life-cycle activities. For each activity on the list, try to find the related supply chain activities. Present your finding in a table with the syste

Poor industrial relations vs.a conditions for good ir, Explain causes of Po...

Explain causes of Poor Industrial Relations vs.a conditions for good IR. Insufficient fixation of wages and wage structure - There is a requirement for payment of fair wag

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