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

Compare today''s business world with the one of 40 ago, How does today's bu...

How does today's business world compare with the one of 40 ago? What is different about today and what is not so different? Electronincs assembly Inc. operates two 8 hour shifts

Explain forces for change can either be internal or external, Forces for ch...

Forces for change can either be internal or external. Describe each of these forces that can cause a change and give an example of each type of force.

Explain what are the minimum and maximum cycle times, An assembly line with...

An assembly line with 17 tasks is to be balanced. The longest task is 2.1 minutes, and the total time for all tasks is 23 minutes. The line will operate for 480 minutes per day. a.

Explain the factors determining the sequencing of jobs, Question : (a) ...

Question : (a) Show how operations management can contribute to the success of an organization. (b) Explain the factors determining the sequencing of jobs. ( c) A machin

Straighten(seiton)&sustion(shitsuke), explain and give for examples hotels ...

explain and give for examples hotels services...how them service ?

Explain worker adjustment and retraining notification act, Outline the prov...

Outline the provisions of the Worker Adjustment and Retraining Notification Act (WARN) of 1988 stating its rules, liabilities, and loopholes. Discuss the reasons why this act was c

Layouts of supermarkets, pick a supermarket of your choice, observe the lay...

pick a supermarket of your choice, observe the layout and why the layout is like that

Explain swot analysis of united airlines, Can you help me with the swot ana...

Can you help me with the swot analysis of united airlines?

Compute the start and finish times for each activity, Calculate the start a...

Calculate the start and finish times for each activity and determine the minimum number of weeks for completing the project. Find the critical set of activities for the project.

Explain open-systems and open-space methods, Compare and contrast the open-...

Compare and contrast the open-systems and open-space methods for large-group interventions.

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