EXPRIMENT : 1

Create a database table, add constraints (primary key, unique, check, Not null), insert rows,
update and delete rows using SQL DDL and DML commands.

Different 60 Questions:
1. Create a table named Student with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
2. Create a table named Employee with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
3. Create a table named LibraryBook with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
4. Create a table named Patient with appropriate attributes. Add PRIMARY KEY, UNIQUE, CHECK,
and NOT NULL constraints. Insert at least 5 records. Update one record based on a condition.
Delete one record based on a condition. Display the final table contents.
5. Create a table named Course with appropriate attributes. Add PRIMARY KEY, UNIQUE, CHECK,
and NOT NULL constraints. Insert at least 5 records. Update one record based on a condition.
Delete one record based on a condition. Display the final table contents.
6. Create a table named HotelReservation with appropriate attributes. Add PRIMARY KEY,
UNIQUE, CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based
on a condition. Delete one record based on a condition. Display the final table contents.
7. Create a table named BankAccount with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
8. Create a table named Product with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
9. Create a table named Customer with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
10. Create a table named Vehicle with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
11. Create a table named MovieTicket with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
12. Create a table named OnlineOrder with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
13. Create a table named Supplier with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
14. Create a table named InsurancePolicy with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
15. Create a table named ExamResult with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
16. Create a table named Faculty with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
17. Create a table named SportsPlayer with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
18. Create a table named AirlinePassenger with appropriate attributes. Add PRIMARY KEY,
UNIQUE, CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based
on a condition. Delete one record based on a condition. Display the final table contents.
19. Create a table named MobilePhone with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
20. Create a table named RestaurantMenu with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
21. Create a table named GymMember with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
22. Create a table named ElectricityBill with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
23. Create a table named WaterConsumer with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
24. Create a table named Property with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
25. Create a table named PharmacyItem with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
26. Create a table named BusPassenger with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
27. Create a table named EventRegistration with appropriate attributes. Add PRIMARY KEY,
UNIQUE, CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based
on a condition. Delete one record based on a condition. Display the final table contents.
28. Create a table named TrainingProgram with appropriate attributes. Add PRIMARY KEY,
UNIQUE, CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based
on a condition. Delete one record based on a condition. Display the final table contents.
29. Create a table named Payroll with appropriate attributes. Add PRIMARY KEY, UNIQUE, CHECK,
and NOT NULL constraints. Insert at least 5 records. Update one record based on a condition.
Delete one record based on a condition. Display the final table contents.
30. Create a table named SalesRecord with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
31. Create a table named Project with appropriate attributes. Add PRIMARY KEY, UNIQUE, CHECK,
and NOT NULL constraints. Insert at least 5 records. Update one record based on a condition.
Delete one record based on a condition. Display the final table contents.
32. Create a table named Courier with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
33. Create a table named ClinicAppointment with appropriate attributes. Add PRIMARY KEY,
UNIQUE, CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based
on a condition. Delete one record based on a condition. Display the final table contents.
34. Create a table named WarehouseItem with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
35. Create a table named E-CommerceProduct with appropriate attributes. Add PRIMARY KEY,
UNIQUE, CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based
on a condition. Delete one record based on a condition. Display the final table contents.
36. Create a table named Vendor with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
37. Create a table named Scholarship with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
38. Create a table named HostelStudent with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
39. Create a table named TourPackage with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
40. Create a table named LibraryMember with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
41. Create a table named BookSale with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
42. Create a table named Laptop with appropriate attributes. Add PRIMARY KEY, UNIQUE, CHECK,
and NOT NULL constraints. Insert at least 5 records. Update one record based on a condition.
Delete one record based on a condition. Display the final table contents.
43. Create a table named SchoolAdmission with appropriate attributes. Add PRIMARY KEY,
UNIQUE, CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based
on a condition. Delete one record based on a condition. Display the final table contents.
44. Create a table named VehicleRental with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
45. Create a table named InsuranceClaim with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
46. Create a table named DoctorAppointment with appropriate attributes. Add PRIMARY KEY,
UNIQUE, CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based
on a condition. Delete one record based on a condition. Display the final table contents.
47. Create a table named OnlineCourse with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
48. Create a table named MovieReview with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
49. Create a table named CustomerFeedback with appropriate attributes. Add PRIMARY KEY,
UNIQUE, CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based
on a condition. Delete one record based on a condition. Display the final table contents.
50. Create a table named ParkingSlot with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
51. Create a table named FlightBooking with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
52. Create a table named LoanApplication with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
53. Create a table named ResearchProject with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
54. Create a table named ConferenceParticipant with appropriate attributes. Add PRIMARY KEY,
UNIQUE, CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based
on a condition. Delete one record based on a condition. Display the final table contents.
55. Create a table named AgricultureProduct with appropriate attributes. Add PRIMARY KEY,
UNIQUE, CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based
on a condition. Delete one record based on a condition. Display the final table contents.
56. Create a table named PetRecord with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
57. Create a table named JobApplicant with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
58. Create a table named RetailBill with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
59. Create a table named MuseumVisitor with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
60. Create a table named SportsEvent with appropriate attributes. Add PRIMARY KEY, UNIQUE,
CHECK, and NOT NULL constraints. Insert at least 5 records. Update one record based on a
condition. Delete one record based on a condition. Display the final table contents.
 EXPERIMENT : 2

Create a set of tables, add foreign key constraints and incorporate referential integrity.

Different 60 Questions:

1. Create Student and Department tables. Define a foreign key relationship between Student and
Department tables and demonstrate referential integrity with sample records.
2. Create Employee and Department tables. Establish a foreign key constraint and perform insert,
update, and delete operations while maintaining referential integrity.
3. Create Book and Publisher tables. Add a foreign key relationship and demonstrate referential
integrity.
4. Create Patient and Doctor tables. Define a foreign key constraint and validate referential
integrity.
5. Create Course and Faculty tables. Establish a foreign key relationship and perform DML
operations.
6. Create Hotel and Reservation tables. Add foreign key constraints and maintain referential
integrity.
7. Create Customer and BankAccount tables. Define a foreign key relationship and test referential
integrity.
8. Create Category and Product tables. Add foreign key constraints and perform CRUD operations.
9. Create Customer and Order tables. Establish a foreign key relationship and maintain referential
integrity.
10. Create Owner and Vehicle tables. Define a foreign key constraint and demonstrate referential
integrity.
11. Create Movie and Ticket tables. Establish a foreign key relationship and perform transactions.
12. Create Customer and OnlineOrder tables. Add foreign key constraints and validate referential
integrity.
13. Create Supplier and Product tables. Define a foreign key relationship and test integrity
constraints.
14. Create PolicyHolder and InsurancePolicy tables. Establish a foreign key relationship.
15. Create Student and ExamResult tables. Add foreign key constraints and maintain referential
integrity.
16. Create Faculty and Department tables. Define a foreign key relationship.
17. Create Team and SportsPlayer tables. Establish foreign key constraints and demonstrate
referential integrity.
18. Create Flight and Passenger tables. Add foreign key constraints and test data consistency.
19. Create Brand and MobilePhone tables. Define a foreign key relationship.
20. Create Restaurant and MenuItem tables. Add foreign key constraints and perform DML
operations.
21. Create Gym and Member tables. Establish a foreign key relationship.
22. Create Consumer and ElectricityBill tables. Define foreign key constraints.
23. Create Consumer and WaterBill tables. Add foreign key relationships and test integrity.
24. Create Owner and Property tables. Establish foreign key constraints.
25. Create Pharmacy and Medicine tables. Define a foreign key relationship.
26. Create Bus and Passenger tables. Add foreign key constraints and demonstrate referential
integrity.
27. Create Event and Registration tables. Establish a foreign key relationship.
28. Create TrainingCenter and TrainingProgram tables. Add foreign key constraints.
29. Create Employee and Payroll tables. Define a foreign key relationship and test integrity.
30. Create Customer and SalesRecord tables. Establish foreign key constraints.
31. Create Client and Project tables. Add foreign key relationships.
32. Create Customer and Courier tables. Define a foreign key constraint.
33. Create Doctor and Appointment tables. Establish referential integrity.
34. Create Warehouse and Item tables. Add foreign key constraints.
35. Create Category and EcommerceProduct tables. Define a foreign key relationship.
36. Create Vendor and Product tables. Establish foreign key constraints.
37. Create Student and Scholarship tables. Add foreign key relationships.
38. Create Hostel and HostelStudent tables. Define foreign key constraints.
39. Create TourOperator and TourPackage tables. Establish referential integrity.
40. Create Library and Member tables. Add foreign key constraints.
41. Create Book and BookSale tables. Define a foreign key relationship.
42. Create Brand and Laptop tables. Establish foreign key constraints.
43. Create School and Admission tables. Add foreign key relationships.
44. Create Customer and VehicleRental tables. Define foreign key constraints.
45. Create InsurancePolicy and InsuranceClaim tables. Establish referential integrity.
46. Create Doctor and DoctorAppointment tables. Add foreign key constraints.
47. Create Instructor and OnlineCourse tables. Define a foreign key relationship.
48. Create Movie and MovieReview tables. Establish foreign key constraints.
49. Create Customer and CustomerFeedback tables. Add foreign key relationships.
50. Create ParkingArea and ParkingSlot tables. Define referential integrity constraints.
51. Create Flight and FlightBooking tables. Add foreign key constraints.
52. Create Customer and LoanApplication tables. Establish a foreign key relationship.
53. Create Faculty and ResearchProject tables. Define foreign key constraints.
54. Create Conference and Participant tables. Add foreign key relationships.
55. Create Farmer and AgricultureProduct tables. Establish referential integrity.
56. Create PetOwner and PetRecord tables. Define foreign key constraints.
57. Create Company and JobApplicant tables. Add foreign key relationships.
58. Create Customer and RetailBill tables. Establish foreign key constraints.
59. Create Museum and Visitor tables. Define a foreign key relationship.
60. Create SportsCategory and SportsEvent tables. Add foreign key constraints and demonstrate
referential integrity.
 EXPERIMENT : 3

Query the database tables using different WHERE clause conditions and also implement
aggregate functions.

Different 60 Practical Questions

1. Create a Student table and retrieve students whose marks are greater than 80. Use COUNT(),
AVG(), MAX(), and MIN() functions.
2. Create an Employee table and display employees whose salary is greater than 30000. Apply
aggregate functions on salary.
3. Create a LibraryBook table and retrieve books belonging to a specific category using WHERE.
Find the total number of books.
4. Create a Patient table and display patients above 50 years of age. Calculate average age using
AVG().
5. Create a Course table and retrieve courses with fees greater than 10000. Find maximum and
minimum fees.
6. Create a HotelReservation table and display reservations for a particular city. Count total
reservations.
7. Create a BankAccount table and retrieve accounts with balance greater than 50000. Find total
balance using SUM().
8. Create a Product table and display products with stock less than 20. Calculate average stock.
9. Create a Customer table and retrieve customers from a specific city. Count customers city-wise.
10. Create a Vehicle table and display vehicles manufactured after 2020. Find total number of
vehicles.
11. Create a MovieTicket table and retrieve tickets booked for a specific movie. Count tickets sold.
12. Create an OnlineOrder table and display orders above ₹5000. Calculate total sales amount.
13. Create a Supplier table and retrieve suppliers from a specific location. Count total suppliers.
14. Create an InsurancePolicy table and display policies with premium above ₹10000. Find average
premium.
15. Create an ExamResult table and retrieve students scoring above 75 marks. Calculate highest and
lowest marks.
16. Create a Faculty table and display faculty members with experience greater than 10 years. Find
average experience.
17. Create a SportsPlayer table and retrieve players scoring more than 50 runs/goals. Calculate
average score.
18. Create an AirlinePassenger table and display passengers travelling to a specific destination.
Count passengers.
19. Create a MobilePhone table and retrieve phones costing above ₹20000. Find average price.
20. Create a RestaurantMenu table and display food items costing less than ₹200. Calculate average
item price.
21. Create a GymMember table and retrieve members whose membership fee exceeds ₹5000. Find
total fee collected.
22. Create an ElectricityBill table and display consumers with bill amount above ₹1000. Calculate
total collection.
23. Create a WaterConsumer table and retrieve consumers with usage greater than 500 units. Find
average usage.
24. Create a Property table and display properties costing above ₹50 lakhs. Find maximum property
value.
25. Create a PharmacyItem table and retrieve medicines with stock below 50. Calculate average
stock.
26. Create a BusPassenger table and display passengers travelling on a particular route. Count
passengers.
27. Create an EventRegistration table and retrieve registrations for a specific event. Find total
registrations.
28. Create a TrainingProgram table and display programs with duration greater than 30 days. Find
average duration.
29. Create a Payroll table and retrieve employees earning above ₹40000. Find total payroll amount.
30. Create a SalesRecord table and display sales greater than ₹10000. Calculate total sales.
31. Create a Project table and retrieve projects with budget above ₹1,00,000. Find average budget.
32. Create a Courier table and display parcels delivered to a specific city. Count deliveries.
33. Create a ClinicAppointment table and retrieve appointments for a specific doctor. Count
appointments.
34. Create a WarehouseItem table and display items with quantity below 25. Find average quantity.
35. Create an ECommerceProduct table and retrieve products with ratings above 4.0. Calculate
average rating.
36. Create a Vendor table and display vendors supplying more than 100 products. Count vendors.
37. Create a Scholarship table and retrieve scholarships above ₹25000. Find average scholarship
amount.
38. Create a HostelStudent table and display students from a specific department. Count hostel
residents.
39. Create a TourPackage table and retrieve packages costing below ₹20000. Find average package
cost.
40. Create a LibraryMember table and display members who joined after a specific date. Count
members.
41. Create a BookSale table and retrieve sales greater than ₹5000. Calculate total sales revenue.
42. Create a Laptop table and display laptops with RAM greater than 8GB. Find average price.
43. Create a SchoolAdmission table and retrieve students admitted in a specific year. Count
admissions.
44. Create a VehicleRental table and display rentals costing above ₹3000. Calculate average rental
cost.
45. Create an InsuranceClaim table and retrieve claims above ₹50000. Find total claim amount.
46. Create a DoctorAppointment table and display appointments on a specific date. Count
appointments.
47. Create an OnlineCourse table and retrieve courses with fees above ₹5000. Calculate average fee.
48. Create a MovieReview table and display reviews with ratings above 4 stars. Find average rating.
49. Create a CustomerFeedback table and retrieve feedback from a specific city. Count feedback
entries.
50. Create a ParkingSlot table and display occupied slots. Count occupied and vacant slots.
51. Create a FlightBooking table and retrieve bookings for a specific destination. Count bookings.
52. Create a LoanApplication table and display loans above ₹2,00,000. Find average loan amount.
53. Create a ResearchProject table and retrieve projects with funding above ₹5,00,000. Calculate
average funding.
54. Create a ConferenceParticipant table and display participants from a specific organization. Count
participants.
55. Create an AgricultureProduct table and retrieve products with quantity above 100 units.
Calculate average quantity.
56. Create a PetRecord table and display pets older than 5 years. Find average pet age.
57. Create a JobApplicant table and retrieve applicants with experience above 3 years. Count
applicants.
58. Create a RetailBill table and display bills above ₹2000. Calculate total revenue.
59. Create a MuseumVisitor table and retrieve visitors on a specific date. Count visitors.
60. Create a SportsEvent table and display events conducted in a specific location. Count events and
find average participation.
 EXPERIMENT : 4

Query the database tables and explore sub queries and simple join operations.

Different 60 Questions

1. Create Student and Department tables. Retrieve students belonging to the department with the
highest budget using a subquery and INNER JOIN.
2. Create Employee and Department tables. Display employees whose salary is greater than the
average salary using a subquery and JOIN operation.
3. Create LibraryBook and Publisher tables. Retrieve books published by the publisher having the
maximum number of publications using a subquery and JOIN.
4. Create Patient and Doctor tables. Display patients treated by the doctor with the highest
experience using a subquery and JOIN.
5. Create Course and Faculty tables. Retrieve courses handled by faculty members whose salary is
above the average salary using subqueries and JOIN.
6. Create HotelReservation and Customer tables. Display reservations made by customers who
spent the highest amount.
7. Create BankAccount and Customer tables. Retrieve accounts whose balance exceeds the average
account balance.
8. Create Product and Category tables. Display products belonging to the category with the
maximum number of products.
9. Create Customer and Order tables. Retrieve customers who placed orders above the average
order value.
10. Create Vehicle and Owner tables. Display vehicles owned by customers from a specific city
using JOIN.
11. Create MovieTicket and Movie tables. Retrieve ticket bookings for the movie with the highest
ticket sales.
12. Create OnlineOrder and Customer tables. Display customers who placed more orders than the
average customer.
13. Create Supplier and Product tables. Retrieve suppliers supplying products with prices above the
average product price.
14. Create InsurancePolicy and PolicyHolder tables. Display policy holders with premiums greater
than the average premium.
15. Create ExamResult and Student tables. Retrieve students whose marks are above the average
mark using a subquery.
16. Create Faculty and Department tables. Display faculty members working in departments with the
highest budget.
17. Create SportsPlayer and Team tables. Retrieve players whose scores exceed the average score.
18. Create AirlinePassenger and Flight tables. Display passengers travelling on flights with
maximum occupancy.
19. Create MobilePhone and Brand tables. Retrieve phones priced above the average price using
JOIN and subquery.
20. Create RestaurantMenu and Category tables. Display menu items belonging to the category with
the highest number of items.
21. Create GymMember and MembershipPlan tables. Retrieve members enrolled in the most popular
plan.
22. Create ElectricityBill and Consumer tables. Display consumers whose bill amount exceeds the
average bill amount.
23. Create WaterConsumer and WaterBill tables. Retrieve consumers with usage greater than
average usage.
24. Create Property and Owner tables. Display properties costing more than the average property
value.
25. Create PharmacyItem and Supplier tables. Retrieve medicines supplied by the supplier with the
maximum supplies.
26. Create BusPassenger and Bus tables. Display passengers travelling on buses with the highest
occupancy.
27. Create EventRegistration and Event tables. Retrieve events having registrations above the
average count.
28. Create TrainingProgram and Trainer tables. Display programs conducted by trainers with the
highest ratings.
29. Create Payroll and Employee tables. Retrieve employees earning above the average salary.
30. Create SalesRecord and Customer tables. Display customers whose purchases exceed average
sales.
31. Create Project and Employee tables. Retrieve projects having budgets above the average project
budget.
32. Create Courier and Customer tables. Display customers who sent the maximum number of
parcels.
33. Create ClinicAppointment and Doctor tables. Retrieve doctors with appointments above average
appointment count.
34. Create WarehouseItem and Supplier tables. Display items supplied by suppliers with the highest
inventory.
35. Create ECommerceProduct and Category tables. Retrieve products whose ratings are above
average ratings.
36. Create Vendor and Product tables. Display vendors supplying products with maximum sales.
37. Create Scholarship and Student tables. Retrieve students receiving scholarships above the
average amount.
38. Create HostelStudent and Hostel tables. Display hostels with occupancy above average
occupancy.
39. Create TourPackage and TourOperator tables. Retrieve packages costing more than the average
package cost.
40. Create LibraryMember and LibraryBook tables. Display members who borrowed more books
than the average member.
41. Create BookSale and Customer tables. Retrieve customers with purchases above average sales
value.
42. Create Laptop and Brand tables. Display laptops priced above average laptop price.
43. Create SchoolAdmission and Student tables. Retrieve students admitted in the department with
the highest intake.
44. Create VehicleRental and Customer tables. Display customers whose rental expenses exceed the
average expense.
45. Create InsuranceClaim and InsurancePolicy tables. Retrieve claims greater than the average
claim amount.
46. Create DoctorAppointment and Doctor tables. Display doctors having appointments above
average count.
47. Create OnlineCourse and Instructor tables. Retrieve courses whose fees exceed the average
course fee.
48. Create MovieReview and Movie tables. Display movies with ratings above the average rating.
49. Create CustomerFeedback and Customer tables. Retrieve customers who submitted more
feedback than average.
50. Create ParkingSlot and Vehicle tables. Display vehicles parked in occupied slots using JOIN.
51. Create FlightBooking and Passenger tables. Retrieve passengers with bookings exceeding
average booking count.
52. Create LoanApplication and Customer tables. Display customers whose loan amount exceeds the
average loan amount.
53. Create ResearchProject and Faculty tables. Retrieve projects with funding greater than average
funding.
54. Create ConferenceParticipant and Conference tables. Display conferences with participant
counts above average.
55. Create AgricultureProduct and Farmer tables. Retrieve farmers producing quantities above
average production.
56. Create PetRecord and PetOwner tables. Display pet owners having more pets than the average
owner.
57. Create JobApplicant and Company tables. Retrieve applicants whose experience exceeds
average experience.
58. Create RetailBill and Customer tables. Display customers whose bill amounts exceed average
bill value.
59. Create MuseumVisitor and Museum tables. Retrieve museums having visitor counts above
average.
60. Create SportsEvent and SportsCategory tables. Display events whose participation exceeds
average participation using subqueries and JOIN operations.
 EXPERIMENT : 5

Query the database tables and explore Natural, Equi and Outer Joins.

Different 60 Questions

1. Create Student and Department tables. Perform NATURAL JOIN, EQUI JOIN, LEFT OUTER
JOIN and RIGHT OUTER JOIN to display student and department details.
2. Create Employee and Department tables. Retrieve employee and department information using
Natural, Equi and Outer Joins.
3. Create LibraryBook and Publisher tables. Display book and publisher details using different join
operations.
4. Create Patient and Doctor tables. Retrieve patient treatment information using Natural, Equi and
Outer Joins.
5. Create Course and Faculty tables. Display course and faculty information using various join
types.
6. Create HotelReservation and Customer tables. Retrieve reservation details using Natural, Equi
and Outer Joins.
7. Create BankAccount and Customer tables. Display account holder information using different
join operations.
8. Create Product and Category tables. Retrieve product details along with category information
using joins.
9. Create Customer and Order tables. Display customer order details using Natural, Equi and Outer
Joins.
10. Create Vehicle and Owner tables. Retrieve vehicle ownership details using various joins.
11. Create MovieTicket and Movie tables. Display movie and ticket booking information using
joins.
12. Create OnlineOrder and Customer tables. Retrieve customer order details using Natural and
Outer Joins.
13. Create Supplier and Product tables. Display supplier and product information using join
operations.
14. Create InsurancePolicy and PolicyHolder tables. Retrieve policy and holder information using
joins.
15. Create ExamResult and Student tables. Display student results using Natural, Equi and Outer
Joins.
16. Create Faculty and Department tables. Retrieve faculty and department information using join
operations.
17. Create SportsPlayer and Team tables. Display player and team information using different joins.
18. Create AirlinePassenger and Flight tables. Retrieve passenger and flight details using join
operations.
19. Create MobilePhone and Brand tables. Display mobile phone and brand details using joins.
20. Create RestaurantMenu and Category tables. Retrieve menu and category information using
Natural and Outer Joins.
21. Create GymMember and MembershipPlan tables. Display member and membership plan details
using joins.
22. Create ElectricityBill and Consumer tables. Retrieve bill and consumer information using join
operations.
23. Create WaterConsumer and WaterBill tables. Display water usage and bill details using joins.
24. Create Property and Owner tables. Retrieve property ownership information using various joins.
25. Create PharmacyItem and Supplier tables. Display medicine and supplier information using
joins.
26. Create BusPassenger and Bus tables. Retrieve passenger and bus information using Natural and
Outer Joins.
27. Create EventRegistration and Event tables. Display event registration details using joins.
28. Create TrainingProgram and Trainer tables. Retrieve training and trainer information using join
operations.
29. Create Payroll and Employee tables. Display employee payroll information using joins.
30. Create SalesRecord and Customer tables. Retrieve sales and customer details using various joins.
31. Create Project and Employee tables. Display project assignment information using joins.
32. Create Courier and Customer tables. Retrieve courier service details using Natural and Outer
Joins.
33. Create ClinicAppointment and Doctor tables. Display appointment and doctor details using
joins.
34. Create WarehouseItem and Supplier tables. Retrieve warehouse and supplier information using
joins.
35. Create ECommerceProduct and Category tables. Display product and category information using
join operations.
36. Create Vendor and Product tables. Retrieve vendor and product details using various joins.
37. Create Scholarship and Student tables. Display scholarship recipient information using joins.
38. Create HostelStudent and Hostel tables. Retrieve hostel allocation details using Natural and
Outer Joins.
39. Create TourPackage and TourOperator tables. Display package and operator information using
joins.
40. Create LibraryMember and LibraryBook tables. Retrieve borrowing details using join
operations.
41. Create BookSale and Customer tables. Display book sales information using joins.
42. Create Laptop and Brand tables. Retrieve laptop and brand information using Natural and Outer
Joins.
43. Create SchoolAdmission and Student tables. Display admission information using join
operations.
44. Create VehicleRental and Customer tables. Retrieve rental transaction details using joins.
45. Create InsuranceClaim and InsurancePolicy tables. Display claim and policy information using
joins.
46. Create DoctorAppointment and Doctor tables. Retrieve appointment details using join
operations.
47. Create OnlineCourse and Instructor tables. Display course and instructor information using joins.
48. Create MovieReview and Movie tables. Retrieve movie review information using Natural and
Outer Joins.
49. Create CustomerFeedback and Customer tables. Display customer feedback details using joins.
50. Create ParkingSlot and Vehicle tables. Retrieve parking allocation information using joins.
51. Create FlightBooking and Passenger tables. Display booking and passenger details using join
operations.
52. Create LoanApplication and Customer tables. Retrieve loan application details using joins.
53. Create ResearchProject and Faculty tables. Display project and faculty information using join
operations.
54. Create ConferenceParticipant and Conference tables. Retrieve participant and conference details
using joins.
55. Create AgricultureProduct and Farmer tables. Display agricultural product information using
joins.
56. Create PetRecord and PetOwner tables. Retrieve pet and owner information using Natural and
Outer Joins.
57. Create JobApplicant and Company tables. Display applicant and company details using joins.
58. Create RetailBill and Customer tables. Retrieve retail billing information using join operations.
59. Create MuseumVisitor and Museum tables. Display visitor and museum information using joins.
60. Create SportsEvent and SportsCategory tables. Retrieve sports event details using Natural, Equi
and Outer Join operations.
 EXPERIMENT : 6

Write User Defined Functions and Stored Procedures in SQL.

Different 60 Questions

1. Create a Student table. Write a user-defined function to calculate student grade based on marks
and a stored procedure to display student details.
2. Create an Employee table. Write a function to calculate annual salary and a stored procedure to
update employee salary.
3. Create a LibraryBook table. Write a function to calculate overdue fine and a stored procedure to
display issued books.
4. Create a Patient table. Write a function to calculate patient age and a stored procedure to retrieve
patient information.
5. Create a Course table. Write a function to calculate course duration and a stored procedure to
update course fees.
6. Create a HotelReservation table. Write a function to calculate total room charges and a stored
procedure to display reservation details.
7. Create a BankAccount table. Write a function to calculate interest and a stored procedure to
update account balance.
8. Create a Product table. Write a function to calculate discounted price and a stored procedure to
retrieve product details.
9. Create a Customer table. Write a function to calculate loyalty points and a stored procedure to
display customer information.
10. Create a Vehicle table. Write a function to calculate vehicle age and a stored procedure to
retrieve vehicle details.
11. Create a MovieTicket table. Write a function to calculate ticket cost and a stored procedure to
display booking details.
12. Create an OnlineOrder table. Write a function to calculate order amount and a stored procedure
to retrieve order details.
13. Create a Supplier table. Write a function to calculate supply cost and a stored procedure to
display supplier details.
14. Create an InsurancePolicy table. Write a function to calculate premium amount and a stored
procedure to retrieve policy details.
15. Create an ExamResult table. Write a function to calculate grade and a stored procedure to
display result details.
16. Create a Faculty table. Write a function to calculate years of experience and a stored procedure
to retrieve faculty information.
17. Create a SportsPlayer table. Write a function to calculate average score and a stored procedure to
display player statistics.
18. Create an AirlinePassenger table. Write a function to calculate ticket fare and a stored procedure
to retrieve passenger details.
19. Create a MobilePhone table. Write a function to calculate discounted price and a stored
procedure to display phone details.
20. Create a RestaurantMenu table. Write a function to calculate bill amount and a stored procedure
to retrieve menu details.
21. Create a GymMember table. Write a function to calculate membership fee and a stored
procedure to display member details.
22. Create an ElectricityBill table. Write a function to calculate electricity charges and a stored
procedure to generate bills.
23. Create a WaterConsumer table. Write a function to calculate water charges and a stored
procedure to retrieve bill details.
24. Create a Property table. Write a function to calculate property tax and a stored procedure to
display property information.
25. Create a PharmacyItem table. Write a function to calculate stock value and a stored procedure to
retrieve medicine details.
26. Create a BusPassenger table. Write a function to calculate fare and a stored procedure to display
passenger details.
27. Create an EventRegistration table. Write a function to calculate registration fee and a stored
procedure to retrieve participant details.
28. Create a TrainingProgram table. Write a function to calculate training cost and a stored
procedure to display program details.
29. Create a Payroll table. Write a function to calculate net salary and a stored procedure to generate
payroll reports.
30. Create a SalesRecord table. Write a function to calculate sales commission and a stored
procedure to display sales details.
31. Create a Project table. Write a function to calculate project duration and a stored procedure to
retrieve project details.
32. Create a Courier table. Write a function to calculate delivery charges and a stored procedure to
display shipment details.
33. Create a ClinicAppointment table. Write a function to calculate consultation fee and a stored
procedure to retrieve appointment details.
34. Create a WarehouseItem table. Write a function to calculate inventory value and a stored
procedure to display stock details.
35. Create an ECommerceProduct table. Write a function to calculate selling price and a stored
procedure to retrieve product information.
36. Create a Vendor table. Write a function to calculate vendor commission and a stored procedure
to display vendor details.
37. Create a Scholarship table. Write a function to calculate scholarship amount and a stored
procedure to retrieve scholarship information.
38. Create a HostelStudent table. Write a function to calculate hostel fee and a stored procedure to
display resident details.
39. Create a TourPackage table. Write a function to calculate package cost and a stored procedure to
retrieve package details.
40. Create a LibraryMember table. Write a function to calculate overdue fine and a stored procedure
to display member information.
41. Create a BookSale table. Write a function to calculate sales amount and a stored procedure to
retrieve sales details.
42. Create a Laptop table. Write a function to calculate discounted price and a stored procedure to
display laptop details.
43. Create a SchoolAdmission table. Write a function to calculate admission fee and a stored
procedure to retrieve admission details.
44. Create a VehicleRental table. Write a function to calculate rental charges and a stored procedure
to display rental information.
45. Create an InsuranceClaim table. Write a function to calculate claim amount and a stored
procedure to retrieve claim details.
46. Create a DoctorAppointment table. Write a function to calculate consultation charges and a
stored procedure to display appointment details.
47. Create an OnlineCourse table. Write a function to calculate course fee and a stored procedure to
retrieve course information.
48. Create a MovieReview table. Write a function to calculate average rating and a stored procedure
to display review details.
49. Create a CustomerFeedback table. Write a function to calculate satisfaction score and a stored
procedure to retrieve feedback information.
50. Create a ParkingSlot table. Write a function to calculate parking charges and a stored procedure
to display parking details.
51. Create a FlightBooking table. Write a function to calculate ticket fare and a stored procedure to
retrieve booking details.
52. Create a LoanApplication table. Write a function to calculate EMI and a stored procedure to
display loan details.
53. Create a ResearchProject table. Write a function to calculate project expenditure and a stored
procedure to retrieve project information.
54. Create a ConferenceParticipant table. Write a function to calculate registration cost and a stored
procedure to display participant details.
55. Create an AgricultureProduct table. Write a function to calculate production cost and a stored
procedure to retrieve product details.
56. Create a PetRecord table. Write a function to calculate vaccination cost and a stored procedure to
display pet information.
57. Create a JobApplicant table. Write a function to calculate experience level and a stored
procedure to retrieve applicant details.
58. Create a RetailBill table. Write a function to calculate total bill amount and a stored procedure to
generate billing reports.
59. Create a MuseumVisitor table. Write a function to calculate entry fee and a stored procedure to
display visitor details.
60. Create a SportsEvent table. Write a function to calculate participation statistics and a stored
procedure to display event details.
 EXPERIMENT : 7

Execute Complex Transactions and Realize DCL and TCL Commands.

Different 60 Questions

1. Create a Student table and perform COMMIT, ROLLBACK, and SAVEPOINT operations.
Grant and revoke privileges to users using DCL commands.
2. Create an Employee table and execute salary updates using TCL commands. Use GRANT and
REVOKE on the table.
3. Create a LibraryBook table and perform book issue and return transactions using SAVEPOINT
and ROLLBACK.
4. Create a Patient table and execute patient record updates using transaction control commands.
5. Create a Course table and perform multiple insertions using COMMIT and ROLLBACK
operations.
6. Create a HotelReservation table and execute reservation transactions using TCL commands.
7. Create a BankAccount table and simulate fund transfer between accounts using COMMIT and
ROLLBACK.
8. Create a Product table and perform inventory updates using SAVEPOINT and transaction
management.
9. Create a Customer table and grant SELECT privileges to a user. Revoke the privileges after
verification.
10. Create a Vehicle table and execute transactions involving vehicle registration updates.
11. Create a MovieTicket table and perform ticket booking transactions using COMMIT and
ROLLBACK.
12. Create an OnlineOrder table and manage order processing transactions with SAVEPOINT.
13. Create a Supplier table and grant INSERT, UPDATE privileges to another user.
14. Create an InsurancePolicy table and perform policy updates using TCL commands.
15. Create an ExamResult table and execute result processing transactions using COMMIT and
ROLLBACK.
16. Create a Faculty table and perform department transfer transactions using SAVEPOINT.
17. Create a SportsPlayer table and update player statistics using transaction control commands.
18. Create an AirlinePassenger table and execute flight booking transactions with COMMIT and
ROLLBACK.
19. Create a MobilePhone table and perform inventory modifications using SAVEPOINT.
20. Create a RestaurantMenu table and manage menu updates using TCL commands.
21. Create a GymMember table and process membership renewals using transaction management.
22. Create an ElectricityBill table and execute bill generation transactions.
23. Create a WaterConsumer table and perform billing transactions using COMMIT and
ROLLBACK.
24. Create a Property table and execute ownership transfer transactions.
25. Create a PharmacyItem table and manage stock transactions using SAVEPOINT.
26. Create a BusPassenger table and process ticket booking transactions.
27. Create an EventRegistration table and manage participant registrations using TCL commands.
28. Create a TrainingProgram table and perform enrollment transactions using SAVEPOINT.
29. Create a Payroll table and execute payroll processing transactions using COMMIT and
ROLLBACK.
30. Create a SalesRecord table and manage sales transactions with transaction control commands.
31. Create a Project table and perform project budget updates using SAVEPOINT.
32. Create a Courier table and execute shipment processing transactions.
33. Create a ClinicAppointment table and manage appointment scheduling transactions.
34. Create a WarehouseItem table and perform inventory transfers using TCL commands.
35. Create an ECommerceProduct table and process product purchase transactions.
36. Create a Vendor table and grant DELETE privilege to a user. Revoke it after testing.
37. Create a Scholarship table and perform scholarship allocation transactions.
38. Create a HostelStudent table and manage room allocation transactions.
39. Create a TourPackage table and execute booking transactions using COMMIT and ROLLBACK.
40. Create a LibraryMember table and manage membership transactions.
41. Create a BookSale table and process book purchase transactions.
42. Create a Laptop table and perform stock update transactions using SAVEPOINT.
43. Create a SchoolAdmission table and execute admission processing transactions.
44. Create a VehicleRental table and manage rental transactions using TCL commands.
45. Create an InsuranceClaim table and process claim settlement transactions.
46. Create a DoctorAppointment table and execute appointment booking transactions.
47. Create an OnlineCourse table and manage course enrollment transactions.
48. Create a MovieReview table and perform review update transactions using SAVEPOINT.
49. Create a CustomerFeedback table and execute feedback management transactions.
50. Create a ParkingSlot table and manage parking allocation transactions.
51. Create a FlightBooking table and process booking cancellations using ROLLBACK.
52. Create a LoanApplication table and execute loan approval transactions using TCL commands.
53. Create a ResearchProject table and perform project funding transactions.
54. Create a ConferenceParticipant table and manage conference registration transactions.
55. Create an AgricultureProduct table and execute product sale transactions using COMMIT and
ROLLBACK.
56. Create a PetRecord table and manage veterinary treatment transactions.
57. Create a JobApplicant table and process recruitment transactions using SAVEPOINT.
58. Create a RetailBill table and execute billing transactions with transaction control commands.
59. Create a MuseumVisitor table and manage ticketing transactions using TCL commands.
60. Create a SportsEvent table and execute participant registration transactions using COMMIT,
ROLLBACK, SAVEPOINT, GRANT, and REVOKE commands.
 EXPERIMENT : 8

Write SQL Triggers for INSERT, DELETE, and UPDATE Operations in a Database Table.

Different 60 Questions

1. Create a Student table and an Audit table. Write INSERT, UPDATE, and DELETE triggers to
record all modifications made to student records.
2. Create an Employee table and an Employee_Log table. Write triggers to track salary updates and
employee deletions.
3. Create a LibraryBook table and a Book_Audit table. Create triggers to maintain book transaction
history.
4. Create a Patient table and a Patient_History table. Write triggers to record patient information
changes.
5. Create a Course table and a Course_Log table. Create triggers to track course fee updates and
deletions.
6. Create a HotelReservation table and a Reservation_Log table. Write triggers to audit reservation
activities.
7. Create a BankAccount table and a Transaction_Log table. Create triggers to record balance
updates and account deletions.
8. Create a Product table and a Product_Audit table. Write triggers to track stock insertions,
updates, and deletions.
9. Create a Customer table and a Customer_Log table. Create triggers to maintain customer record
history.
10. Create a Vehicle table and a Vehicle_Audit table. Write triggers to monitor vehicle registration
changes.
11. Create a MovieTicket table and a Ticket_Log table. Create triggers to track ticket booking
updates.
12. Create an OnlineOrder table and an Order_Audit table. Write triggers to record order
modifications.
13. Create a Supplier table and a Supplier_Log table. Create triggers to audit supplier information
changes.
14. Create an InsurancePolicy table and a Policy_Log table. Write triggers to maintain policy
history.
15. Create an ExamResult table and a Result_Audit table. Create triggers to track mark updates.
16. Create a Faculty table and a Faculty_Log table. Write triggers to audit faculty record changes.
17. Create a SportsPlayer table and a Player_History table. Create triggers to track player statistics
updates.
18. Create an AirlinePassenger table and a Passenger_Log table. Write triggers to record passenger
information changes.
19. Create a MobilePhone table and a Mobile_Audit table. Create triggers to maintain inventory
history.
20. Create a RestaurantMenu table and a Menu_Log table. Write triggers to audit menu
modifications.
21. Create a GymMember table and a Member_History table. Create triggers to track membership
changes.
22. Create an ElectricityBill table and a Bill_Log table. Write triggers to record bill updates.
23. Create a WaterConsumer table and a Water_Log table. Create triggers to maintain consumer
history.
24. Create a Property table and a Property_Audit table. Write triggers to track property ownership
changes.
25. Create a PharmacyItem table and a Medicine_Log table. Create triggers to audit medicine stock
changes.
26. Create a BusPassenger table and a Passenger_Audit table. Write triggers to track passenger
record updates.
27. Create an EventRegistration table and an Event_Log table. Create triggers to record registration
changes.
28. Create a TrainingProgram table and a Program_History table. Write triggers to audit training
program updates.
29. Create a Payroll table and a Payroll_Log table. Create triggers to track payroll modifications.
30. Create a SalesRecord table and a Sales_Audit table. Write triggers to record sales transaction
changes.
31. Create a Project table and a Project_Log table. Create triggers to maintain project activity
history.
32. Create a Courier table and a Courier_Log table. Write triggers to track shipment updates.
33. Create a ClinicAppointment table and an Appointment_History table. Create triggers to record
appointment modifications.
34. Create a WarehouseItem table and an Inventory_Log table. Write triggers to audit stock changes.
35. Create an ECommerceProduct table and a Product_History table. Create triggers to record
product updates.
36. Create a Vendor table and a Vendor_Log table. Write triggers to maintain vendor history.
37. Create a Scholarship table and a Scholarship_Audit table. Create triggers to track scholarship
updates.
38. Create a HostelStudent table and a Hostel_Log table. Write triggers to record hostel allocation
changes.
39. Create a TourPackage table and a Package_History table. Create triggers to audit package
modifications.
40. Create a LibraryMember table and a Member_Log table. Write triggers to track membership
activities.
41. Create a BookSale table and a Sales_Log table. Create triggers to record sales updates.
42. Create a Laptop table and a Laptop_Audit table. Write triggers to maintain laptop inventory
history.
43. Create a SchoolAdmission table and an Admission_Log table. Create triggers to track admission
updates.
44. Create a VehicleRental table and a Rental_Log table. Write triggers to audit rental transactions.
45. Create an InsuranceClaim table and a Claim_History table. Create triggers to record claim
modifications.
46. Create a DoctorAppointment table and an Appointment_Log table. Write triggers to track
appointment changes.
47. Create an OnlineCourse table and a Course_History table. Create triggers to audit course
updates.
48. Create a MovieReview table and a Review_Log table. Write triggers to maintain review history.
49. Create a CustomerFeedback table and a Feedback_Log table. Create triggers to record feedback
modifications.
50. Create a ParkingSlot table and a Parking_Log table. Write triggers to audit parking allocation
changes.
51. Create a FlightBooking table and a Booking_History table. Create triggers to track booking
updates.
52. Create a LoanApplication table and a Loan_Log table. Write triggers to record loan application
changes.
53. Create a ResearchProject table and a Project_Audit table. Create triggers to maintain project
history.
54. Create a ConferenceParticipant table and a Conference_Log table. Write triggers to audit
participant updates.
55. Create an AgricultureProduct table and a Product_Log table. Create triggers to track agricultural
product modifications.
56. Create a PetRecord table and a Pet_History table. Write triggers to maintain pet record changes.
57. Create a JobApplicant table and an Applicant_Log table. Create triggers to record applicant
updates.
58. Create a RetailBill table and a Bill_Audit table. Write triggers to track billing modifications.
59. Create a MuseumVisitor table and a Visitor_Log table. Create triggers to record visitor
information changes.
60. Create a SportsEvent table and an Event_History table. Write INSERT, UPDATE, and DELETE
triggers to maintain a complete event activity log.
 EXPERIMENT : 9

Create View and Index for Database Tables with a Large Number of Records.

Different 60 Questions

1. Create a Student table with a large number of records. Create a view to display student details
and an index on the RollNo column.
2. Create an Employee table with thousands of records. Create a view for employee salary details
and an index on EmployeeID.
3. Create a LibraryBook table. Create a view for available books and an index on ISBN.
4. Create a Patient table. Create a view for patient information and an index on PatientID.
5. Create a Course table. Create a view for active courses and an index on CourseID.
6. Create a HotelReservation table. Create a view for confirmed reservations and an index on
ReservationID.
7. Create a BankAccount table. Create a view for account summaries and an index on
AccountNumber.
8. Create a Product table. Create a view for products in stock and an index on ProductID.
9. Create a Customer table. Create a view for customer information and an index on CustomerID.
10. Create a Vehicle table. Create a view for registered vehicles and an index on VehicleNumber.
11. Create a MovieTicket table. Create a view for booked tickets and an index on TicketID.
12. Create an OnlineOrder table. Create a view for completed orders and an index on OrderID.
13. Create a Supplier table. Create a view for supplier details and an index on SupplierID.
14. Create an InsurancePolicy table. Create a view for active policies and an index on
PolicyNumber.
15. Create an ExamResult table. Create a view showing students with distinction and an index on
StudentID.
16. Create a Faculty table. Create a view for faculty information and an index on FacultyID.
17. Create a SportsPlayer table. Create a view for player statistics and an index on PlayerID.
18. Create an AirlinePassenger table. Create a view for passenger information and an index on
PassengerID.
19. Create a MobilePhone table. Create a view for available mobiles and an index on MobileID.
20. Create a RestaurantMenu table. Create a view for menu items and an index on ItemID.
21. Create a GymMember table. Create a view for active members and an index on MemberID.
22. Create an ElectricityBill table. Create a view for unpaid bills and an index on ConsumerNumber.
23. Create a WaterConsumer table. Create a view for billing information and an index on
ConsumerID.
24. Create a Property table. Create a view for available properties and an index on PropertyID.
25. Create a PharmacyItem table. Create a view for medicines in stock and an index on MedicineID.
26. Create a BusPassenger table. Create a view for passenger details and an index on PassengerID.
27. Create an EventRegistration table. Create a view for registered participants and an index on
RegistrationID.
28. Create a TrainingProgram table. Create a view for ongoing programs and an index on
ProgramID.
29. Create a Payroll table. Create a view for employee salary reports and an index on EmployeeID.
30. Create a SalesRecord table. Create a view for monthly sales reports and an index on SalesID.
31. Create a Project table. Create a view for active projects and an index on ProjectID.
32. Create a Courier table. Create a view for shipment status and an index on TrackingNumber.
33. Create a ClinicAppointment table. Create a view for appointment schedules and an index on
AppointmentID.
34. Create a WarehouseItem table. Create a view for inventory stock and an index on ItemID.
35. Create an ECommerceProduct table. Create a view for available products and an index on
ProductID.
36. Create a Vendor table. Create a view for vendor information and an index on VendorID.
37. Create a Scholarship table. Create a view for scholarship recipients and an index on
ScholarshipID.
38. Create a HostelStudent table. Create a view for hostel resident information and an index on
StudentID.
39. Create a TourPackage table. Create a view for package details and an index on PackageID.
40. Create a LibraryMember table. Create a view for active members and an index on MemberID.
41. Create a BookSale table. Create a view for sales transactions and an index on SaleID.
42. Create a Laptop table. Create a view for available laptops and an index on LaptopID.
43. Create a SchoolAdmission table. Create a view for admitted students and an index on
AdmissionID.
44. Create a VehicleRental table. Create a view for rental transactions and an index on RentalID.
45. Create an InsuranceClaim table. Create a view for processed claims and an index on ClaimID.
46. Create a DoctorAppointment table. Create a view for appointment details and an index on
AppointmentID.
47. Create an OnlineCourse table. Create a view for enrolled students and an index on CourseID.
48. Create a MovieReview table. Create a view for movie ratings and an index on ReviewID.
49. Create a CustomerFeedback table. Create a view for customer feedback reports and an index on
FeedbackID.
50. Create a ParkingSlot table. Create a view for occupied parking slots and an index on SlotID.
51. Create a FlightBooking table. Create a view for booking information and an index on
BookingID.
52. Create a LoanApplication table. Create a view for approved loans and an index on LoanID.
53. Create a ResearchProject table. Create a view for ongoing research projects and an index on
ProjectID.
54. Create a ConferenceParticipant table. Create a view for participant details and an index on
ParticipantID.
55. Create an AgricultureProduct table. Create a view for agricultural inventory and an index on
ProductID.
56. Create a PetRecord table. Create a view for pet information and an index on PetID.
57. Create a JobApplicant table. Create a view for shortlisted applicants and an index on
ApplicantID.
58. Create a RetailBill table. Create a view for billing reports and an index on BillID.
59. Create a MuseumVisitor table. Create a view for visitor records and an index on VisitorID.
60. Create a SportsEvent table. Create a view for event details and an index on EventID.
 EXPERIMENT : 10

Create an XML Database and Validate it Using XML Schema

Different Practical Questions

1. Create an XML document to store Student Information (StudentID, Name, Department, Year,
CGPA). Design an XML Schema (XSD) and validate the XML document.
2. Create an XML document for Employee Records (EmployeeID, Name, Designation, Salary,
Department). Validate the XML using an XML Schema.
3. Create an XML database for Library Management containing BookID, Title, Author,
Publisher, and Price. Create an XSD and validate the XML document.
4. Create an XML document for Hospital Patient Records including PatientID, Name, Age,
Disease, and Doctor. Validate the XML using XML Schema.
5. Create an XML database for Course Registration containing CourseID, CourseName, Credits,
Faculty, and Semester. Validate it using XSD.
6. Create an XML document for Hotel Reservation Details including ReservationID,
CustomerName, RoomType, CheckInDate, and CheckOutDate. Create an XML Schema and
validate the document.
7. Create an XML database for Bank Account Information containing AccountNumber,
CustomerName, AccountType, Balance, and Branch. Validate the XML using XML Schema.
8. Create an XML document for Product Inventory Management containing ProductID,
ProductName, Category, Quantity, and Price. Validate it using XSD.
9. Create an XML database for Customer Details including CustomerID, Name, Address,
PhoneNumber, and Email. Create an XML Schema and validate the document.
10. Create an XML document for Online Order Processing containing OrderID, CustomerID,
ProductName, Quantity, and TotalAmount. Validate the XML using XML Schema.
11. Create an XML database for Flight Booking Information containing BookingID,
PassengerName, FlightNumber, Source, Destination, and Fare. Validate the XML document
using XSD.
12. Create an XML document for Insurance Policy Management containing PolicyID,
PolicyHolderName, PremiumAmount, PolicyType, and ExpiryDate. Create an XML Schema
and validate the XML document.
13. Create an XML database for Research Project Information containing ProjectID, ProjectTitle,
InvestigatorName, FundingAmount, and Duration. Validate it using XSD.
14. Create an XML document for Sports Event Management containing EventID, EventName,
Venue, Date, and NumberOfParticipants. Create an XML Schema and validate the document.
15. Create an XML database for University Examination Results containing RegisterNumber,
StudentName, SubjectCode, Marks, and Grade. Design an XML Schema and validate the XML
document.
 EXPERIMENT : 11

Create Document, Column and Graph Based Data Using NoSQL Database Tools

Different 15 Practical Questions

1. Create a Student Management System using Document, Column, and Graph databases to store
student records, academic performance, and student-department relationships.
2. Create an Employee Management System using NoSQL tools. Store employee profiles as
JSON documents, maintain payroll details in a column-oriented database, and represent
reporting hierarchy using a graph database.
3. Create a Library Management System using NoSQL databases. Store book information in
MongoDB, circulation records in Cassandra, and author-book relationships in Neo4j.
4. Create a Hospital Management System using NoSQL tools. Store patient details in a document
database, medical records in a column database, and doctor-patient relationships in a graph
database.
5. Create a Course Registration System using NoSQL databases. Store course information as
documents, student enrollments in a column database, and prerequisite relationships among
courses in a graph database.
6. Create a Customer Relationship Management System using NoSQL databases. Store
customer details as documents, communication records in a column database, and customer
interaction networks in a graph database.
7. Create a Movie Ticket Booking System using NoSQL databases. Store movie details as
documents, booking records in a column database, and customer-movie relationships in a graph
database.
8. Create an Online Shopping System using NoSQL tools. Store product and customer data in
MongoDB, order history in Cassandra, and recommendation relationships in Neo4j.
9. Create an Examination Result System using NoSQL databases. Store student profiles as
documents, marks and grades in a column database, and subject-student relationships in a graph
database.
10. Create a Sports Team Management System using NoSQL databases. Store player information
as documents, match statistics in a column database, and player-team relationships in a graph
database.
11. Create a Mobile Store Management System using NoSQL databases. Store mobile
specifications as documents, sales records in a column database, and brand-product relationships
in a graph database.
12. Create a Pharmacy Management System using NoSQL databases. Store medicine details as
documents, stock records in a column database, and supplier-medicine relationships in a graph
database.
13. Create a Payroll Management System using NoSQL databases. Store employee information as
documents, salary records in a column database, and reporting structures in a graph database.
14. Create an Event Registration System using NoSQL databases. Store event details as
documents, participant records in a column database, and participant-event relationships in a
graph database.
15. Create a Social Media Management System using Document, Column, and Graph databases. Store
user profiles as documents, post activities in a column database, and friendship/follower
relationships in a graph database.
 EXPERIMENT : 12

Develop a Simple GUI-Based Database Application and Incorporate All the Above-Mentioned
Features

Different Practical Questions:

1. Develop a Student Management System with a GUI to perform CRUD operations, constraints
validation, queries, joins, stored procedures, triggers, views, and reports.
2. Develop an Employee Management System with a GUI to manage employee records, salary
details, transactions, triggers, and report generation.
3. Develop a Library Management System with a GUI to manage books, members, issue/return
operations, joins, procedures, and views.
4. Develop a Hospital Management System with a GUI to manage patients, doctors,
appointments, billing, and database transactions.
5. Develop a Course Registration System with a GUI to manage courses, student enrollments,
queries, joins, and stored procedures.
6. Develop a Hotel Reservation System with a GUI to handle reservations, room allocation,
customer management, and transaction processing.
7. Develop a Banking Management System with a GUI to manage customer accounts, deposits,
withdrawals, fund transfers, and transaction control.
8. Develop a Product Inventory Management System with a GUI to manage products, suppliers,
stock updates, and reporting features.
9. Develop a Customer Relationship Management System with a GUI to manage customer
information, orders, feedback, and data analysis.
10. Develop a Vehicle Registration System with a GUI to manage vehicle records, owner
information, and database operations.
11. Develop a Movie Ticket Booking System with a GUI to manage movie schedules, bookings,
cancellations, and billing.
12. Develop an Online Shopping System with a GUI to manage products, customers, orders,
payments, and reports.
13. Develop a Supplier Management System with a GUI to manage supplier details, products
supplied, and purchase transactions.
14. Develop an Insurance Management System with a GUI to manage policies, policyholders,
claims, and premium calculations.
15. Develop an Examination Result Management System with a GUI to manage student records,
marks entry, grade calculation, and result reports.
 EXPERIMENT : 13

Case Study using any of the real life database applications from the following list

1. Inventory Management for a EMart Grocery Shop

2. Society Financial Management
3. Cop Friendly App – Eseva
4. Property Management – eMall
5. Star Small and Medium Banking and Finance
6. Hospital Management System
7. E-Commerce Order Processing System
8. Airline Reservation System
9. Hotel Reservation and Hospitality Management System
10. Logistics and Courier Tracking System
11. Online Food Delivery Management System
12. Manufacturing and Supply Chain Management System
13. Human Resource and Payroll Management System
14. Telecom Customer Relationship Management System
15. Online Learning Management System (LMS)
 Build Entity Model diagram. The diagram should align with the business and
functional goals stated in the application.
 Apply Normalization rules in designing the tables in scope.
 Prepared applicable views, triggers (for auditing purposes), functions for
enabling enterprise grade features.
 Build PL SQL / Stored Procedures for Complex Functionalities, ex EOD
Batch Processing for calculating the EMI for Gold Loan for each eligible
Customer.
 Ability to showcase ACID Properties with sample queries with appropriate settings