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

Analytical estimating, Analytical Estimating This technique  of work m...

Analytical Estimating This technique  of work measurement  is used  to determine the  time  values for jobs  having  long and  non repetitive  operations. The time  values  ar

How is the supply chain cake industry by applying stages, How is the supply...

How is the supply chain cake industry by applying stages? The supply chain cake industry by applying stages as by given factors: • Farmer as like producer of commodities as

Explain buckroe beach virginia illegal, Buckroe Beach Virginia illegal put ...

Buckroe Beach Virginia illegal put what in someone's swimsuit

Work study, What are all the steps involved in work study?

What are all the steps involved in work study?

Explain what do you think needs to be improvement, B. Using the IT Savvy fo...

B. Using the IT Savvy four types of the CIO (page 146 IT Savvy), choose a type for each of CIO or IT leaders for all of the cases we have reviewed in this class. Give example of w

Explain what are the pitfalls, Essentially relativism reject the notion tha...

Essentially relativism reject the notion that there is are no absolutes that govern our behaviour. How then do we determine how we behave? How reasonable and plausible is this posi

Explain what would they have to learn elsewhere, What kinds of information ...

What kinds of information do you think recruiters can legitimately expect to learn on a social networking site? What would they have to learn elsewhere? How do you protect yourself

Explain how does a company''s vision and plans affect, How does a company's...

How does a company's vision & plans affect its structure?

Describe turnaround at the preston plant, CASE STUDY; Turnaround at the Pre...

CASE STUDY; Turnaround at the Preston Plant SPC is an operational level technique of ensuring quality conformance. How many of the benefits of bringing the plant under control wou

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