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

Distinctive of the growth stage of the product life cycle, Which of the fol...

Which of the following is a characteristic of the growth stage of the product life cycle? Advertising emphasis switches to selective demand. There is a growing proportion of

Explain collective bargaining, Collective bargaining replaces management's ...

Collective bargaining replaces management's traditional authority to unilaterally establish terms and conditions of employment with bilateral negotiations. How has the collective b

Explain what is resource levelling, Answer the following questions: 1) ...

Answer the following questions: 1) What is resource over allocation? 2) What is resource levelling? 3) Under what circumstances would you want to manually reso

What is myers-briggs type indicator, Many of us have taken assessments in t...

Many of us have taken assessments in the past, such as the ASVAB (Armed Services Vocational Aptitude Battery) or MBTI (Myers-Briggs Type Indicator); the latter is described in your

Describe traffic accidents requiring medical assistance, It has been observ...

It has been observed that the average number of traffic accidents requiring medical assistance in Santa Clara between 7 and 8 AM on Wednesday mornings is 1. What, then, is the chan

Compare the traditional and matrix organization, Compare and contrast the t...

Compare and contrast the traditional and matrix organization. What are its advantages and disadvantages of the matrix organization?

Find the probability that both service clerks are idle, Sharp Discounts Who...

Sharp Discounts Wholesale Club has two service desks, one at each entrance of the store. Customers arrive at each service desk at an average of one every twelve minutes. The servic

Explain supply management, What is the difference between purchasing and su...

What is the difference between purchasing and supply management? What is the difference between a supply chain orientation and supply chain management?

Explain ideas that would increase sales, Your best friend owns a small chil...

Your best friend owns a small children's clothing store located in the downtown area of a community of 50,000 citizens. Business has been slow the past year due the construction of

Explain use technology and information resources to research, Imagine that ...

Imagine that you are a senior manager for one of the following companies: • Apple • Burger King • Nike • General Mills Create a market entry strategy along with a st

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