Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
DATABASE Given the structure and contents of the StartAPPCo database , answer the following questions. 1. Given the information above, create the StartAPPCo database.  2. Write SQL code to insert data into all the tables created.

DATABASE Given the structure and contents of the StartAPPCo database , answer the following questions. 1. Given the information above, create the StartAPPCo database.  2. Write SQL code to insert data into all the tables created.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

DATABASE

Given the structure and contents of the StartAPPCo database , answer the following questions.

1. Given the information above, create the StartAPPCo database. 

2. Write SQL code to insert data into all the tables created. 

PROJECT PROJ_NL - PROJ_NAME ► PROJ_VALUE • PROJ_BALANC , EMP_NU , 1002350.00 103 + 15 + 18 + 22 + 25 Evergreen 1453500.00 Amber Wave 3500500.00 2110346.00 108 Rolling Tide Starfight 805000.00 2650500.00 500345.20 102 2309880.00 107 JOB JOB_COI - JOB_DESCRIPTION - JOB_CHG_HOL + JOB_LAST_UPDA - + 500 20-Nov-13 Programmer Systems Analyst Database Designer Electrical Engineer Mechanical Engineer Civil Engineer Clerical Support DSS Analyst Applications Designer Bio Technician General Support 35.75 + 501 96.75 20-Nov-13 + 502 125.00 24-Mar-14 503 84.50 20-Nov-13 + 504 + 505 67.90 20-Nov-13 55.78 20-Nov-13 + 506 26.87 20-Nov-13 + 507 45.95 20-Nov-13 + 508 48.10 24-Mar-14 509 34.55 20-Nov-13 + 510 18.36 20-Nov-13
Transcribed Image Text:PROJECT PROJ_NL - PROJ_NAME ► PROJ_VALUE • PROJ_BALANC , EMP_NU , 1002350.00 103 + 15 + 18 + 22 + 25 Evergreen 1453500.00 Amber Wave 3500500.00 2110346.00 108 Rolling Tide Starfight 805000.00 2650500.00 500345.20 102 2309880.00 107 JOB JOB_COI - JOB_DESCRIPTION - JOB_CHG_HOL + JOB_LAST_UPDA - + 500 20-Nov-13 Programmer Systems Analyst Database Designer Electrical Engineer Mechanical Engineer Civil Engineer Clerical Support DSS Analyst Applications Designer Bio Technician General Support 35.75 + 501 96.75 20-Nov-13 + 502 125.00 24-Mar-14 503 84.50 20-Nov-13 + 504 + 505 67.90 20-Nov-13 55.78 20-Nov-13 + 506 26.87 20-Nov-13 + 507 45.95 20-Nov-13 + 508 48.10 24-Mar-14 509 34.55 20-Nov-13 + 510 18.36 20-Nov-13
ASSIGNMENT ASSIGN_NUM - ASSIGN_DATE - PROJ_NUM EMP NUM • ASSIGN_JOB . ASSIGN_CHG_HR ASSIGN_HOURS ASSIGN_CHARGE. 1001 1002 22-Mar-14 18 22-Mar-14 22 103 117 117 503 509 509 84.50 34.55 34.55 3.5 4.2 20 295 75 145.11 69. 10 1003 22-Mar-14 18 1004 1005 22-Mar-14 18 103 100 503 501 84.50 96.75 5.9 22 498.55 212 85 406 35 192.85 76.05 22-Mar-14 25 1006 1007 22-Mar-14 22 22-Mar-14 25 104 113 103 501 508 503 96.75 50.75 42 38 09 1008 22-Mar-14 18 84.50 1009 1010 23-Mar-14 15 23-Mar-14 15 115 117 501 509 96.75 34.55 105.00 5.6 24 541.80 02.92 1011 1012 1013 23-Mar-14 25 23-Mar-14 18 105 108 115 502 501 501 4.3 3.4 20 451 50 328.95 96.75 23-Mar-14 25 96 75 193.50 1014 1015 23-Mar-14 22 23-Mar-14 15 104 103 501 503 96.75 84.50 28 6.1 270.90 515.45 493.50 131 29 1016 1017 1018 23-Mar-14 22 23-Mar-14 18 105 117 502 509 105.00 34.55 4.7 3.8 23-Mar-14 25 117 509 34 55 22 76.01 1019 1020 1021 24-Mar-14 25 24-Mar-14 15 104 101 501 502 110.50 125.00 110.50 4.9 3.1 541.45 307.50 24-Mar-14 22 24-Mar-14 22 108 115 501 501 27 4.9 298.35 541.45 1022 110.50 1023 24-Mar-14 22 24-Mar-14 15 24-Mar-14 18 105 502 503 509 125.00 35 437 50 1024 1025 103 117 84.50 34.55 3.3 4.2 278.85 145.11 Record: 14 1 of 25 No Fiter Search EMPLOYEE EMP_NU - EMP_LNAM - EMP_FNAM - EMP_INITIA - EMP HIREDAT - JOB_COI - EMP_YEAI E 101 王102 News John G 08-Nov-00 502 Senior David 12-Ju-89 501 17 E 103 - 104 Arbough Ramoras June 01-Dec-96 503 15-Nov-87 501 10 Anne 19 田105 Johnson Alice 01-Feb-93 502 14 田106 Smithfield William Maria 22-Jun-04 500 10-Oc-93 500 2 + 107 王 100 E 109 Alonzo 13 Washington Raph Larry Gerald B 22-Aug-91 501 15 Smith 18-Ju-97 501 9 110 Olenko 11 Dec 95 505 11 田111 Wabash Smithson Geoff B 04-Apr-91 500 15 田112 Darlene M 23-Oct-94 507 12 15 Nov 96 508 20-Aug-93 508 田113 Joenbrood Delbert K 10 + 114 Jones Annelise 13 + 115 Bawangi Pratt Williamson Travis B 25-Jan-92 501 15 + 116 E 117 Gerald 05-Mar-97 510 10 Angie H 19-Jun-96 509 10 田118 Frommer James J 04-Jan-05 510 2 EEKK
Transcribed Image Text:ASSIGNMENT ASSIGN_NUM - ASSIGN_DATE - PROJ_NUM EMP NUM • ASSIGN_JOB . ASSIGN_CHG_HR ASSIGN_HOURS ASSIGN_CHARGE. 1001 1002 22-Mar-14 18 22-Mar-14 22 103 117 117 503 509 509 84.50 34.55 34.55 3.5 4.2 20 295 75 145.11 69. 10 1003 22-Mar-14 18 1004 1005 22-Mar-14 18 103 100 503 501 84.50 96.75 5.9 22 498.55 212 85 406 35 192.85 76.05 22-Mar-14 25 1006 1007 22-Mar-14 22 22-Mar-14 25 104 113 103 501 508 503 96.75 50.75 42 38 09 1008 22-Mar-14 18 84.50 1009 1010 23-Mar-14 15 23-Mar-14 15 115 117 501 509 96.75 34.55 105.00 5.6 24 541.80 02.92 1011 1012 1013 23-Mar-14 25 23-Mar-14 18 105 108 115 502 501 501 4.3 3.4 20 451 50 328.95 96.75 23-Mar-14 25 96 75 193.50 1014 1015 23-Mar-14 22 23-Mar-14 15 104 103 501 503 96.75 84.50 28 6.1 270.90 515.45 493.50 131 29 1016 1017 1018 23-Mar-14 22 23-Mar-14 18 105 117 502 509 105.00 34.55 4.7 3.8 23-Mar-14 25 117 509 34 55 22 76.01 1019 1020 1021 24-Mar-14 25 24-Mar-14 15 104 101 501 502 110.50 125.00 110.50 4.9 3.1 541.45 307.50 24-Mar-14 22 24-Mar-14 22 108 115 501 501 27 4.9 298.35 541.45 1022 110.50 1023 24-Mar-14 22 24-Mar-14 15 24-Mar-14 18 105 502 503 509 125.00 35 437 50 1024 1025 103 117 84.50 34.55 3.3 4.2 278.85 145.11 Record: 14 1 of 25 No Fiter Search EMPLOYEE EMP_NU - EMP_LNAM - EMP_FNAM - EMP_INITIA - EMP HIREDAT - JOB_COI - EMP_YEAI E 101 王102 News John G 08-Nov-00 502 Senior David 12-Ju-89 501 17 E 103 - 104 Arbough Ramoras June 01-Dec-96 503 15-Nov-87 501 10 Anne 19 田105 Johnson Alice 01-Feb-93 502 14 田106 Smithfield William Maria 22-Jun-04 500 10-Oc-93 500 2 + 107 王 100 E 109 Alonzo 13 Washington Raph Larry Gerald B 22-Aug-91 501 15 Smith 18-Ju-97 501 9 110 Olenko 11 Dec 95 505 11 田111 Wabash Smithson Geoff B 04-Apr-91 500 15 田112 Darlene M 23-Oct-94 507 12 15 Nov 96 508 20-Aug-93 508 田113 Joenbrood Delbert K 10 + 114 Jones Annelise 13 + 115 Bawangi Pratt Williamson Travis B 25-Jan-92 501 15 + 116 E 117 Gerald 05-Mar-97 510 10 Angie H 19-Jun-96 509 10 田118 Frommer James J 04-Jan-05 510 2 EEKK
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Single Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS