Fill in the blanks with the datatypes given below:
INT, VARCHAR,DATE,
CREATE TABLE Office
(
Employee_ID_______,
Employee_Name_______,
Employee_Date_of_Joining______, Employee_Phone_number_______,
)
Answers
Employee_ID: INT
Employee_Name: VARCHAR
Employee_Date_of_Joining: DATE
Employee_Phone_number: INT
Query:
CREATE TABLE Office (
Employee_ID INT,
Employee_Name VARCHAR,
Employee_Date_of_Joining DATE,
Employee_Phone_number INT,
) ;
Definitions:
» INT (Integer): Used to store medium four byte numerical data including unique identification numbers and phòne numbers.
» VARCHAR (Variable Characters): Used to store strings of data with variable characters including alphabets, numbers and special characters. Used in entering names, memos etc.
» DATE: Used to enter dates in the format YYYY-MM-DD.
SQL:
SQL (Structured Query Language) is a programming language used for creating and maintaining relational databases. It is one of the well known as well as standard languages used in RDBMS.