Reference no: EM13956525
Consider the following relations for a database that keeps track of business trips of salespersons in a sales office:
SALESPERSON(SSN, Name, Start_Year, Dept_No)
TRIP(SSN, From_City, To_City, Departure_Date, Return_Date, Trip_ID)
EXPENSE(Trip_ID, Account#, Amount)
Specify the foreign keys for the above schema, stating any assumptions you make. Then specify the following queries in relational algebra:
a. Give the details (all attributes of TRIP relation) for trips that exceeded $2000 in expenses.
b. Print the SSN of salesman who took trips to ‘Honolulu'.
c. Print the total trip expenses incurred by the salesman with SSN = ‘234-56-7890'
|
Leadership and organizational behavior journal
: My professor is looking for an article on leadership from a business, management, or organizational behavior journal. should make recommendations and include conclusion. Kindly refer some articles on leadership and organizational behavior journal.
|
|
Find the probability for the given data
: Assuming that the two events are independent , the probability that cost is kept within budget and the campaign sales is:
|
|
For a reversible liquid phase reaction a-r the conversion is
: For a reversible liquid phase reaction A-^R, the conversion is 33.3% after 8 minutes and equilibrium conversion is 66.7%. Find the rate equation for the reaction.
|
|
What degree can nurses substitute for doctors
: The delivery of healthcare services is dependent on the availability of skilled professionals who can provide needed care and supporting services. List and explain two factors that determine the supply of doctors and nurses. Also, to what degree can ..
|
|
Track of business trips of salespersons
: Consider the following relations for a database that keeps track of business trips of salespersons in a sales office:
|
|
Fire safety procedures for new complex shopping malls
: Describe fire scenarios, reasonable process to keep an eye on might be precised taking into concern overall conceivable fire scenarios - Describing enterprise fire scenarios resembling the subsystems of the most possible and tiring possible scenarios
|
|
Use both positive and negative reinforcement
: If you, as a manager, had to help change an employee’s behavior to make him or her more productive, what course of action would you take? How might you use both positive and negative reinforcement?
|
|
Improve the delinquency prevention capabilities of schools
: Should disobedient youths be suspended from school? Does this solution hurt or help? What can be done to improve the delinquency prevention capabilities of schools? Is school failure responsible for delinquency, or are delinquents simply school failu..
|
|
Demand and supply affect equilibrium price
: How will each of the following changes in demand and/or supply affect equilibrium price and equilibrium quantity in a competitive market? That is, will the equilibrium price Rise, Fall, or is the change Indeterminate because this depends on the ma..
|