Scribd
Upload
8 views1 page

Practice Exercise Dbms

The document outlines a series of database tasks including creating tables for books, members, employees, staff, and bank customers with specific attributes and relationships. It also includes instructions for setting primary and foreign key constraints, altering tables, and querying for specific data such as available books and employees with the highest incentives. Additionally, it mentions updating financial data and managing integrity constraints.

Uploaded by

jasinthajasmine2006
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
8 views1 page

Practice Exercise Dbms

The document outlines a series of database tasks including creating tables for books, members, employees, staff, and bank customers with specific attributes and relationships. It also includes instructions for setting primary and foreign key constraints, altering tables, and querying for specific data such as available books and employees with the highest incentives. Additionally, it mentions updating financial data and managing integrity constraints.

Uploaded by

jasinthajasmine2006
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

1.

a) Create tables and insert records


Book(Book-id, Book_name, Author, Edition, Availability_status)
Member(Member_id, Member_name, Dept, Book_id, Borrow_date)
b) Set a foreign key relationship for tables on Book_id
c) List the books that are available.

2. A) Create table and insert records


Employee(Emp_no, Emp_name, Dept_no, DOJ, salary, incentive)
b) Specify a constraint using ALTER, that Emp_no should be the primary key
c) From the table find the employees who gets highest incentiv

3. a) Create table and insert records


Staff(Staff_id, Name, Date_of_join, Date_of_Ret, Dept, Desig)
Subject(Subject_code, Subject_Name, Staff_id)
b) Specify primary key, foreign key and not null constraint wherever required
c) Display the staff who gets retired.

4. a) Create a table with primary key and insert records


BANK(Cus-id,Cus_name,Br_no,Fd_no)
FD(FD_no,FD_amt)
b) Drop integrity Constraint and FD amount limit should be 100000
c) Update the FD amount with 5% increase.

You might also like