Reference no: EM13921363
Please include the questions with your answers. Answer in complete sentences where applicable.
1. Give an example of a data constraint and an example of a business rule. Be sure to label which is which so I can tell you know the difference.
2. Explain the difference between an entity class and an entity instance, and give an example other than those used in the text or the lectures.
3. Define the term "weak entity" and give an example other than those used in the text.
4. Define supertype, subtype and discriminator.
5. Explain the difference between and inclusive subtype relationship and an exclusive subtype relationship.
6. Using Microsoft Visio 2013 (available through DreamSpark) draw an IE Crow's Foot E-R diagram for the entities DEPARTMENT and EMPLOYEE. A DEPARTMENT may have more than one EMPLOYEE, but an EMPLOYEE is only assigned to one DEPARTMENT. Assume that a DEPARTMENT does not need to have an EMPLOYEE, but that every EMPLOYEE is assigned to a DEPARTMENT. Include at least three appropriate identifiers and attributes for each entity.
7. Explain the following crow's foot E-R diagram. Be sure to include entities, keys, attributes, cardinality. What is the special type of entity represented by COMMISSION_RATE?
|
Best estimate of the aftertax cost of debt
: Shanken Corp. issued a 25-year, 8 percent semiannual bond 3 years ago. The bond currently sells for 93 percent of its face value. The company’s tax rate is 35 percent. What is your best estimate of the aftertax cost of debt?
|
|
Explanation of the types of behaviors you observed
: Write a 2-page paper that includes an explanation of the types of behaviors you observed in the two clients profiled in the media program
|
|
What are the current total carrying costs
: The Trektronics store begins each week with 460 phasers in stock. This stock is depleted each week and reordered. The carrying cost per phaser is $41 per year and the fixed order cost is $84. What are the current total carrying costs? What is the eco..
|
|
What would the total recruiting cost be for baldwin
: Baldwin's turnover rate for this year is 6.32%. This rate is projected to remain the same next year and no further downsizing will occur from automating. What would the total recruiting cost be for Baldwin, assuming it spends the same amount extra..
|
|
Difference between an entity class and an entity instance
: Explain the difference between an entity class and an entity instance, and give an example other than those used in the text or the lectures.
|
|
What is the average accounts receivable figure
: Skye Flyer, Inc., has weekly credit sales of $24,600, and the average collection period is 41 days. What is the average accounts receivable figure?
|
|
Affected by the pay-for- performance approach
: Explain how reimbursement is affected by the pay-for- performance approach. Discuss how system cost reductions impact the quality and efficiency of health care.
|
|
What is the effective cost of borrowing in this case
: Your firm has an average collection period of 36 days. Current practice is to factor all receivables immediately at a discount of 1.7 percent. What is the effective cost of borrowing in this case?
|
|
Calculate the present value of the cash flows
: Refer to the cash flows listed for the Kelly Company investment projects in the table below. The discount rate is 6 percent. Calculate the present value of these cash flows. What is the present value at:
|