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

Regarding process improvement, During the analysis of a process that was ev...

During the analysis of a process that was evaluated, it was seen that the variability was non-random on several occasions, i.e, it did not meet acceptable quality standards. Howeve

Computer aided design., Computer Aided Design is one of the techniques used...

Computer Aided Design is one of the techniques used by Regal Marine in manufacturing of boats. With the aid of exapmles, critically discuss five (5) techniques that are important t

Explain how many dollars should you convert to shillings, (Shillings) You a...

(Shillings) You are traveling abroad and have only American dollars with you. You are currently in the capital but you will soon be heading out to a small town for an extended sta

Define what is the probability that you will make money, The owner of Firew...

The owner of Firewood-2-Go is considering buying a hydraulic wood splitter which sells for $60000. He figures it will cost an additional $80 per cord to purchase and split wood wit

Explain contractual claims, Complete the following, placing it in a single ...

Complete the following, placing it in a single Word document- Having a clear understanding of the courts and where to file specific claims has provided your department with a go

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

How examine his deposit box, Several weeks after a depositor's death, Chase...

Several weeks after a depositor's death, Chase Manhattan Bank paid 12 checks on the deceased depositor's account. The depositor's signature on the checks had been forged. The estat

Explain what protocols should be considered, What protocols, if any, should...

What protocols, if any, should be considered in this needs assessment?

Computation to receive credit, Your company has a market share of 25%. The ...

Your company has a market share of 25%. The total market size is $100 million. Your contribution margin (the ratio of the contribution per unit over the price per unit) is 20%. You

Productivity challenge in organisations, Productivity Challenge in Organisa...

Productivity Challenge in Organisations Productivity is the ratio of outputs (goods and services) divided by the inputs (resources: labour, capital and services). It is one of

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