Answered step by step
Verified Expert Solution
Question
1 Approved Answer
write the SQL/DDL to create the Job and EMPLOYEE tables Note the cardinality requirements for the relationship indicates a foreign key and values are required.
write the SQL/DDL to create the Job and EMPLOYEE tables Note the cardinality requirements for the relationship indicates
a foreign key and values are required. Write the SQL commands to add the first
three records to the JOB table and the first three records to the EMPLOYEE table.
Table name: JOB JOB_CODE JOB_DESCRIPTION JOB_CHG_HOUR JOB_LAST_UPDATE 500 Programmer 35.75 20-Nov-17 501 Systems Analyst 96.75 20-Nov-17 502 Database Designer 125.00 24-Mar-18 503 Electrical Engineer 84.50 20-Nov-17 504 Mechanical Engineer 67.90 20-Nov-17 505 Civil Engineer 55.78 20-Nov-17 506 Clerical Support 26.87 20-Nov-17 507 DSS Analyst 45.95 20-Nov-17 508 Applications Designer 48.10 24-Mar-18 509 Bio Technician 34.55 20-Nov-17 510 General Support 18.36 20-Nov-17 Table name: 30 EMP_NUM EMP_LNAME EMP_FNAME EMP_INITIAL EMP_HIREDATE JOB_CODE EMP_YEARS 101 News John 08-Nov-00 502 17 102 Senior David H 12-Jul-89 501 28 103 Arbough June E 01-Dec-96 500 21 104 Ramoras Anne K 15-Nov-87 501 105 Johnson Alice 01-Feb-93 502 25 106 Smithfield William 22-Jun-04 500 13 107 Alonzo Maria D 10-Oct-93 500 24 108 Washington Ralph B 22-Aug-91 501 26 109 Smith Larry w 18-Jul-97 501 20 110 Olenko Gerald A 11-Dec-95 505 22 Wabash Geoft B 04-Apr-91 506 27 112 Smithson Darlene M 23-Oct-94 507 113 Joenbrood Delbert K 15-Nov-96 508 21 114 Jones Annelise 20-Aug-93 508 24 115 Bawangi Travis 25-Jan-92 501 26 116 Pratt Gerald L 05-Mar-97 510 21 117 Williamson Angie 19-Jun-96 509 21 118 Frommer James 04-Jan-05 510 13 111 23 CIStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started