Scribd
Upload
3 views1 page

Student and Department Table Management

The document outlines a series of tasks for a lab assignment involving the creation of Student and Department tables in a database. It includes instructions for establishing relationships, inserting records, practicing various SQL operations such as delete cascade, and modifying table structures. Additionally, it emphasizes the importance of verifying relationships and practicing data manipulation commands.

Uploaded by

Rakesh Yadav
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
3 views1 page

Student and Department Table Management

The document outlines a series of tasks for a lab assignment involving the creation of Student and Department tables in a database. It includes instructions for establishing relationships, inserting records, practicing various SQL operations such as delete cascade, and modifying table structures. Additionally, it emphasizes the importance of verifying relationships and practicing data manipulation commands.

Uploaded by

Rakesh Yadav
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

Additional Task (Lab-2 continued…..

1. Create Student and Department Tables.


a. Department Table is Parent Table with Dno, Dname and Location.
Here Dno is the primary key.
b. Student Table is Child Table with Sno,Sname,Grades and Dno.
Here sno is primary key and dno is referential integrity constraint
which refer to Department Table.
2. Insert appropriate records in each table and verify the relationship
among Tables.
3. Practice delete cascade and delete set null options.
4. Remove Constraints on both tables ie Department and Student Tables.
5. Add address and contact number fields to Student Tables.
6. Update the Values for the above fields(ie. Newly created fields).
7. Practice change data type, change size ,remove fields rename fields
operations.
8. Practice Delete, Update, Commit and Rollback commands.

You might also like