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

Describe the difference between consumer products, Explain the difference b...

Explain the difference between consumer products and business products. Why are some products difficult to categorize as one or the other? Give an example of a business product, a

Explain build the pilot project and then make a decision, Dan Reid, chief e...

Dan Reid, chief engineer at New Hampshire Chemical, Inc., has to decide whether to build a new state-of-art processing facility. If the new facility works, the company y could real

Explain core value functioning system, In what ways and with two examples, ...

In what ways and with two examples, did Mentor Graphics fail at not focusing on where they wanted to be in the future, in giving a clear definition to the employees and creating a

Explain what is the firm''s code of conduct, Governance mechanisms are cons...

Governance mechanisms are considered to be effective if they meet the needs of all stakeholders, including shareholders. Governance mechanisms are also an important way to ensure t

Explain select one and critique its content, Conduct a search of websites t...

Conduct a search of websites that provide Internet presentations. Select one and critique its content, visuals, and the presenter's skills. Make sure to include the URL in your Dis

Briefly describe the four different approaches to social, Briefly explain t...

Briefly explain the four different approaches to social responsibility that an organization can adopt.

What are the advantages as well disadvantages of financing, What are the ad...

What are the advantages and disadvantages of financing via the internet?

Explain what are personality traits, 1. What are personality traits? Define...

1. What are personality traits? Define and discuss the Big Five personality traits. Define and discuss other personality traits that affect managerial behaviour. 2. Explain Rike

Forecasting, The cafeteria supervisor at CarWash is interested in developin...

The cafeteria supervisor at CarWash is interested in developing a forecast model for the number of meals to be prepared each day. The following daily data from the cafeteria’s regi

Relationship between process planning and other operations, Relationship be...

Relationship between process Planning and Other Operations Figure below shows that process planning is the basis for the design buildings layout of facilities and selection

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