Reference no: EM13924821
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.
|
Can concentration risks be reduced via cdos
: Can concentration risks be reduced via CDOs? Please elaborate. Explain distressed debt. Why do institutions prefer to sell distressed debt?
|
|
Five functions of effective management
: In 2012, Carl's Jr. reported a total revenue of $1.3 billion in sales (CKE, 2012). The QSR magazine (2010) ranks Carl's Jr. at number 23 in 2010, with its predominant sales being of burgers.
|
|
Process for producing synthetic diamonds
: A new process for producing synthetic diamonds can be operated at a profitable level only if the average weight of the diamonds produced by the process is greater than 0.5 karat.
|
|
Positioning strategy for marketing the new product
: Put yourself in the position of an entrepreneur who is developing a new product to introduce into the market. Briefly describe the product. Then develop the segmentation, targeting, and positioning strategy for marketing the new product.The overal..
|
|
Develop a logical database model for the company
: 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.
|
|
What are the major types of credit derivatives
: What are the major types of credit derivatives? Is it necessary for a credit protection seller to have expertise in credit risk analysis? Please elaborate.
|
|
How did erasmus use humanism to shape christian ideas
: How did Erasmus use humanism to shape Christian ideas? How did he use religious works to spread the ideas of humanism
|
|
What is trs and explain its advantages and disadvantages
: What is TRS? Explain its advantages and disadvantages. Explain the difference between the credit option and the credit spread option.
|
|
American culture and expansion
: Identify the innovator from 1815-1860 you feel had the most significant impact on American culture and expansion, including which innovation(s) and why.
|