KEMBAR78
DBMS Assignment 1 | PDF | Information Management | Scientific Modeling
Scribd
Upload
54 views7 pages

DBMS Assignment 1

The document is a lab file submitted by Nikhil Negi (Roll No. 17103069) for the Database Management System course (CSN-208). It describes creating tables for employees and departments with various constraints - including primary keys, foreign keys, unique keys, and default constraints. It also covers removing existing constraints.

Uploaded by

Nikhil Negi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
54 views7 pages

DBMS Assignment 1

The document is a lab file submitted by Nikhil Negi (Roll No. 17103069) for the Database Management System course (CSN-208). It describes creating tables for employees and departments with various constraints - including primary keys, foreign keys, unique keys, and default constraints. It also covers removing existing constraints.

Uploaded by

Nikhil Negi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 7

DATABASE MANAGEMENT SYSTEM

(CSN-208)

LAB FILE

SUBMITTED BY:

Nikhil Negi

17103069
INDEX
S.No. Description Submission Remarks
Date
DBMS Assignment 1, 2
Ques 1, 2) A table emp has emp_id, emp_name Is unique, dept_no is foreign key and other
fields. A table dept has DEPT_NO, DNAME, location. Create table which can
accommodate these.

ScreenShot:
Ques 3) Apply NOT NULL constraint on JOB attribute of emp table.

Ques 4) Add a column startdate of department

Ques 5) Apply UNIQUE key constraint on SAL attribute of emp table.

Ques 6) Apply a default constraint on JOB attribute of EMP table

Ques 7) Apply primary key constraint on dept no of dept table


Ques 8) Apply foreign key constraint on deptno in emp table. It references to deptno of
the dept table.

Ques 9) Remove the existing constraint from a table.

Ques 10) Remove Foreign key constraint

Ques 11) Remove a PK constraint on the dept table and drop the associated foreign key
constraint on the emp.deptno column.
Ques 12) View all the user constraints

You might also like