Question: 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

SQL help please 1. Give the above ERD, write SQL commands to

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Chapter 7 Assignment Turn in the Ssat to answer the following questions (I do not need the Name: tables, bust the soL) 1. Write SQL to correctly create the OCEAN table as specified below. 2. Write...

*Lab 6 is there in case you don't know what "Lab 7" instructions are referring to when they say" Lab 6." Lab 7 is the one that needs to be done. Lab 7: Inserting and Updating Data OVERVIEW This lab...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

Write Create Table commands to create the three tables above in your database and create a primary key for each table. Add any foreign keys as appropriate. Include in your answer the table creation...

Please answer correctly and label them please. 1. Consider the following ERD and answer the questions that follow: EMPLOYEES EMP EMP LNAME VARCHAR 20 EMP FNAME VARCHAR O0 SALARY DEPT BUDGET MANAGERD...

Part 2: DDL Instructions: Using the guidance and instructions given in the module download and install the appropriate version of PostgreSQL for your system. Familiarize yourself with the pgAdmin web...

PLZ HELP WITH THE FOLLWONG: SQL FILE CREATE TABLE GALLERY ( GAL_NUM char(4), GAL_OWNER varchar(35), GAL_AREACODE char(3), GAL_PHONE char(8), GAL_RATE number ); INSERT INTO GALLERY VALUES('5','L. R....

CIS-336: Lab7: Working with Views LAB OVERVIEW Lab 7 will introduce the concept of database views. This lab may be completed using either DeVrys Omnymbus EDUPE-APP lab environment, or a local copy of...

PLEASE ONLY NEED THE SQL AND THE TABLES FOR THIS WOULD TRULY APPRECIATE UNDERSTANDING THIS! MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and...

This practice lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. (In Microsoft SQL studio) In...

How is product cost information used by managers? Discuss in detail.

If the sales mix results in a lower contribution margin percentage, the break even point a. increases b. decreases c. unchanged d. there is no relationship between contribution margin and sales mix...

Gallo Inc. will start selling 2 0 - year bonds today. The bonds have semiannual coupon payments, an annual coupon rate of 1 2 % , and a par value of $ 1 , 0 0 0 . The yield to maturity ( YTM ) for...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

2. Review Annas speech on social media movements in this chapter. Into what category does the topic of this speech fall? Which approach or approaches (description, demonstration, definition, or...

5. Think of a topic that you find excruciatingly dull (for example, balancing your checkbook, studying for a required course you dont like, or taking a summer or part-time job doing something utterly...

6. Imagine a process you do every day, such as driving a car. Think about how you would explain the process to someone whos never done it or even seen it done before. Consider different ways you...