Reference no: EM1345422
Q1) CAR (Serial-No, ModConsider the given relations for database which keeps track of auto sales in car dealership (Option refers to some optional equipment installed on an auto):
el, Manufacturer, Price),
i) OPTIONS (Serial-No, Option-Name, Price),
ii) SALES (Salesperson-id, Serial-No, Date, Sale-price)),
ii) 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.
|
Find the stock price according to mm proposition1
: Consider two company, With and Without, that have identical assets that generate identical cash flows. Without is an all-equity firm with one million shares outstanding that trade for a price of dollar 24 per share.
|
|
Explaining software measurement related to software metrics
: Is software measurement equivalent to software metrics? What makes them different?
|
|
How information affect your calculation of inflation rate
: If you were to learn about a bottle of gatorade increased in size from 2009 to 2010, should that information affect your calculation of the inflation rate. If so, how.
|
|
Find the velocity at the end of this time interval
: A 0.75m diameter solid sphere may be rotated about an axis through its center by a torque of 11.5m*N which accelerates it uniformly from rest through a total of 180 revolutions in 16.0 s.What is the mass of the sphere.
|
|
Database to keep track of auto sales in car dealership
: CAR (Serial-No, ModConsider the given relations for database which keeps track of auto sales in car dealership.
|
|
Find net unrealized loss
: Sun Corporation had investments in marketable equity securities costing 650,000 on June 30, year 2. Sun Corporation decided to hold the investments indefinitely and accordingly reclassified.
|
|
Find kinetic friction between wooden blocks and tabletop
: Jessica's weight is 540 newtons. According to the Third Law, if the Earth pulls on Jessica with a force of 540 N, then Jessica pulls on the Earth with a force of 540 newtons that acts in the opposite direction.though , if Jessica stumbles while rol..
|
|
Use the component method to find the magnitude of r
: A particle with a charge of q = -5.40 nC is moving in a uniform magnetic field of vec{B}=( -1.24 T ) hat{z}. The magnetic force on the particle is measured to be vec{F}= ( -7.60×10-7 N )hat{y}. find v_x, the x component of the speed of the particl..
|
|
Interest rates and future strength or weakness of us dollar
: Suppose that foreign interest rates are expected to rise above US interest rates. What does this suggest regarding the future strength or weakness of the US dollar?
|