QuestionQuestion

Transcribed TextTranscribed Text

1 Create the Relational Schemas that can be used as design model tosupport the DB. 2 Pick two(2) of the relational tables of the DB, and show the SQL commands (MySQL or SQLite) thatcan be used to create the chosen tables. 3. Show the SQL query commands (MySQL or SQLite) that car be used to generate the following data that goes into: Status Report for upper management: a. All managers who currently have no direct reports (are not managing any imployees). b. Thetotal worth of all the contracts the company currently has c. The total salaries of all employees in each department d. Theminimum and maximumsalary for each department. e Listing of all employees who reside in the same city, grouped by city. f. Employees who make at least $73000. g. The average salary of the employees, for the whole company; and by dept. h. Employees who do not have company (av.com) email address as their contac information Appendix Employee Employeeld FirstName MiddleName LastName Gender DOB 5462 Jack Tom Small M 09231992 9178 Jilla Sue Peterson F 10151975 3456 Desi K Ramjit F 03241996 8931 Lee Fu Chen M 07131989 2645 Ola Du Medo M 02031990 EmployeeContactInfo-1 Employeeld Address1 Address2 City State ZipCode 5462 12 Main St NULL Soma NY 99456 9178 156 L Blvd Apt 546 Soma NY 99457 3456 201 Elm Ave Rear Breville NY 99389 8931 11 145 S NULL Draper NY 99102 2645 N 18 Ave No. Horton NY 99931 EmployeeContactinfo- Employeeld MobilePhone WorkPhone HomePhone Email 5462 3478221890 6788905432 2126778833 jsmall@av com 9178 3479001067 6788906700 7183128469 jsue3@gmail. com 3456 9178993572 6788901233 7185316439 Opq23@hotmail.com 8931 9170135814 6788909341 3138967751 fu@hollow com 2645 6315788423 6788905843 2027889015 omedo@av .com EmployeeRenumeration Employeeld SkillCode Title Grade Salary 5462 73 Accountant 03 75000 9178 43 Consultant 01 85000 3456 02 Engineer 07 70000 8931 73 Accountant 11 72000 2645 07 Salesperson 02 96000 EmployeeLocation Employeeld Deptid DateOfHire 5462 044 01172017 9178 172 06172003 3456 090 04252009 8931 172 11062013 2645 090 08092011 DepartmentInfo-1 Deptid Name Location 044 Administration Building 10 172 R&D Building 12 Floor 12 090 Customer Service Building 10 999 Quality Assurance Building DepartmentInfo-2 Deptld Managerld Budget 2020 1184 3000000 172 2645 15000000 788 6423 25000000 3477 9090 90000000 Contractinfo Contractid DescriptionCode Deptid NetWorth 5678 Project01 172 780000 6890 Project10 999 900000 3421 Project03 999 12000000 9067 Project15 090 555000 8543 Project05 999 10000000 ManagementInfo Managerld Employeeld 9090 5462 8788 9128 6423 3456 9090 8931 1123 2645

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:
    Solution1.docx and Solution2.sql.

    50% discount

    Hours
    Minutes
    Seconds
    $125.00 $62.50
    for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Database Development Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats