Question

1. Using the column level, write the SQL statements to create the table named Customer. Column Name Data Type Size Constraint CustNo Number 5 Should not be repeated and not empty. Name Varchar2 30 Age Number 3 Age should be greater than or equal to 18 Country Varchar2 20 PhoneNo Number 10 Should not be repeated [3 marks] 2. Modify the Customer Table with the details shown below: [2 Marks] Column Name Name Data Type Varchar2 Size Constraint Age Number 20 Should not be empty 3 Remove the constraint 3. Write a query to add column to the Customer Table. Column Name Data Type DateofBirth Date [1 Mark]

          1. Using the column level, write the SQL statements to create the table named Customer.
Column Name Data Type
Size Constraint
CustNo
Number
5
Should not be repeated and not empty.
Name
Varchar2
30
Age
Number
3
Age should be greater than or equal to 18
Country
Varchar2
20
PhoneNo
Number
10 Should not be repeated
[3 marks]
2. Modify the Customer Table with the details shown below:
[2 Marks]
Column Name
Name
Data Type
Varchar2
Size Constraint
Age
Number
20 Should not be empty
3 Remove the constraint
3. Write a query to add column to the Customer Table.
Column Name
Data Type
DateofBirth
Date
[1 Mark]

Show more…

1. Using the column level, write the SQL statements to create the table named Customer.
Column Name Data Type
Size Constraint
CustNo
Number
5
Should not be repeated and not empty.
Name
Varchar2
30
Age
Number
3
Age should be greater than or equal to 18
Country
Varchar2
20
PhoneNo
Number
10 Should not be repeated
[3 marks]
2. Modify the Customer Table with the details shown below:
[2 Marks]
Column Name
Name
Data Type
Varchar2
Size Constraint
Age
Number
20 Should not be empty
3 Remove the constraint
3. Write a query to add column to the Customer Table.
Column Name
Data Type
DateofBirth
Date
[1 Mark]

Added by James S.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Anecia Mcmurrin-Bala

Step 1

SQL statement to create the Customer table: CREATE TABLE Customer ( CustNo NUMBER(5) NOT NULL UNIQUE, Name VARCHAR2(30) NOT NULL, Age NUMBER(3) CHECK (Age >= 18), Country VARCHAR2(20), PhoneNo NUMBER(10) NOT NULL UNIQUE ); Show more…

Show all steps

lock

Thanks for your feedback!

Using the column level, write the SQL statements to create the table named Customer. [3 marks] Column Name Data Type Size Constraint CustNo Number 5 Should not be repeated and not empty Name Varchar2 30 - Age Number 3 Age should be greater than or equal to 18 Country Varchar2 20 - PhoneNo Number 10 Should not be repeated 2. Modify the Customer Table with the details shown below: [2 marks] Column Name Data Type Size Constraint Name Varchar2 20 Should not be empty Age Number 3 - 3. Write a query to add column to the Customer Table. [1 mark] Column Name Data Type DateofBirth Date Title_with_topic: SQL Statements for Creating and Modifying the Customer Table

Play audio

Feedback

Powered by NumerAI

Anecia Mcmurrin-Bala and 54 other subject AP CS educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Recommended Videos

Recommended Textbooks

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later