Design the appropriate er-schema diagram

Assignment Help Computer Engineering

Reference no: EM132153462

A trucking company is responsible for picking up scheduled regular shipments from different warehouses and delivering these shipments to individual supermarkets.

A shipment is just a quantity of a specific item that is scheduled to be delivered to a specific supermarket from a specific warehouse by a specific truck (each scheduled shipment is taken from one warehouse, carried by one truck, and delivered to one supermarket). A truck may carry several shipments from several warehouses for several supermarkets.

A warehouse stores and delivers only one kind of items. A supermarket may be supplied by several shipments from several warehouses by several trucks.

It is only required to keep track of the type (type of item), quantity, and date of each regular scheduled shipment delivered to each supermarket from each warehouse and carried by each truck.

Design the appropriate ER-schema diagram for the given data requirements Specify all key attributes and all structural constraints.

Give also the corresponding relational schema.

Specify all integrity constraints for each defined relation. Design the appropriate ER-schema diagram for the given data requirements Specify all key attributes and all structural constraints. Give also the corresponding relational schema.

Specify all integrity constraints for each defined relation.

Design ER Schema Diagram Relational Schema Diagram

How would be the ER and the relational schemas for the same data requirements but with the constraint: each truck is allowed to deliver shipments for only one supermarket?

You can show only the changes in both the ER and Relational Schemas.

Reference no: EM132153462

Questions Cloud

Firm domestic investment : Do increases in profits increase a firm's domestic investment? What will determine the decision?

Bargaining between a customer and a used car dealer : From a game theory perspective, how would you characterize the bargaining between a customer and a used car dealer?

What is the actuarially-fair premium : A group of individuals each face a 1% probability of suffering a loss of $10,000, a 4% probability of suffering a $1,000 loss, a 20% probability of suffering

What is gaap : 1. What is GAAP? 2. What is an audit and why are audits performed?

Design the appropriate er-schema diagram : A trucking company is responsible for picking up scheduled regular shipments from different warehouses and delivering these shipments to individual supermarkets

Economic expansion a good idea : If the credit union opening is Storrs only cared about health is their policy of giving low interest loans during economic expansion a good idea?

The propagation delay is independent of the message size : Non-persistent TCP connection takes more time for data transfer (compared to a persistent connection).

Experiences or practicum observations : In your experiences or practicum observations, what classroom setups did you find most useful? How do you see implementing these components in your classroom?

What if the size of the usb flash drive is increased : You also have an LTE data card that connects to your portable computer and receives data any where you're located at a rate of 50 Mbps.

User Account

All Pages