Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
★★★★★
3.53 Rating (146 Votes )
There are 3 Steps involved in it
Step: 1
1 creating the table CREATE TABLE WORKER WID INT NOT NULL PRIMARY KEY WFNAME VARCHAR20 NOT NULL WADD...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