Question: Write SQL queries for the following problems. Show your query (in text) and the result of each query (screen image). (10) Add a field named
- Write SQL queries for the following problems. Show your query (in text) and the result of each query (screen image).
-
- (10) Add a field named AllocatedTime to the Tasks table. The allocation is a number representing the number of minutes that have been initially allocated for the task. Set all allocation values 60, as the company has a one hour minimum charge. Display all the data in the Tasks table.
- (10) Create a domain integrity for the Client table so that the credit limit field should be 2500, 5000, 7500, 9000, and 10000. Use ALTER TABLE tablename statement to add the constraint.
- Then, execute the following query and show the result. INSERT INTO Client VALUES ('999','Doe, Jon','135 Main','Saginaw','MI','48603',1000, 3000, '19');
- An then, execute the following query and show the result. INSERT INTO Client VALUES ('900','Doe, Jane','135 Main','Saginaw','MI','48603',1000, 9000, '19');
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
