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 organizational structure of your ideal work location, Tell me what ...

Tell me what the organizational structure of your (Ideal) work location would look like, using the terminology of this chapter 17. Use terms like mechanistic, organic, open, closed

Explain line balancing, Explain Line Balancing. Line Balancing: It m...

Explain Line Balancing. Line Balancing: It means balancing the line between the product lines or assembly lines. This aims at grouping facilities and workers in an efficient

Describe key issues and concerns, As area sales manager for a company manuf...

As area sales manager for a company manufacturing and marketing outboard engines, you have been assigned the responsibility of conducting a research study to estimate the sales pot

Scrutinise the process sequences and calculate annual cost, Scrutinise the ...

Scrutinise the Process Sequences and Calculate Annual Cost A company produces a range of product, but the dominant demand is for three of them, A, B and C. The table shows the

Explain optimal number of bookcases are produced, Question: S&V Industries ...

Question: S&V Industries manufactures book cases. Different sizes of cases are kept in inventory. The company has 80 man-hours and 36 pounds of wood available each day. 2 pounds of

Explain what is the role and impact of hr practices, What is the role and i...

What is the role and impact of HR practices domestically and internationally when globalization forces the organization to seek expansion overseas?

Give specific example of all type of strategy marketing plan, Imagine that ...

Imagine that you are creating a marketing plan for a company that will sell motor scooters . As you consider the marketing program, what types of strategy should you consider inc

Explain horizon to develop a forecast against, Why is forecasting important...

Why is forecasting important in organizations, especially as related to understanding the relevant time horizon to develop a forecast against? What are some examples from industry?

What are the benefits and limitations of e-business, 1. Describe, in genera...

1. Describe, in general terms, the quality of staff needed to manage an ERP system?  2. According to Cisco Systems, on what simple truth is their entire Internet commerce initia

Explain what purpose does the project charter serve, a. What purpose does t...

a. What purpose does the Project Charter serve? b. What are the main components or sections of the Project Charter? c. What purpose does the Project Definition Document serve

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