Reference no: EM131054194
Consider a MAIL_ORDER database in which employees take orders for parts from customers. The data requirements are summarized as follows:
¦ The mail order company has employees, each identified by a unique employee number, first and last name, and Zip Code.
¦ Each customer of the company is identified by a unique customer number, first and last name, and Zip Code.
¦ Each part sold by the company is identified by a unique part number, a part name, price, and quantity in stock.
¦ Each order placed by a customer is taken by an employee and is given a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded.
Design an Entity-Relationship diagram for the mail order database and build the design using a data modeling tool such as ERwin or Rational Rose.
|
Mike roa for the year
: "Mike Smith has the following financial data. Investment Assets at Year End $475,000 Investment Assets at Beginning of the Year $392,000 Savings Made During the Year by Mike $27,000 Employer Match to Mike s 401(k) Plan $5,000 Total Assets on Endin..
|
|
Piece of equipment that can be leased or purchased
: Connors Construction needs a piece of equipment that can be leased or purchased. The equipment costs $50. One option is borrow $50 from the local bank and use the money to buy the equipment. The other option is to lease the equipment. The company'..
|
|
How they can be represented in an er schema diagram
: There are several composite keys for section, and some attributes are components of more than one key. Identify three composite keys, and show how they can be represented in an ER schema diagram.
|
|
Build the design using a data modeling tool
: build the design using a data modeling tool
|
|
Design an entity-relationship diagram for the mail order
: Design an Entity-Relationship diagram for the mail order database and build the design using a data modeling tool such as ERwin or Rational Rose.
|
|
How might an awareness of the communication process
: Keeping in mind all of our course material to date, describe the communication skills you feel are needed to be an effective interviewer AND also an effective interviewee.
|
|
Design an er schema for keeping track of information
: Design an ER schema for keeping track of information about votes taken in the U.S. House of Representatives during the current two-year congressional session
|
|
What premium is associated with the warrants
: If investors pay $1,200 for each bond, what is the value of each warrant attached to the bond issue? What is the component cost of these bonds with warrants? What premium is associated with the warrants?
|
|
Determine the equilibrium level graphically
: The economy has no government expenditure and does not have any foreign trade at present but it does have investment expenditure, which is constant at €150. Determine the equilibrium level graphically
|