Name:-
Div:-FY-IT.B
DATE:-10/10/2022
Subject:-DBMS
Aim:- DBMS_1


     PRACTIAL ASSIGNMENT-1




Q-1. Display ALL records FROM course TABLE.

CREATE TABLE stud_COURSE
(
 course_no VARCHAR2(7),
 title VARCHAR2(20),
 instructor VARCHAR2(20),
 credits NUMBER(2)
);
0.06 seconds

INSERT INTO STUD_COURSE
VALUES ('AC202','Accounting','Guffsaton',3);

INSERT INTO stud_course
VALUES ('FL101','Basic English','McCoy',3);

INSERT INTO stud_course
VALUES ('CIS36','Database','choi',2);

INSERT INTO stud_course
VALUES ('FL105','speech','Frank',2);

INSERT INTO stud_course
VALUES ('FL503','Compsition','Mauffler',3);

INSERT INTO stud_course
VALUES ('MA102','Basic Math','Murray',3);

INSERT INTO stud_course
VALUES ('MA130','Statistics','Counter',3);

INSERT INTO stud_course
VALUES ('NM204','Journalism','Hemandon',2);

INSERT INTO stud_course
VALUES ('PH121','Basic circuit','Shockly',3);

INSERT INTO stud_course
VALUES ('PH150','Tennis','Lizzer',1);

INSERT INTO stud_course
VALUES ('PH123','Resistor T’,Charlse’,);



Q-2. Display all records from Enrollment table.

CREATE TABLE STUD_ENROLLMENT
(
 student_id number(10),
 course_no varchar2(10),
 grade varchar2(1)
);

insert into STUD_ENROLLMENT
values (777949993,'AC202','C');

insert into STUD_ENROLLMENT
values (777949993,'CS303','A');

insert into STUD_ENROLLMENT
values (777949993,'FL105','D');

insert into STUD_ENROLLMENT
values (777949993,'MA130','A');

insert into STUD_ENROLLMENT
values (777949993,'NM204','B');

insert into STUD_ENROLLMENT
values (777949993,'PH150','A');

insert into STUD_ENROLLMENT
values (777949993,'PY123','B');

insert into STUD_ENROLLMENT
values (800005555,'CIS326','C');

insert into STUD_ENROLLMENT
values (999001111,'CIS326','A');

insert into STUD_ENROLLMENT
values (234556677,'CIS326','D');

insert into STUD_ENROLLMENT
values (999110000,'CIS326','A');

insert into STUD_ENROLLMENT
values (999119800,'CIS326','B');

insert into STUD_ENROLLMENT
values (000348282,'CIS326','C');

insert into STUD_ENROLLMENT
values (666110001,'CIS326','C');

insert into STUD_ENROLLMENT
values (555119800,'CIS326','D');
insert into STUD_ENROLLMENT
values (444339837,'CIS326','A');

insert into STUD_ENROLLMENT
values (333448887,'CIS326','B');

insert into STUD_ENROLLMENT
values (222551288,'CIS326','B');

insert into STUD_ENROLLMENT
values (222551288,'NM204','B');


Q-3. Display all records from student table.

CREATE TABLE STUDENT_ID
(
 stud_id number(10),
 first_name varchar2(10),
 last_name varchar2(10),
 major varchar2(10),
 status number(1),
 gender number(1),
 DOB date
);

0.06 seconds


insert into STUDENT_ID
values (000348282,'Tirilee','Lytler','Spanish',1,2,'12/01/1974');

insert into STUDENT_ID
values (23456677,'Koons','Smith','Business',1,1,'03/03/1976');

insert into STUDENT_ID
values (777349993,'John','Doe','Business',1,1,'02/03/1974');

insert into STUDENT_ID
values (800005555,'Patrik','Saint','Business',2,2,'07/08/1974');

insert into STUDENT_ID
values (999001111,'James','Kirkland','Und',1,1,'01/05/1976');

insert into STUDENT_ID
values (999009800,'Mary','Smith','Math',1,2,'08/28/1947');

insert into STUDENT_ID
values (999110000,'Sally','Jones','English',1,2,'06/19/1978');

insert into STUDENT_ID
values (666110001,'Bill','Mack','English',2,1,'09/06/1978’);

INSERT INTO STUDENT_ID
VALUES (555119800,'Gerg','Johnson','Business',2,1,'04/05/1955');

INSERT INTO STUDENT_ID
VALUES (444339837,'Jacob','Schwartz','English',1,1,'12/25/1974');

INSERT INTO STUDENT_ID
VALUES (333448887,'Jeny','Donald','English',3,2,'08/07/1974');

INSERT INTO STUDENT_ID
VALUES (222551288,'Nacy','Ogur','Art',1,2,'05/05/1948');