Midterm it 540 database

Anonymous
timer Asked: Oct 16th, 2018
account_balance_wallet $40

Question Description

  1. Create a new Schema in your database called - "MIDTERM_LastName" (use your own last name)
  2. Double-click on your new schema, it should now be BOLD

  3. Download the script here and open in MySQL Workbench, execute script. This should install a small database.
  4. Explore the data in the script by right-clicking on each table and viewing top 1000 items.
  5. Answer the following five questions using SQL statements. Copy each completed statement into an answer sheet. Feel free to use this answer sheet from the assignment 1.
    1. What Employees have a last name that begins with the letter 'T' and what is their Title?
    2. What is the Maximum, minimum, and average value of the Available Balances in the accounts?
    3. What is the oldest and newest accounts for this bank?
    4. How many employees work for each Department?
    5. Which employees are supervisors? (look in employee table, all data is in this table)
  6. Write an SQL Script to add a new table to this Schema for business addresses with a one to many relationship with the business table. You do not need to enter data into this table. Copy script to answer sheet.
  7. This business wants to change the title "Tellers" to "Bank Service Reps". Write an SQL Script to update this table. Copy Script to Answer Sheet
  8. Submit answer sheet with SQL statements.
  9. Make a screen shot of your database folder structure and send it to me.

PreviousNext

Tutor Answer

mickeygabz
School: Boston College

Hey. See attached for final answer. The screenshot you can replace from your side in case of any previous databases

Question 1
*/
SELECT TITLE, LAST_NAME
FRO...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors