DBMS Practical Slips (1–28) – Complete Slip Wise Questions for BCA

Are you preparing for your DBMS Practical Exam (BCA / B.Com / Computer Science)?

Here is the complete DBMS practical slip-wise question list, arranged clearly for quick revision and exam preparation.

These slips cover:

• Database Design in 3NF
• SQL (DDL, DML, DQL)
• Primary & Foreign Key Constraints
• Check Constraints
• One-to-Many & Many-to-Many Relationships
• SQL Queries (Update, Delete, Select, Group By, etc.)

Save this page for last-minute DBMS practical exam revision.

Slip 1

1. Consider the following entities and relationships. Create a relational database in 3NF with appropriate data types and constraints: Emp(eno, ename, designation, salary, Date_Of_Joining)
   Dept(dno, dname, loc) Relationship: One-to-Many between Dept and Emp.
   Constraints:
   • Primary Keys
   • ename NOT NULL
   • salary > 0
2. Execute SQL queries:
   • Delete sales order details of client whose name is “Patil” and order date is “09/08/2019”.
   • Change order date of client_no ‘CN001’ to ‘18/03/2019’.
   • Delete all sales_order records where order date is before ‘10/02/2018’.
   • Display date-wise sales orders given by clients.
   • Update address of client to “Pimpri” whose name is ‘Mr. Roy’.

Slip 3

1. Create a relational database in 3NF for: Hospital(hno, hname, city, est_year, addr)
   Doctor(dno, dname, addr, speciality, hno) Relationship: One-to-Many between Hospital and Doctor.
   Constraint: est_year > 1990.
2. Write SQL queries to:
   • Display required details from tables.
   • Delete records with given conditions.
   • Count records category-wise.
   • Display specific attributes with constraints.

Slip 5

1. Create relational database in 3NF: Customer(cust_no, cust_name, address, city)
   Loan(loan_no, loan_amt) Relationship: Many-to-Many.
   Constraint: loan_amt > 0.
2. Create relational database in 3NF: Project(pno, pname, start_date, budget, status)
   Department(dno, dname, HOD, loc, pno) Relationship: Many-to-One.
   Add appropriate primary key and check constraints.
3. Execute SQL queries:
   • Drop columns
   • Sort records
   • Display records using conditions

Slip 9

1. Create a relational database in 3NF for given entities with appropriate constraints and relationships.
2. Execute SQL queries:
   • Update records
   • Delete records
   • Display records using multiple conditions

Slip 10

1. Create relational database in 3NF: Employee(emp_no, name, skill, payrate)
   Position(posting_no, skill) Relationship: Many-to-Many.
   Constraint: payrate > 0.
2. Write SQL queries to:
   • Display employee skills
   • Update payrate
   • Display employees based on criteria
   • Modify postings

Slip 11

1. Create relational database in 3NF: Bill(bno, day, tableno, total)
   Menu(dish_no, dish_desc, price) Relationship: Many-to-Many with quantity as descriptive attribute.
   Constraint: price > 0.
2. Write SQL queries to:
   • Display table numbers with specific dish description
   • Display special menu items
   • Group receipts and totals
   • Count number of menus
   • Filter records using price range

Slip 12

1. Create relational database schema: Movie, Actor, Producer Relationship: Many-to-Many.
   Add constraints such as:
   • Release year validation
   • Budget validation
   • Address constraints
2. Write SQL queries to:
   • List movies by budget
   • Display producer details
   • Show movies produced by more than one producer
   • Display actor details based on conditions

Slip 13

1. Design a database in 3NF with the following entities:
   Account (ano, branchname, balance)
   Customer (cust_no, cust_name, street, city)
   Relationship: Many-to-Many between Account and Customer.
2. Write SQL queries to display customer details with balance between 1000000 and 2000000, display customers having more than two accounts in Chinchwad branch, delete accounts whose balance is less than 500, select names of customers whose street contains “road” and city is Mumbai, and find number of depositors for each branch.

Slip 14

1. Design a database in 3NF with entities:
   Branch (bname, bcity, assets)
   Loan (loan_no, amount)
   Project (pno, name, budget)
   Employee working on projects with Many-to-Many relationship.
2. Write SQL queries to list employees and departments having salary greater than 50000, list employees who work with Ramesh on same project, find employees working on projects with budget greater than 300000, list departments having at least two projects, and update budget of projects done by Computer Department employees by 15 percent.

Slip 16

1. Design a database in 3NF with:
   Branch (bno, bname, bcity, assets)
   Account (acc_no, balance)
   One-to-Many relationship between Branch and Account.
2. Write SQL queries to find maximum account balance of each branch, find branches where average account balance is more than 30000, find route details for buses with capacity 20, display number of stations between Chinchwad and Katraj, display routes with more than three buses, count buses from Swargate to Hadapsar, and find bus with maximum capacity from Nigadi to Kothrud.

Slip 19

1. Design a database in 3NF with:
   Person (driver_id, driver_name, address)
   Car (license_no, model, year)
   Many-to-Many relationship with date and time as attribute.
2. Write SQL queries to display details of persons driving Alto cars, count cars driven by each driver, display car details manufactured before year 2000, show on which day Mr. Ram drives maximum cars, and display total number of persons driving cars each year.

Slip 20

1. Design a database in 3NF with:
   Person (pno, person_name, birthdate, income)
   Area (area_name, area_type)
   Many-to-One relationship.
2. Write SQL queries to display persons with income less than 100000 in PCMC area, display population of each area, display persons from Urban area, display area details having population greater than Pune, and display person details with minimum income.

Slip 21

1. Design a database in 3NF with:
   Book (book_no, book_name, price)
   Publisher (pno, pname, city)
   Many-to-Many relationship with descriptive attribute.
2. Write SQL queries to display total quantity of each book, display publishers from Pune, and display publishers publishing more than two books.

Slip 23

1. Design a database in 3NF with:
   Plan (plan_no, plan_name, nooffreecalls, freecalltime, fix_amt)
   Customer (cust_no, cust_name, mobile_no)
   One-to-Many relationship.
2. Write SQL queries to display plan with minimum freecalltime, display customers whose mobile number starts with 98, display customer details getting less free calls than plan “Let’s Rock”, delete details of customer John who stopped Go Max plan, and find plans with fixed amount greater than 5000.

Slip 24

1. Design a database in 3NF with:
   Employee (emp_id, emp_name, address)
   Investment (inv_no, inv_name, inv_date, inv_amount)
   One-to-Many relationship.
2. Write SQL queries to display employee details with investment greater than 100000, display total investment amount by each employee, and display employees who invested on 2nd January 2013.

Slip 28

1. Design a database in 3NF with:
   Wholesaler (w_no, w_name, address, city)
   Product (product_no, product_name, rate)
   Many-to-Many relationship with quantity attribute.
2. Write SQL queries to display wholesalers from Pune supplying Monitor, display total wholesalers of each product, display wholesalers supplying Keyboard at maximum price, display total quantity of product sold by Mr. Khabia, and decrement rate of all products by 5 percent supplied by wholesalers from Pune.