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

Which kind of portable computer will meet everyones needs, Your organizatio...

Your organization plans to acquire 250 new portable computers. The finance vice president has asked you to lead a project team assigned to define users' computer hardware needs and

Difference between performance and productivity measurement, 1. Explain the...

1. Explain the link between productivity and quality?  2. Who do van Biema and Greenwald (1997) and Drucker (1991) suggest are responsible for the slow growth in service sector

What area of human services do you find the most interesting, There are a w...

There are a wide variety of exciting and interactive professions in the field of human services. As demonstrated in the video below and through your reading, do you think that musi

Calculate the percent change in the labor ratios, A department employs 3 ty...

A department employs 3 types of workers: laborers earning $5 per hour, machine operators earning $9 per hour and maintenance workers earning $16 per hour. For a certain job over 2

Decision tree analysis applied to capacity expansion, Decision Tree Analysi...

Decision Tree Analysis Applied to Capacity Expansion Linear programming and computer simulation models focus on the short term question of how to use existing capacity. But the

Explain early retirement, Assume you are the project manager for a software...

Assume you are the project manager for a software company and your team is in charge of delivering an update to tax preparation software for the next tax season. The project team h

How to avoid penalties, Select an article relating to workplace safety and...

Select an article relating to workplace safety and answer the following questions: 1. briefly summarize the article 2. What alternatives could the place of business have taken in o

Explain what types of strategic plans must shoemaker make, Kathryn Shoemake...

Kathryn Shoemaker established Grandmothers Chicken Restaurant in Middleburg five years ago. It features a unique recipe for chicken,just like grandmother used to make.The facility

Develop an operations strategy for an organisation, How do you develop an o...

How do you develop an operations strategy for an organisation? Answer: There are many different procedures recommended by academics and individual consultancy companies. The mor

Define state licensure requirements that an organization use, Discuss state...

Discuss state licensure requirements that an organization must comply with in order to become a Medicare Advantage Plan, any exceptions to the State licensure requirement, and any

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