Act 1 Ques 3

PHOTO

Tue Oct 08 2024 12:43:35 GMT+0000 (Coordinated Universal Time)

Saved by @JC

CREATE DATABASE act;

CREATE TABLE Department (
    Code int not null,
    Name varchar(20) not null,
    Budget int not null,
    PRIMARY KEY (Code)
);

describe Department;

begin
INSERT INTO Department VALUES (14, 'IT', 65000);
INSERT INTO Department VALUES (37, 'Accounting', 15000);
INSERT INTO Department VALUES (59, 'Human Resources', 240000);
INSERT INTO Department VALUES (77, 'Research', 55000);
end;

SELECT * FROM Department;

COPY