Laboratory Manual
DATABASE MANAGEMENT SYSTEM
(303105204)
Submitted by:
Name: Rahul Mehta
Enroll. No.: 2303051240011
Division: 3A1
Roll No.: 22
Parul University
FACULTY OF ENGINEERING & TECHNOLOGY
BACHELOR OF TECHNOLOGY
COMPUTER SCIENCE AND ENGINEERING DEPARTMENT
CERTIFICATE
This is to certify that Mr. Rahul Mehta with Enrollment No. 2303051240011
has successfully completed his laboratory practicals in the Database Management System (303105204)
from the Department of Computer Science & Engineering during the academic year 2024-2025.
INDEX
1. Practical 1: What is Normalization? Explain its types and advantages.
2. Practical 2: Create a Database for Customer Details using MS Access.
3. Practical 3: Perform various SQL queries on the Employee and Customers table.
4. Practical 4: Create complex queries involving Joins.
5. Practical 5: Write queries to retrieve data using aggregate functions.
Practical 1: Normalization
Normalization is the process of organizing data in a database to avoid data redundancy, insertion
anomaly, update anomaly & deletion anomaly. It helps in breaking down larger tables into smaller tables
while ensuring the relationships among the data.
Types of Normalization:
1. First Normal Form (1NF)
2. Second Normal Form (2NF)
3. Third Normal Form (3NF)
4. Boyce-Codd Normal Form (BCNF)
Practical 2: Customer Details Database
Create a Customer Details table using MS Access with the following columns:
1. Customer_ID (Primary Key)
2. Name (Text)
3. Address (Text)
4. Phone (Number)
Practical 3: SQL Queries on Employee and Customer Tables
1. Retrieve all details from the Employee table where the city is 'Mumbai'.
Query: SELECT * FROM Employee WHERE city = 'Mumbai';
2. Display customer names whose balance is greater than 5000.
Query: SELECT Name FROM Customer WHERE balance > 5000;
Practical 4: Complex Queries with Joins
Write SQL queries to perform joins between the Employee and Department tables. Example query:
SELECT Employee.Name, Department.Department_Name FROM Employee INNER JOIN Department
ON Employee.Dept_ID = Department.Dept_ID;
Practical 5: SQL Aggregate Functions
Write queries to calculate the sum, average, and count of specific columns in the Customer table:
1. Calculate the total balance: SELECT SUM(balance) FROM Customer;
2. Calculate the average balance: SELECT AVG(balance) FROM Customer;
3. Count the number of customers: SELECT COUNT(*) FROM Customer;
