Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question
```sql
-- Drop the Worker table if it exists
DROP TABLE IF EXISTS Worker;

-- Create the Worker table
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)
);

-- Insert data into the Worker table
INSERT INTO Worker 
    (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES 
    (001, 'Monika', 'Arora', 100000, '14-02-20 09:00:00', 'HR'),
    (002, 'Niharika', 'Verma', 80000, '14-06-11 09:00:00', 'Admin'),
    (003, 'Vishal', 'Singhal', 300000, '14-02-20 09:00:00', 'HR'),
    (004, 'Amitabh', 'Singh', 500000, '14-02-20 09:00:00', 'Admin'),
    (005, 'Vivek', 'Bhati', 500000, '14-06-11 09:00:00', 'Admin'),
    (006, 'Vipul', 'Diwan', 200000, '14-06-11 09:00:00', 'Account'),
    (007, 'Satish', 'Kumar', 75000, '14-01-20 09:00:00', 'Account'),
    (008, 'Geetika', 'Chauhan', 90000, '14-04-11 09:00:00', 'Admin');

-- Drop the Bonus table if it exists
DROP TABLE IF EXISTS Bonus;

-- Create the Bonus table
CREATE TABLE Bonus (
    WORKER_REF_ID INTEGER,
    BONUS_AMOUNT INTEGER(10),
    BONUS_DATE DATETIME,
    FOREIGN KEY (WORKER_REF_ID)
        REFERENCES Worker(WORKER_ID)
        ON DELETE CASCADE
);

-- Insert data into the Bonus table
INSERT INTO Bonus 
    (WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES
    (001, 5000, '16-02-20'),
    (002, 3000, '16-06-11'),
    (003
expand button
Transcribed Image Text:```sql -- Drop the Worker table if it exists DROP TABLE IF EXISTS Worker; -- Create the Worker table 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) ); -- Insert data into the Worker table INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (001, 'Monika', 'Arora', 100000, '14-02-20 09:00:00', 'HR'), (002, 'Niharika', 'Verma', 80000, '14-06-11 09:00:00', 'Admin'), (003, 'Vishal', 'Singhal', 300000, '14-02-20 09:00:00', 'HR'), (004, 'Amitabh', 'Singh', 500000, '14-02-20 09:00:00', 'Admin'), (005, 'Vivek', 'Bhati', 500000, '14-06-11 09:00:00', 'Admin'), (006, 'Vipul', 'Diwan', 200000, '14-06-11 09:00:00', 'Account'), (007, 'Satish', 'Kumar', 75000, '14-01-20 09:00:00', 'Account'), (008, 'Geetika', 'Chauhan', 90000, '14-04-11 09:00:00', 'Admin'); -- Drop the Bonus table if it exists DROP TABLE IF EXISTS Bonus; -- Create the Bonus table CREATE TABLE Bonus ( WORKER_REF_ID INTEGER, BONUS_AMOUNT INTEGER(10), BONUS_DATE DATETIME, FOREIGN KEY (WORKER_REF_ID) REFERENCES Worker(WORKER_ID) ON DELETE CASCADE ); -- Insert data into the Bonus table INSERT INTO Bonus (WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES (001, 5000, '16-02-20'), (002, 3000, '16-06-11'), (003
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
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
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education