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

  1. Write SQL queries for the following problems. Show your query (in text) and the result of each query (screen image).
    1. (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.
    2. (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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!