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


PRACTIAL ASSIGNMENT-2



1. ADD CONSTRAINTS NOT NULL IN credits field OF course.

ALTER TABLE stud_COURSE
MODIFY credits NUMBER(3)NOT NULL

TABLE altered.
0.69 seconds


2. ADD a NEW field AS “Fees” IN course TABLE WITH NUMBER data TYPE AND
SIZE IS 10,2.

ALTER TABLE stud_COURSE
ADD STUD_fees NUMBER(10,2);

TABLE altered.
0.28 seconds


3.MODIFY the field SIZE Major IN student TABLE take AS VARCHAR AND SIZE
IS 20.

ALTER TABLE STUDENT_ID
MODIFY major VARCHAR(20);

TABLE altered.
0.00 seconds



4. ADD a NEW field name AS “contact NUMBER” IN student TABLE WITH
proper data TYPE AND SIZE.

ALTER TABLE STUDENT_ID
ADD contact_number NUMBER(10);

TABLE altered.
0.06 seconds

5. MODIFY the data TYPE OF gender AS VARCHAR OF student TABLE.

ALTER TABLE STUDENT_ID
MODIFY gender NUMBER(1);
TABLE altered.
0.04 seconds


6. ADD PRIMARY KEY CONSTRAINTS IN course NUMBER IN course TABLE AND
student_ID IN student TABLE AND student_ID IN student TABLE.

ALTER TABLE STUDENT_ID
ADD PRIMARY KEY(stud_id);

TABLE altered.
0.08 seconds


7.ADD foreign KEY CONSTRAINT IN enrollment TABLE AS course NUMBER IN
course TABLE.

ALTER TABLE STUD_ENROLLMENT
ADD FOREIGN KEY(course_no)REFERENCES
stud_COURSE(course_no);

TABLE altered.
0.02 seconds

8.DELETE the COLUMN OF fees OF course TABLE.

ALTER TABLE stud_COURSE
DROP COLUMN Fees;

9.DROP the TABLE OF course.

DROP TABLE stud_COURSE;

10.DELETE the major AND contact NUMBER field OF student able.

ALTER TABLE STUDENT_ID
DROP COLUMN major
DROP COLUMN contact_no;

11.ADD the NEW field IN enrollment TABLE AS “enroll-DATE” WITH proper
data TYPE AND SIZE.

ALTER TABLE STUD_ENROLLMENT
ADD enrollment-DATE DATE;