Concept explainers
Explanation of Solution
Answer to interviewer question:
The job seeker tells about the course of
SQL query:
To create a table in SQL, the programmer must know about syntax for the code. The syntax for creating a table is as follows:
CREATE TABLE TABLE_NAME (
Column1 datatype,
Column2 datatype,
…
);
The following table “Employee” is created using the about syntax in SQL.
CREATE TABLE Employee (EMP_NUM CHAR(3) PRIMARY KEY, EMP_LNAME VARCHAR(15), EMP_FNAME VARCHAR(15), EMP_INITIAL CHAR(1), EMP_HIREDATE DATE, JOB_CODE CHAR(3), FOREIGN KEY (JOB_CODE) REFERENCES JOB);
Explanation:
The table named “Employee” was created using the above query as per the given data types. The data type for “EMP_NUM”, “EMP_INITIAL”, and “JOB_CODE” is given as “CHAR”. The data type for “EMP_LNAME”, “EMP_FNAME” is “VARCHAR” and the data type for “EMP_HIREDATE” is given as “DATE”.
Want to see more full solutions like this?
Chapter 12 Solutions
Essentials of MIS (13th Edition)
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningFundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningManagement Of Information SecurityComputer ScienceISBN:9781337405713Author:WHITMAN, Michael.Publisher:Cengage Learning,