Question: Create the table CUST given below as per specification: Column Name / Field Data Type (Size) Constraint CID NUMBER(5) PRIMARY KEY (table level) Name VARCHAR2(25)

  1. Create the table CUST given below as per specification:

Column Name / Field

Data Type (Size)

Constraint

CID

NUMBER(5)

PRIMARY KEY (table level)

Name

VARCHAR2(25)

NOT NULL

Location

VARCHAR2(50)

Salary

NUMBER(5)

must be greater than 0

Birthday

DATE

Mobile

NUMBER(11)

  1. View the structure of your table.

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!

Q:

1. Open SQL developer and create a new connection to Oracle server 2. Write in SQL a command that creates the table Supplier according to the following description: [3 marks) Table name: Supplier...

Q:

sql Create the SUPPLIERS table using the specification below: Table Name: SUPPLIERS Field Namel Data Type Size Constraints column name SID Number 8 PRIMARY KEY SName Varchar2 NOT NULL Address...

Q:

SQl language Lab Exercises First: - Create the following tables: 1.CREATE TABLE access_control group access control_group_id number (10) primary key NOT NULL, access control groupname varchar2 (255)...

Q:

Salam Childcare Database : PROJECT OUTLINE Salam Childcare Sdn. Bhd. is a renowned education institution. Today, in order to increase its service quality, the company is transforming their operation...

Q:

Hello, I am having trouble with this hw in C. Below, Ive listed the directions, codes provided, which include the test cases along with how to carry out the test cases, thank you. A sample output...

Q:

1.Write one SQL statement to set up table MoSpo HallOfFame according to the following Relational Schema: MoSpo HallOfFame(hoFdriverId, hoFYear, hoFSeries, hoFImage, hoFWins, hoFBestRaceName,...

Q:

MIS 300- Access Assignment 1 Instructions Step One: Create a table Open Access Click Blank Database Type "Walf Company your last name) in the File name box Click the Browse button to change the file...

Q:

This policy will be reviewed no later than 5 years of its authorisation date. At this point it will need to be re-authorised by the relevant authority at Xxz Financial Services Version Published...

Q:

DDL SQL Question 10. (DDL) Solve following four questions (15 points). A. Create the vendor table based on the following specification? COLUMN NAME Data TYPE Lenth CONSTRAINT TYPE IS NULLABLE...

Q:

Using SQL Create a table called Dept_Employee with the following structure. Name Empno Type Number Null Not null key Primary Default Ename Varchar2(20) Not null Job Varchar2(20) Null Null Mgr Number...

Q:

What are the Effects Of COVID-19 on Business

Q:

A sociologist claims that children ages 617 spent more time watching television in 1981 than children ages 617 do today. A study was conducted in 1981 to find the time that children ages 617 spent...

Q:

While reviewing the last month's inventory purchase records, you noticed that one purchase of inventory for $ 5 . 0 0 0 in cash was recorded twice by mistake. This is the only mistake you have found....

Q:

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Q:

Determine the labor demand for workers in various job categories. page 186

Q:

Understand the importance of job analysis in strategic human resource management. page 161

Q:

Discuss how to align a companys strategic direction with its human resource planning. page 185