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 can controlling asist a manager to become more efficient, How can contr...

How can controlling help a manager to become more efficient?

Explain strategic decision support, Strategic decision support Alignment...

Strategic decision support Alignment of information technology and management goals in healthcare is essential. This alignment assumes that information technology experts be abl

Explain as the administrative manager in a law office, As the administrativ...

As the administrative manager in a law office, you have been asked to develop a system for evaluating the productivity of the 15 lawyers in the office. What difficulties are you go

What are the classified different stock items, What are the classified diff...

What are the classified different stock items? The ABC system of inventory management Various stock items are classified as like: a. High value (A) b. Medium value (B

Explain changing nature of work and the workplace, Effective human resource...

Effective human resources professionals have a solid understanding of the changing nature of work and the workplace. Compare and contrast the evolution of work and the workplace ov

Define the firm carry out the environmental scanning process, How should th...

How should the firm carry out the environmental scanning process? What would the process be of any practical value?

Explain job requirements help, How might formally written job requirements ...

How might formally written job requirements help you manage your work unit?

Calculate the total cost of ordering and carrying clay pots, 1. Garden Vari...

1. Garden Variety Flower Shop uses 1000 clay pots a month. The pots are purchased at $3 each. Annual carrying costs per pot are estimated to be 25% of cost, and ordering costs are

Define what will be the average number of jobs in the system, A single mach...

A single machine work center has five jobs assigned to it. They are labelled, in the order of their arrival in the shop, as jobs A, B, C, D and E. The work center may work on only

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