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

Determine the appropriate sample size, Determine the Appropriate Sample Siz...

Determine the Appropriate Sample Size The following work sampling data was collected from observing a retail assistant:  Activity

Depict a sequence diagram, Hertford Post Office Situation: Hertford has a t...

Hertford Post Office Situation: Hertford has a typical small town post office that sells stamps, rents post office boxes, and delivers mail to postal customers. a. Identify possibl

Explain how is production levelling related to 5s, How is production levell...

How is production levelling related to 5S and Value Stream Mapping?

Explain abilities and personalities, 1. Using the terms from this chapter, ...

1. Using the terms from this chapter, how would you characterize the teams at ICU Medical Inc.? What are some advantages and disadvantages of giving teams a lot of autonomy to make

Explain what are the challenges associated with erp system, Research ERP sy...

Research ERP systems by visiting the ERP company provider website of your choice (i.e., SAP, Ellucian, Oracle, Peoplesoft, Microsoft, Workday, etc.) Write an essay of between 750-1

Explain about the organization and its resources, 1. How to characterize yo...

1. How to characterize your supervisor's approach to management? For example, which particular management tasks and roles does this person perform most often? What kinds of managem

Compute the value of the policy variable, You are asked to analyze the kanb...

You are asked to analyze the kanban system of LeWin, a French manufacturer of gaming devices. One of the workstations feeding the assembly line produces part M670N. The daily deman

Explain what is the probability distribution of the time, Consider a queuin...

Consider a queuing system with 2 types of customers. Type 1 customers arrive according to a Poisson process with a mean rate of 5 per hour. Type 2 customers arrive according to a P

Explain what is the value creation frontier, 1.Why does each generic busine...

1.Why does each generic business model require a difficult set of business-level strategies? Give examples of pairs of companies in: (a) the computer industry; (b) the electronics

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