Reference no: EM1352826
Q1) Consider the following relations for a database that keeps track of auto sales in a car dealership (Option refers to some optional equipment installed on an auto):
CAR (Serial-No, Model, Manufacturer, Price),
OPTIONS (Serial-No, Option-Name, Price),
SALES (Salesperson-id, Serial-No, Date, Sale-price)),
SALESPERSON (Salesperson-id, Name, Phone).
First, specify the foreign keys for this schema, stating any assumptions you make. Next, populate the relations with a few example tuples, and then give an example of an insertion in the SALES and SALESPERSON relations that violates the referential integrity constraints and of another insertion that does not.
|
Determination of apr and apy
: A bank loan contract calls for an interest rate equal to prime rate plus 1%. If prime rate averages 9% and non-interest-earning compensating balances equal to 10 percent.
|
|
Cultures allow ego centric reasoning
: Do the values of all cultures allow ego centric reasoning ("what is good for me") or allow one to be more concerned about the good of the community above the good of the individual?
|
|
Calculate the yearly expenses and gross sales
: Deer Valley Lodge, a ski resort in Wasatch Mountains of Utah, has plans to eventually add 5 new chairlifts. Assume that one lift costs $2 million, and preparing the slope and installing the lift costs another $1.3 million.
|
|
Analyzing the personality development
: Analyze the personality development of one of the theorists studied in this course from three different theoretical perspectives.
|
|
Specify the foreign keys for schema
: First, specify the foreign keys for this schema, stating any assumptions you make. Next, populate the relations with a few example tuples.
|
|
Emotion and its therapy
: Emotion is very effective at obstructing logic. Oftentimes, hearing one's own dysfunctional thoughts and behaviors repeated back to you by an unbiased, trusted practitioner can begin the process of chipping away at automatic defense mechanisms.
|
|
Organizations performance comparison
: Pick a well-known company that you feel is performing very highly and one that is not. Provide ten reasons why the two companies' performances are so dissimilar.
|
|
How much is it lengthened from its untensioned length
: A 220 g block on a 50 cm long string swings in a circle on a horizontal, frictionless table at 95.0 rpm. what is the tension on the string.
|
|
Yield to maturity on a comparable u.s. treasury issue
: Assume the following bond quotes for IOU Company appear in the financial page of today's newspaper. Suppose the bond has a face value of $1,000 and current date is April 15, 2007.
|