Reference no: EM13924726
The Case of ABC Electric:
ABC Electric wishes to create a database with the following entities and attributes:
· Customer, with attributes Customer_ID, Customer_Name, Customer_Address (Street, City, State, Zip code), Customer_Type (Business or Residential)
· Location, with attributes Location_ID, Location_Name, Location_County
· Rate, with attributes Rate_Class, Rate_Per_ kwh
After interviews with the company employees and its customers, you have come up with the following business rules:
· Locations are geographical areas such as cities, towns, etc.
· Customers can have one or more locations.
· Each location can have one or more rates, depending on the time of day.
Question 1 for the Case:
Please use either Access notation (i.e., one-1, many-∞) or ER modeling notation (i.e., one- , many- )(see slide 3.28) to develop a logical database model for the company. You also need to (1) create associative entities (with attributes) to simplify many-to-many relationships whenever necessary, and (2) use verbs to describe the relationships. Similar database model can be found in slide 7.12, which uses ER notation. The Draw function in Microsoft Word is preferred to illustrate the model.
Question 2 for the Case:
Write SQL statements to develop database tables for each of these entities in the model.
|
What was return on investment in percent
: Ashley invested $4,500 in the stock of target. She received $226.00 in dividends from stock and sold it one year later for $4,100. What was Asley's return on investment in percent?
|
|
An investment project provides cash inflows
: An investment project provides cash inflows of $1,125 per year for eight years. What is the project payback period if the initial cost is $3,800? Payback period years Requirement : What is the project payback period if the initial cost is $4,850?
|
|
Prepare the journal entries record the bond issue on january
: Assume that all entries to accrue and pay interest were recorded correctly.
|
|
General feeling of pleasure or disappointment
: 1) Total customer satisfaction is the general feeling of pleasure or disappointment that results from comparing perceived performance to expectations. To achieve total customer satisfaction, organizations need to_____________.
|
|
Write sql statements to develop database tables
: Write SQL statements to develop database tables for each of these entities in the model.
|
|
Outstanding with various times-to-maturity and coupon rates
: Microsoft currently has 21 long-term bond issues outstanding with various times-to-maturity and coupon rates. One of these bonds matures on June 1, 2039, approximately 25 years from today. The bond is currently selling for $1,153.06, based on a face ..
|
|
Ceo providing an overview of the task
: A cover memo to the CEO providing an overview of the task assigned and a summary of your proposal
|
|
What is the average accounting return
: A project has an initial cost of $42,000 and a four-year life. The company uses straight-line depreciation to a book value of zero over the life of the project. The projected net income from the project is $1,400, $3,600, $4,000, and $4,500 a year fo..
|
|
What is their yield to call
: Highfield Inc's bonds currently sell for $1,400 and have a par value of $1,000. They pay a $140 annual coupon and have a 20-year maturity, but they can be called in 5 years at $1,540. What is their yield to call (YTC)?
|