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 capacity planning involving hiring, Capacity planning involving hir...

Capacity planning involving hiring, layoffs, some new tooling, minor equipment purchases, and subcontracting is considered as which one of the following planning horizons?

Compute the degrees of freedom associated, In each of the following situati...

In each of the following situations, distinguish which statistical analysis you would conduct and which appropriate test or test statistic should be used. • Consumer preferences

Explain co-worker whose job performance is superior, Spencer just learned t...

Spencer just learned that his salary is $10,000 more than a co-worker whose job performance is superior to his. Equity theory would predict that Spencer would do any of the followi

Explain factors weighing the pros and cons, Examine each possibility and th...

Examine each possibility and the factors you will consider in weighing the pros and cons.

What is the distinction between prediction and forecasting, Question 1: ...

Question 1: Show the nature and importance of the four logistics-related elements of customer service. Question 2: (a) Describe the concept of supply chain management.

Define ethical responsibilities and social responsibilities, Explain the di...

Explain the difference between ethical responsibilities and social responsibilities of a manager. Please in you own words.

Find revenue from its recently won government contract, Buckeye Manufacturi...

Buckeye Manufacturing expects to generate additional revenue from its recently won government contract. Buckeye forecasts that the revenue will be $40 million in the first year, bu

Explain design-oriented hazards, A comprehensive safety assessment report c...

A comprehensive safety assessment report contains both testing and hazard analysis. What types of safety testing would be performed on commercial aircraft to identify any design-o

Explain the challenges in using the mbti instrument, Describe the challenge...

Describe the challenges in using the MBTI instruments or Keirsey Temperament sorter in project management situation and how you would address them. Speculate the acceptance level o

Explain business relationship, Joan has been a manager with Argos for the p...

Joan has been a manager with Argos for the past 15 years. She is known to be aggressive and tough and always gets results. She is demanding of her employees and is often brusque wi

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