Create the following tables and show the insertion of the data Use the five tables of IT Associates shown below to answer questions 1 to 10 COMPUTER Primary Key COMPID COMPID MFGNAME MF MODEL PROCTYPE B121 Bantam 48X 486DX B221 Bantam 48D 486DX2 C007 Cody D1 486DX M759 Lemmin GRL 486SX EMPLOYEE Primary Key EMPNUM EMPNUM EMPNAME EMPPHONE 124 Alvarez, Ramon 1212 567 Feinstein, Betty 8716 611 Dinh, Melissa 2693 PC Primary Key TAGNUM TAGNUM COMPID EMPNUM LOCATION 32808 M759 611 Accounting 37691 B121 124 Sales 57772 C007 567 Info Systems 59836 B221 124 Home 77740 M759 567 Home PACKAGE Primary Key PACKID PACKID PACKNAME PACKVER PACKTYPE PACKCOST AC01 Boise Accounting 3 00 Accounting 725 83 DB32 Manta 1 50 Database 380 00 DB33 Manta 2 10 Database 430 18 SS11 Limitless View 5 30 Spreadsheet 217 95 WP08 Words More 2 00 Word Processing 185 00 WP09 Freeware Processing 4 27 Word Processing 30 00 SOFTWARE Primary Key PACKID TAGNUM PACKID TAGNUM INSTDATE SOFTCOST AC01 32808 09 13 95 754 95 DB32 32808 12 03 95 380 00 DB32 37691 06 15 95 380 00 DB33 57772 05 27 95 412 77 WP08 32808 01 12 96 185 00 WP08 37691 06 15 95 227 00 WP08 57772 05 27 95 170 24 WP09 59386 10 30 95 35 00 WP09 77740 05 27 95 35 00 Give the appropriate SQL for questions 1 to 10 Show the results (2 5 Pts each) List all information from the EMPLOYEE relation concerning employee 611 List the ID and manufacturer name of all computers List the tag numbers, location, computer ID, manufacturer name, and processor type for all PCs List the tag number, location, computer ID, manufacturer name, and processor type for all PCs with a 486DX processor List the package ID and name of all packages that are of type Database or are installed on the PC with tag number 32808 List the package ID and name of all packages that are of type Database and are installed on the PC with tag number 32808 List the package ID and name of all packages that are of type Database but are not installed on the PC with tag number 32808 List the complete Employee table List the tag number and computer ID for all computers assigned to employee 124 and located at Home List the tag number and computer ID for all computers assigned to employee 124 or are located at Home

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 01, 2024

Create the following tables and show the insertion of the data. Use the five tables of IT Associates shown below to answer questions 1 to 10:

COMPUTER

Primary Key: COMPID

EMPLOYEE

Primary Key: EMPNUM

Primary Key: TAGNUM

PACKAGE

Primary Key: PACKID

SOFTWARE

Primary Key: PACKID + TAGNUM

Give the appropriate SQL for questions 1 to 10. Show the results (2.5 Pts. each).

List all information from the EMPLOYEE relation concerning employee 611.
List the ID and manufacturer name of all computers.
List the tag numbers, location, computer ID, manufacturer name, and processor type for all PCs.
List the tag number, location, computer ID, manufacturer name, and processor type for all PCs with a 486DX processor.
List the package ID and name of all packages that are of type Database or are installed on the PC with tag number 32808.
List the package ID and name of all packages that are of type Database and are installed on the PC with tag number 32808.
List the package ID and name of all packages that are of type Database but are not installed on the PC with tag number 32808.
List the complete Employee table.
List the tag number and computer ID for all computers assigned to employee 124 and located at Home.
List the tag number and computer ID for all computers assigned to employee 124 or are located at Home.