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 ethics addressed in the business world today, How are leadership tr...

How are leadership traits and ethics addressed in the business world today?

Explain collective bargaining and grievance procedure, When a union negotia...

When a union negotiates, with management, on behalf of its members to define and interpret employment contracts, it is known as: Answer (1) mediation. (2) Collective bargaining. (3

Define the term management, Define the term Management.  Ans:  "Mana...

Define the term Management.  Ans:  "Management is the accomplishment of results by the efforts of many people"  - LAWRENCE APPLEY   "Management is the art of getting

Describe how hr evolved throughout this process, HR has moved from an admin...

HR has moved from an administrative function to a transformational function. This change is based on automating HR functions through an HRIS system. Explain how HR evolved througho

Airline implementing a policy that need to buy second seat, Answer the foll...

Answer the following questions: 1. what are the pros and cons of an airline implementing a policy that heavier customers need to buy a second seat? Research an airline and provide

What way does a t1 use to achieve high throughput, What method does a T1 us...

What method does a T1 use to achieve high throughput over twisted pair wiring? a. frequency division multiplexing b. wavelength division multiplexing c. statistical multip

Explain human resource management contribution, How can human resource mana...

How can human resource management contribute to a company's success?

Explain what are the risks associated with backdoor, What are the risks ass...

What are the risks associated with backdoor (maverick) buying and selling? Why is purchasing interested in controlling this business practice?

Explain obstacles and the boat was operated properly, A water skier who bre...

A water skier who breaks his leg after a tumble while water skiing, where the lake was free of obstacles and the boat was operated properly, will probably fail to recover in an act

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