Answered step by step
Verified Expert Solution
Link Copied!

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

  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

Step: 1

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

Data Mining Concepts And Techniques

Authors: Jiawei Han, Micheline Kamber, Jian Pei

3rd Edition

0123814790, 9780123814791

More Books

Students also viewed these Databases questions

Question

What is Aufbau's rule explain with example?

Answered: 1 week ago

Question

2. How will the team select a leader?

Answered: 1 week ago