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

Impact on the it group of supporting a variety of devices, What is the impa...

What is the impact on the IT group of supporting a variety of devices?

Public sector - health care, Public Sector - Health Care 1. Increased...

Public Sector - Health Care 1. Increased consumer demands - increased performance measurement 2. Increased quality of service and choice demanded 3. Increasing salaries

Advantages of work measurement, Advantages of Work Measurement: 1.    ...

Advantages of Work Measurement: 1.        It serves as a basis  for  methods  analysis by comparing  the efficiency  of alternative  work  method. Other  conditions  beings  t

Explain what happens to the leased property, Ann leases an office in Ted's ...

Ann leases an office in Ted's building for a one-year term. At the end of the period specified in the lease, the lease ends without notice, and possession of the office returns to

Explain leadership styles of both coaches, Write a 750-1,000-word paper tha...

Write a 750-1,000-word paper that analyzes the two leadership case studies, "Coach Knight: A Will to Win" and "Coach K: A Matter of the Heart." Address the following questions an

Explain what are the benefits of working for someone else, • What are the ...

• What are the challenges? What are the challenges of being an entrepreneur? What are the challenges of starting and building your own compan What are the benefits... •

Explain main summary task and a summary task, What is the difference betwee...

What is the difference between a main summary task and a summary task?

Explain reporting biases can occur, The use of surveys of experts to estima...

The use of surveys of experts to estimate long-run production costs may be undermined by the fact that- Reporting biases can occur It is dependent on the judgments of individ

Describe the importance of each in relation to outsourcing, List five consi...

List five considerations to consider when starting to define the scope of the business process outsourcing transaction and discuss the importance of each in relation to outsourcing

Explain what is the bonds'' coupon rate, Metal Fabricators just issued $1,0...

Metal Fabricators just issued $1,000 par 20-year bonds. The bonds sold for $758.18 and pay interest semi-annually. Investors require a rate of 9% on the bonds. What is the bonds' c

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