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

Manufacturing process technology, eloberate manufacturing process technolog...

eloberate manufacturing process technology with its types. project,jobshop,batch,assembly line,contineous..?

Comparisons between costs of a product in different periods, Ques: How can ...

Ques: How can we make comparisons between the cost of a product in two different periods if salaries and cost of living may have changed? Ans: The average income is published in

Derive the demand functions of agent for good, 1. An agent has a utility fu...

1. An agent has a utility function over goods 1 and 2 of the form U = x c 1 x d 2 where c is your individual number and d is your minimum number. The agent's income is equal t

Line balancing, Describe What happens if balance doesn’t exist

Describe What happens if balance doesn’t exist

Explain how does the grapevine develop, Should a manager be concerned with ...

Should a manager be concerned with the grapevine within his or her organization? Why or why not? How does the grapevine develop? Is the grapevine a valid communication process? Sho

Compute number of workers needed for each department, Calculate number of w...

Calculate number of workers needed for each department to produce 2000 units per day and complete the table below to assist you in answering questions e.)è?j.). (e) What is the tot

Explain the linear program, The linear program MAX 3A+4B St. -1A + 2b ? ...

The linear program MAX 3A+4B St. -1A + 2b ? 8 1A+2B ? 12 2A+1B ? 16 A,B ? 0 1-write this problem in the standard form ? 2-Solve the problem using the graphical solution proced

Evidenced predictive capabilities of a leader, Question 1: Traits theor...

Question 1: Traits theories are not sufficient for explaining Leadership! i. Give an account of the other complementary Contingency theories or parts of the theories that d

Explain operations research and management science, In the Howard Raffia ar...

In the Howard Raffia article on Decision Analysis, there is an excellent perspective on one man's intellectual journey through the use of quantitative and qualitative analysis to a

Intermittent and continuous operations, Explain intermittent and continuous...

Explain intermittent and continuous operations. Under what type of situation it would be used in automobile industry?

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