Answered step by step
Verified Expert Solution
Link Copied!

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

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using Microsoft Excel and Access 2016 for Accounting

Authors: Glenn Owen

5th edition

1337109048, 1337109045, 1337342149, 9781337342148 , 978-1337109048

More Books

Students also viewed these Databases questions

Question

What is involved in sales management? AppendixLO1

Answered: 1 week ago

Question

Identify the five variables in present value problems.

Answered: 1 week ago

Question

Why are list box controls used on a form?

Answered: 1 week ago