Creating erd containing order and customer entity

Assignment Help Database Management System

Reference no: EM1347734

Create ERD containing Order and Customer entity types connected by 1-M relationship from Customer to Order. Select suiatble relationship name using your common knowledge of intersection between customers and orders. Define minimum cardinalities so that an order is optional for customer and a customer is mandatory for an order. For the Customer entity type, add attributes CustNo(primary key), CustFirstName, CustLastName, CustStreet, CustCity, CustState, CustZip, and CustBal (balance). For the Order entity type, OrdCity, OrdState and OrdZip.

Reference no: EM1347734

Questions Cloud

Program to enter answer to a math problem : Write a program which ask student to enter an answer to a math problem. The user must enter two values, one at time, and then ask for answer.

Fixed and flexible budget : Compare bottom-line financial results of using the fixed budget and flexible budget if volumes (a) increase by 10% or (b) decrease by 10%.

Find the same rate of acceleration : A 150g ball and a 250g ball are connected by a 34cm long, massless, rigid rod. The balls rotate about their center of mass at 130 . what is the speed of ball of 150 g.

Access and examine budget of united states : What percentage of gross domestic product does spending for federal programs represent? What percentage does state and local government spending represent?

Creating erd containing order and customer entity : Create ERD containing Order and Customer entity types connected by 1-M relationship from Customer to Order. Select suiatble relationship name using your common knowledge of intersection.

The stock valuation approach : Stock valuation method uses discounted cash flows theory to compute the theoretical value of a stock. The most popular academic method is dividend growth model.

Find out the possible range of wavelengths in air : What is an amplitude at a point where two pulses are crossing if the end at which reflection occurs is free to slide up and down.

Explain the conflicts : Please explain in detail that why are there conflicts of interest between mutual fund investors & companies and individuals that organize, sell, & provide services to mutual funds?

How to draw free-body diagrams of blocks : A new General Electric kitchen stove has a mass of 68kg and the dimensions. The stove comes with a warning that it can tip forward if the person stands or sits on oven door when it is open.

User Account

All Pages