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

Calculate percentage of the time the inspector is idle, At a border vehicle...

At a border vehicles arrive at the rate of 9 per minute in a Poisson distribution. For simplicity in this problem assume that there is only one lane and one inspector who can inspe

Success of change initiatives is why many initiatives fail, Failure to anti...

Failure to anticipate and mitigate circumstances that might impede the success of change initiatives is why so many initiatives fail. From a business managers perspective, what doe

Explain how stance on social responsibility, Q1. Should an organization alw...

Q1. Should an organization always adopt a broad stance on social responsibility? Explain how you agree or disagree with this question and why you have this perspective. Q2. What

Operations function in an organisation - method study, Operations Function ...

Operations Function in an Organisation - Method Study  A procedure that has stood the test of time in the study of work entails six steps (often referred to by the acronym, SR

Give example of groupthink, You have been assigned the task of assembling a...

You have been assigned the task of assembling a team to accomplish some task or project in your organization. What do you do? What is important for you to know? What do you need to

Explain importance of strategic management, In light of the various theorie...

In light of the various theories of Strategic Management and Competition touched on in this course (e.g., the Resource Model of the Firm, internal/external analysis, SWOT, Value Ch

Describe management of telecommuters, All of the following are negative abo...

All of the following are negative about telecommunication except/1. Technical difficult with computer linkage/2.islotion from co-worker/3.decrease identification with work team/4.m

Explain what is the average setup cot per year, Radovilsky Manufacturing Co...

Radovilsky Manufacturing Company, in Hayward. California. Makes flashing lights for toys. The company operates its production facility 300 days per year. It has orders fo about 12,

Explain assess the strategy of wal-mart in china, Give your assessment of t...

Give your assessment of the requirements for Cuba to develop a free and independent trade union. Determine if it is essential for a free society. Assess the strategy of Wal-Mart

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