Write set of relational schemas-identify primary-foreign key

Assignment Help Database Management System

Reference no: EM1367131

We want to construct a database for a world-wide package delivery company (e.g., DHL). The database must be able to keep track of customers who ship items and customers who receive items (some customers may do both). For each customer, the database needs

to store the customer ID, name and address. Each package must be trackable, so the database must
store the locations through which the package has gone. For each location, the database needs to
store the location ID, the city name and the country name. For each package, the database must
store the package ID and the weight.

(a) Draw an E-R diagram that reflects the above reuirements.

(b) Define a set of relational schemas and identify primary and foreign keys. Try not to include redundant schemas.

Reference no: EM1367131

Questions Cloud

Valuation of call option : A European Call Option on a non dividend paying stock where stock value is $40, the strike price is $40, the risk-free rate is 4 percent per annum, the volatility is 30 percent per annum,

Determining equilibrium prices and quantity : Lawn mowing services are supplied by host of individuals in suburb of Westbrook. Demand and supply conditions in the perfectly competitive domestic for lawn mowing services are:

Revenue maximizing : Assume your elasticity of demand for your parking lot spaces is -.05, and price is $20/day. If your MC is zero, and your capacity at 9 a.m. is 96% full over the last month, are you optimizing?

What is the final translational rms speed of molecules : A snowball rolls off a barn roof that slopes downward at the angle of 40 ^circ. The edge of the roof is 14.0 {rm m} above the ground, and the snowball has a speed of 7.00 {rm m/s} as it rolls off the roof. Ignore air resistance.

Write set of relational schemas-identify primary-foreign key : Sketch an E-R diagram which reflects the above reuirements. Write a set of relational schemas and identify primary and foreign keys. Try not to include redundant schemas.

Buying imports versus buying domestic products : Determine the advantages or disadvantages of buying imports versus buying domestic products in relation to fashion industry.

Jcaho requirements for documenting : You frequently hear references to JCAHO requirements for documenting a patient's pain assessment and treatment, documenting medication administration, or documenting verbal telephone orders.

Calculate the forward discount : Calculate the forward discount or Premium for the Mexican peso whose 90-day forward rate is $.102 and spot rate is $.10. State whether your answer is a discount or premium.

Provide an expression in relational algebra : Provide expression in relational algebra for each of the following queries: Give all the managers in database a 10 percent salary raise. Give all the other employees a 5 percent salary raise.

User Account

All Pages