Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQL help please 1. Give the above ERD, write SQL commands to create the two tables: - EMPLOYEES - JOBS 2. Implement the referential integrity
SQL help please
1. Give the above ERD, write SQL commands to create the two tables:
- EMPLOYEES
- JOBS
2. Implement the referential integrity (foreign key constraint)
3. Using SQL commands, insert 5 rows (make up the data yourself) into each of the two tables above.
4. Using SQL commands, write a query to join the 2 tables EMPLOYEES and JOBS and display only the following columns. Display only those employees whose salary is greater than or equal to 1000.
EMPLOYEE_ID
FIRST_NAME
LAST_NAME
SALARY
JOB_TITLE
Step 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