n the query below, what is the difference between INTEGER ad INTEGER(15)? Why is it used? CREATE TABLE Worker ( WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FIRST_NAME TEXT, LAST_NAME TEXT, SALARY INTEGER(15), JOINING_DATE DATETIME, DEPARTMENT CHAR(25) ); View keyboard shortcuts
n the query below, what is the difference between INTEGER ad INTEGER(15)? Why is it used? CREATE TABLE Worker ( WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FIRST_NAME TEXT, LAST_NAME TEXT, SALARY INTEGER(15), JOINING_DATE DATETIME, DEPARTMENT CHAR(25) ); View keyboard shortcuts
Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter11: Sql Server Databases
Section: Chapter Questions
Problem 6E
Related questions
Question
In the query below, what is the difference between INTEGER ad INTEGER(15)? Why is it used?
CREATE TABLE Worker (
WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
FIRST_NAME TEXT,
LAST_NAME TEXT,
SALARY INTEGER(15),
JOINING_DATE DATETIME,
DEPARTMENT CHAR(25)
);
View keyboard shortcuts
![DROP TABLE IF EXISTS Worker;
CREATE TABLE Worker (
);
0
INSERT
);
WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
FIRST NAME TEXT,
LAST NAME TEXT,
SALARY INTEGER (15),
JOINING DATE DATETIME,
DEPARTMENT CHAR (25)
INTO Worker
(WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES
'Arora', 100000, '14-02-20 09.00.00', 'HR'),
(001, 'Monika',
(002, 'Niharika',
'Verma' 80000, '14-06-11 09.00.00', 'Admin'),
'HR'),
'Admin'),
Admin'),
'Account'),
'Kumar', 75000, '14-01-20 09.00.00', 'Account')
DROP TABLE IF EXISTS Bonus;
CREATE TABLE Bonus (
);
(003, 'Vishal' 'Singhal', 300000, '14-02-20 09.00.00',
(004, 'Amitabh
'Singh', 500000, '14-02-20 09.00.00',
(005, 'Vivek' 'Bhati', 500000, '14-06-11 09.00.00'.
(006, 'Vipul', 'Diwan' 200000, '14-06-11 09.00.00',
(007, 'Satish'
(008, 'Geetika', 'Chauhan', 90000, '14-04-11 09.00.00', 'Admin');
WORKER_REF_ID INTEGER,
BONUS AMOUNT INTEGER(10),
BONUS_DATE DATETIME,
FOREIGN KEY (WORKER_REF_ID)
REFERENCES Worker (WORKER_ID)
ON DELETE CASCADE
INSERT INTO Bonus
(WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES
(001, 5000, '16-02-20'),
(002, 3000,
'16-06-11'),
(003, 4000, '16-02-20'),
(001, 4500, '16-02-20'),
(002, 3500, '16-06-11');
CREATE TABLE Title (
WORKER_REF_ID INTEGER,
WORKER_TITLE VARCHAR(64),
AFFECTED FROM DATETIME,
FOREIGN KEY (WORKER_REF_ID)
REFERENCES Worker (WORKER_ID)
ON DELETE CASCADE
INSERT INTO Title
(WORKER_REF_ID, WORKER_TITLE, AFFECTED_FROM) VALUES
(001, 'Manager', '2016-02-20 00:00:00'),
(002, 'Executive', '2016-06-11 00:00:00'),
(008, 'Executive' '2016-06-11 00:00:00'),
(005, 'Manager', '2016-06-11 00:00:00'),
(004,
'Asst. Manager', '2016-06-11 00:00:00'),
(007, 'Executive', '2016-06-11 00:00:00'),
(006,
'Lead', '2016-06-11 00:00:00'),
(003, 'Lead', '2016-06-11 00:00:00');
I](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F9ec53c5c-d1c4-42dd-957e-ce8596851c7e%2Fd61ad715-bcf5-4021-a91b-01850d879750%2Fly2ucj_processed.jpeg&w=3840&q=75)
Transcribed Image Text:DROP TABLE IF EXISTS Worker;
CREATE TABLE Worker (
);
0
INSERT
);
WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
FIRST NAME TEXT,
LAST NAME TEXT,
SALARY INTEGER (15),
JOINING DATE DATETIME,
DEPARTMENT CHAR (25)
INTO Worker
(WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES
'Arora', 100000, '14-02-20 09.00.00', 'HR'),
(001, 'Monika',
(002, 'Niharika',
'Verma' 80000, '14-06-11 09.00.00', 'Admin'),
'HR'),
'Admin'),
Admin'),
'Account'),
'Kumar', 75000, '14-01-20 09.00.00', 'Account')
DROP TABLE IF EXISTS Bonus;
CREATE TABLE Bonus (
);
(003, 'Vishal' 'Singhal', 300000, '14-02-20 09.00.00',
(004, 'Amitabh
'Singh', 500000, '14-02-20 09.00.00',
(005, 'Vivek' 'Bhati', 500000, '14-06-11 09.00.00'.
(006, 'Vipul', 'Diwan' 200000, '14-06-11 09.00.00',
(007, 'Satish'
(008, 'Geetika', 'Chauhan', 90000, '14-04-11 09.00.00', 'Admin');
WORKER_REF_ID INTEGER,
BONUS AMOUNT INTEGER(10),
BONUS_DATE DATETIME,
FOREIGN KEY (WORKER_REF_ID)
REFERENCES Worker (WORKER_ID)
ON DELETE CASCADE
INSERT INTO Bonus
(WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES
(001, 5000, '16-02-20'),
(002, 3000,
'16-06-11'),
(003, 4000, '16-02-20'),
(001, 4500, '16-02-20'),
(002, 3500, '16-06-11');
CREATE TABLE Title (
WORKER_REF_ID INTEGER,
WORKER_TITLE VARCHAR(64),
AFFECTED FROM DATETIME,
FOREIGN KEY (WORKER_REF_ID)
REFERENCES Worker (WORKER_ID)
ON DELETE CASCADE
INSERT INTO Title
(WORKER_REF_ID, WORKER_TITLE, AFFECTED_FROM) VALUES
(001, 'Manager', '2016-02-20 00:00:00'),
(002, 'Executive', '2016-06-11 00:00:00'),
(008, 'Executive' '2016-06-11 00:00:00'),
(005, 'Manager', '2016-06-11 00:00:00'),
(004,
'Asst. Manager', '2016-06-11 00:00:00'),
(007, 'Executive', '2016-06-11 00:00:00'),
(006,
'Lead', '2016-06-11 00:00:00'),
(003, 'Lead', '2016-06-11 00:00:00');
I
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr