Reference no: EM13331386
Task 1: Create 3 rows of data for each table ensuring that the referential integrity is valid.
Task 2: Add the 30 rows of data to the appropriate table in your database (using any appropriate method available).
Task 3: SELECT all columnsand all rowsof the 10 tables. Create a screenshot of each query and output data, and submit them.
Task 4: Write SELECT statements for the following (include a screenshot of the SQL and its execution, including the resulting data):
Display the employee id, first_name, last_name, and department_name for all employees.
Rows returned
Display the employee id, first_name, last_name, and job title_name for all employees.
Rows returned
Display the employee id, first_name, last_name, department_name, and job title_name for all employees.
Rows returned
|
Find the constant angular acceleration of the wheel
: A rotating wheel requires 2.99-s to rotate through 37.0 revolutions. What is the constant angular acceleration of the wheel
|
|
The thermochemical equation for the burning of ethyl alcohol
: The thermochemical equation for the burning of ethyl alcohol is C2H5OH(l) + 3O2(g) --> 2CO2(g) + 3H2O(l) ?H = -1,367 kJ What is the enthalpy change (in kJ) for burning 9.68 g of ethyl alcohol
|
|
Grapg a series of isoquants for the production function
: Grapg a series of isoquants for the production function q=10, 15,20. Plot at least 5 points for each isoquant by assuring value for q and then a value for L and solving for the remaining value of K to get the needed level of q.
|
|
Develop 48 acres land into mixed-use buildings
: Your clients have secured the financing to develop 48 acres land into mixed-use buildings. They have asked you to draft a high-level project plan to begin the more detailed discussions. Forty percent of the site is an undeveloped field, and the proje..
|
|
Create 3 rows of data for each table ensuring
: Write SELECT statements for the following (include a screenshot of the SQL and its execution, including the resulting data).
|
|
What is mbank profit when it charges
: Mbank has deposit liabilities of $100 million. It only keeps the minimum cash reserves required by law of 10%. Its annual costs (wages, rent, utilities, etc.) are $2.5 million. What is Mbank's profit when it charges 7% annual interest on its loans, a..
|
|
How many electrons flow through the hair dryer
: The current in an electric hair dryer is 12A. How many electrons flow through the hair dryer in 5.2 min
|
|
Explain why do extremely dilute charged particles
: Why do extremely dilute charged particles in an electric field move slower in an aqueous solution that contains other ions at much higher concentration in colution compare to the same particles in the same field in a non-aqueous
|
|
How much charge flows through the film
: In an integrated circuit, the current density in a 3.0??m?thick× 80 ??m?wide gold film is 7.9×105A/m2. How much charge flows through the film in 15 min
|