IT Question that I need help with

Computer Science
Price: $20 USD

Question description

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 neighborhood. 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 FoodSupplier (but a supplier can supply many food items). A Toy can be supplied by multiple ToySuppliers. A ToySupplier can supply many Toys.
Extend the design to include Veterinarians, PetSuppliers, and ToySuppliers.

Tutor Answer

(Top Tutor) Daniel C.
School: Duke University
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1828 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors