Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

image text in transcribed

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 CI

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Conceptual Database Design An Entity Relationship Approach

Authors: Carol Batini, Stefano Ceri, Shamkant B. Navathe

1st Edition

0805302441, 978-0805302448

More Books

Students also viewed these Databases questions