Consider the following description of the WORKER table Null Field W_ID NO NO YES NO NO...

Transcribed Image Text:

Consider the following description of the WORKER table Null Field W_ID NO NO YES NO NO W_FNAME W_ADDRESS W_HOURS W_RATE Use Structured Query Language (SQL) to compose the following queries: 1. Create the table WORKER, specifying the same data types, constraints as indicated in the above description. Choose the attribute W_ID as the primary key of the table. ANSWER: W_ID 1 2 3 4 Type integer varchar (20) char (25) integer decimal (18, 2) 2. Assume the WORKER table is created and filled with the following records: W_SDDRESS W_HOURS SHARJAH DUBAI ABU DHABI AJMAN W_FNAME Ahmed Abdullah Mohammed Fadi Key PRIMARY Key 12 30 22 15 24 W_RATE 200.00 150.00 650.00 850.00 Write an SQL query to add a new record to the table with the following data: W_HOURS W_ID 5 W_FNAME Tariq W_SDDRESS SHARJAH W_RATE 250.00 Consider the following description of the WORKER table Null Field W_ID NO NO YES NO NO W_FNAME W_ADDRESS W_HOURS W_RATE Use Structured Query Language (SQL) to compose the following queries: 1. Create the table WORKER, specifying the same data types, constraints as indicated in the above description. Choose the attribute W_ID as the primary key of the table. ANSWER: W_ID 1 2 3 4 Type integer varchar (20) char (25) integer decimal (18, 2) 2. Assume the WORKER table is created and filled with the following records: W_SDDRESS W_HOURS SHARJAH DUBAI ABU DHABI AJMAN W_FNAME Ahmed Abdullah Mohammed Fadi Key PRIMARY Key 12 30 22 15 24 W_RATE 200.00 150.00 650.00 850.00 Write an SQL query to add a new record to the table with the following data: W_HOURS W_ID 5 W_FNAME Tariq W_SDDRESS SHARJAH W_RATE 250.00