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

Explain measurable goals the decision maker seeks, Which is the marketing r...

Which is the marketing research term for the specific, measurable goals the decision maker seeks to achieve in conducting the marketing research? Research risks Research obje

Explain deviance and a moderate level of cohesiveness, Why is it important ...

Why is it important for groups and teams to have a balance of conformity and deviance and a moderate level of cohesiveness?

Explain what is the present value of the following annuities, What is the p...

What is the present value of the following annuities? a. $2,500 a year for 10 years discounted back to the present at 7% b. $70 a year for 3 years discounted back to the pres

Discuss what responsibility businesses towards environment, Environment Ple...

Environment Please respond to the following: •From the video, take a position on the ethical aspects of the logging industry on the local economies and the environment in the North

Multiple activity chart, how to do a multiple activity chart on making pota...

how to do a multiple activity chart on making potatoe chips

Which is a group of products that are closely related, A _____ is a group o...

A _____ is a group of products that are closely related because they satisfy a class of needs, are used together, are sold to the same customer group, are distributed through the s

Define current inventory control system for football helmets, Tune Football...

Tune Football Helmets Company is considering changing its current inventory control system for football helmets. The information regarding the helmets is given below. Demand = 2

Explain which depreciation method is preferable, 1. Your firm is considerin...

1. Your firm is considering an investment in a wind farm. Assume that the farm will cost $1 million per MW of installed capacity. The plan under consideration would deploy 10 GE 1.

Supply chain management, explain the extend to which SCM is applicable to a...

explain the extend to which SCM is applicable to a service operation like Cruise int.

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