Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
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