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.

Previous Q& A

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.

Decision to investigate a variance

The decision to investigate a variance requires a comparison of expected benefits with expected costs. Suppose an unfavorable variance of \$1,000 is observed.

Supply-demand-equilibrium quantity and price

Find out the quantity demanded, the quantity supplied, and the magnitude of the shortage if a price ceiling of \$30 is imposed in this market. Also determine the full economic price paid by consumers.

Explain ping sweeps and port scans

Your boss has just heard about some nefarious computer activities known as ping sweeps and port scans. He wishesto know more about them and what the impact of these activities might be on company.

Estimating consumer surplus

The demand curve for the product X is given by Qdx = 460 - 4Px. How much consumer surplus do consumers receive when Px = \$35?

Determine the price to maximize revenues

Suppose you are a manager at the DaimlerChrysler. Daimler-Chrysler has lost fund on the Smart car since 1st model rolled off the assembly line in 1998.

Value chain activity in a hospital-health care organization

What would be a value chain activity in a hospital or health care organization? Where would you requireto make sure connection activities for your value chain to be successful? Describe.

Similar Q& A

Analyzing hard-to-obtain data from two separate databases

You are interested in analyzing some hard-to-obtain data from two separate databases. Each database contains n numerical values.

Explain relation schema and set of functional dependencies

Consider relation schema r(A,B,C,D,E, F) and a set of functional dependencies {A BCD,BCDE,BD,DA}. Calculate canonical cover for set of functional dependencies (show each step of your derivation with an explanation).

Implement a new learning management system

Its a lead a project that will implement a new learning management system for your university. You have two key tasks: Task 1: Investigate learning management software packages that are available through application service providers.

Analyse a set of data and write a memo

To analyse a set of data, and write a memo, identifying and explaining your insights into the operation of Todd Restaurants.

Write benefits of using dbms to manage data in program

Describe briefly what are the main benefits of using DBMS to manage data in program applications involving extensive data access.

Compute canonical cover for set of functional dependencies

Compute a canonical cover for the above set of functional dependencies (show each step of your derivation with an explanation).

Various kinds of keys to form or define relationships

Relational database is based on fact that data in one table can be tied, or related to data in another table. To do this, database utilizes various types of keys to form or define these relationships.

In 250 - 300 words describe role of a database administrator and the tasks performed by this role. Also, describe why this role is important in Database Management.

Number of leaf-level blocks needed if blocks are full

What is the order P of the B+-tree if B+-tree access structure on the key is constructed? What is the number of leaf-level blocks needed if blocks are approximately 69% full (round up for convenience)?

Determine a list of n numbers has no duplicates

Express given five loosely described problems carefully in { Instance, Question } form as utilized in "Computers and Intractability". Determine that a list of n numbers has no duplicates.

Create an e-r diagram

You have probably seen that already when you tried to create an E-R diagram. Visio uses notation and graphical shapes that are not the same as those in your text. If you look at some of the links to schemas, you will see a similar sort of thing.

Explain the datawarehouse and data mining concepts

There are six major types of information systems which organisations use in their operations. Discuss how these information systems support managers in their decision making role Explain the datawarehouse and data mining concepts using appropria..