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

Define a small computer firm orders monitors for sale, A small computer fir...

A small computer firm orders monitors for sale. The annual demand is 1300 per year. The holding cost is 10 percent of the value of the monitors on hand. Each time they order it cos

Describe strategic management concepts and cases, Threadless (in Strategy H...

Threadless (in Strategy Highlight 1.1) is an example of a firm building on its customer base to use new products and also to participate in the design and vetting of popular design

Operation research, A paper mill produces two grades of paper viz., X and Y...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

Compute panera breads strategy and its effectiveness, Evaluate Panera Bread...

Evaluate Panera Breads strategy and its effectiveness with executing the strategy within the competitive fast-casual restaurant marketplace. Discuss the pitfalls to this strategy a

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

Explain what goes wrong in organizations, During the past five weeks, you h...

During the past five weeks, you have written several papers examining various organizational behaviour problems that materialize in organizations. Review all of those papers and ot

Explain what is marketing research, What is Marketing Research? Why do succ...

What is Marketing Research? Why do successful firms conduct marketing research for their products/services? Discuss the six steps in the Marketing Research process and relate to an

Two handed process chart and multiple activity charts, Two Handed Process C...

Two Handed Process Chart and Multiple Activity Charts Two-handed process chart  For fixed-position manual processes such as the assembly of small devices, this type of ch

Simulation, Which of the following probability distributions cannot be simu...

Which of the following probability distributions cannot be simulated ?

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