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

How minimize the work-in-process inventory, The production manager must det...

The production manager must determine the processing sequence for 7 jobs through the grinding and debarring departments. The same sequence will be followed in both departments. The

What is the assessment of overall industry attractiveness, Goggle's Strateg...

Goggle's Strategy 2010: Which of the five competitors seem strongest against Google? Weakness? What is your assessment of overall industry attractiveness?

Explain why business management is a good career choice, I need a well writ...

I need a well written paper on why business management is a good career choice?

Explain what elements interest in the negotiations, Assuming that I am the ...

Assuming that I am the negotiator who is tasked with a salary (on call time, step increases, overtime for captains and majors) and benefits (insurance while employed, insurance aft

Explain what is economic justification for the rapid growth, What is the ec...

What is the economic justification for the rapid growth of premium package services?

Explain what is the role and impact of hr practices, What is the role and i...

What is the role and impact of HR practices domestically and internationally when globalization forces the organization to seek expansion overseas?

Explain how is ace products organized, Steffi Graf has assumed leadership o...

Steffi Graf has assumed leadership of Ace Products after many years of loyal service. Ace Products is an international manufacturer of copiers, printers, and fax machines. Historic

Calculate electrical, Test results from an electronic circuit board indicat...

Test results from an electronic circuit board indicate that 50% of board failures are caused by assembly defects, 30% are due to electrical components, and 20% are due to mechanica

Explain why organizational restructuring is needed, Matrix structures allow...

Matrix structures allow for workers to be shared on multiple projects and at a lower than usual cost. Answer To be shared on multiple projects and at a lower than usual cost

Determine whether ability and motivation is more important, Determine wheth...

Determine whether ability or motivation is more important in selecting the right person for the right job. Explain your rationale.

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