Jenil shah visaria - 2303051051010

‭PARUL UNIVERSITY‬
‭FACULTY OF ENGINEERING AND TECHNOLOGY‬
‭BACHELOR OF TECHNOLOGY‬

‭DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING‬

‭ YEAR/ 3 SEM‬
2
‭ BMS_(303105204)‬
D

‭Database Management System‬

‭LABORATORY MANUAL‬
 Jenil shah visaria - 2303051051010

‭CERTIFICATE‬

‭ his is to certify that‬

T
‭Mr/Ms. Jenil shah visaria with enrollment no.
2303051051010 ‭has successfully completed his/her‬‭laboratory‬
‭experiments in the subject‬‭DBMS - Sem 3(303105204)‬ ‭from‬
‭the department of‬‭Computer Science & Engineering‬‭during‬‭the‬
‭academic year‬‭2024-25‬‭.‬

‭Date of Submission:__________ Staff In charge:________‬

 Jenil shah visaria - 2303051051010

‭PRACTICAL-1‬

‭ IM:‬
A
‭1-What is DBMS?‬
‭2-What are the applications of DBMS?‬
‭3-Create Student Details with Microsoft Excel.‬

1‭ -What is DBMS?‬
‭A Database Management System(DBMS) is a software system that is‬
‭designed to manage and organize data in a structured manner. It allows‬
‭users to create, modify, and query a database, as well as manage the‬
‭security and access controls for that database.‬

2‭ -What are the applications of DBMS?‬

‭Data Retrieval :‬‭to retrieve data quickly and easily‬‭using search queries.‬
‭Data Manipulation :‬‭provide tools to manipulate data‬‭such as sorting ,‬
‭filtering , and aggregating data.‬
‭Security :‬‭provides security features to ensure that‬‭only authorized users‬
‭have access to the data.‬
‭Data Backup and Recovery :‬‭provides tools to backup‬‭data and recover‬
‭it in case of system failures and data loss.‬
‭Multiuser Access :‬‭allows multiple users to access‬‭and modify the data‬
‭simultaneously.‬
‭Reporting & Analysis :‬‭provides tools to generate‬‭reports and analyze‬
‭data to gain insights and make informed decisions.‬
 Jenil shah visaria - 2303051051010

‭3-Create Student Details with Microsoft Excel.‬

 Jenil shah visaria - 2303051051010

‭PRACTICAL-2‬

‭AIM : Creating Tables‬

‭Table 1 - Employee‬

‭ reate table Employee‬

C
‭(‬
‭Employee Name varchar(255),Street varchar(255),City varchar(255)‬
‭);‬
‭Insert Into Employee Values‬
‭('Adam','Spring','Pittsfield'),‬
‭('Brooks','Senator','Brooklyn'),‬
‭('Curry','North','Rye'),‬
‭('Demalo','SunShine','San Deago');‬
‭SELECT * FROM Employee;‬
 Jenil shah visaria - 2303051051010

‭Table 2 - Work‬

‭ reate table Work‬

C
‭(‬
‭EmployeeName varchar(255),CompanyName varchar(255),Salary int‬
‭);‬
‭Insert Into Work Values‬
‭('Adam','FBC','20000'),‬
‭('Brooks','MBC','30000'),‬
‭('Curry','SBC','10000');‬
‭SELECT * FROM Work;‬

‭Table 3 - Company‬

‭ reate table Company‬

C
‭(‬
‭CompanyName varchar(255),City varchar(255)‬
‭);‬
‭Insert Into Company Values‬
‭('FBC','Pittsfield'),‬
‭('MBC','Brooklyn'),‬
‭('SBC','Rye');‬
‭SELECT * FROM Company;‬
 Jenil shah visaria - 2303051051010

‭Table 4 - Manager‬

‭ reate table Manager‬

C
‭(‬
‭EmployeeName varchar(255),ManagerName varchar(255)‬
‭);‬
‭Insert Into Manager Values‬
‭('Adam','Smith'),‬
‭('Brooks','Jones'),‬
‭('Curry','Hayes');‬
‭SELECT * FROM Manager;‬

‭Table 5 - Sailors‬

‭ reate table Sailors‬

C
‭(‬
‭Sid int,Sname varchar,Rating int,Age int‬
‭);‬
‭Insert Into Sailors Values‬
‭('22','Dustin','7','45.0'),‬
‭('29','Brutus','1','33.0'),‬
‭('31','Lubber','8','55.5'),‬
‭('32','Andy','8','25.5'),‬
 Jenil shah visaria - 2303051051010

(‭ '58','Rusty','10','35.0'),‬
‭('64','Horatio','7','35.0'),‬
‭('71','Zobra','10','16.0'),‬
‭('74','Horatio','9','35.0'),‬
‭('85','Art','3','25.5'),‬
‭('95','Bob','3','63.5');‬
‭SELECT * FROM Sailors;‬

‭Table 6 - Reserves‬

‭ reate table Reserves‬

C
‭(‬
‭Sid int,Bid int,Day date‬
‭);‬
‭Insert Into Reserves Values‬
‭('22','101','10-oct-98'),‬
‭('22','102','10-oct-98'),‬
‭('22','103','10-aug-98'),‬
 Jenil shah visaria - 2303051051010

(‭ '22','104','10-jul-98'),‬
‭('31','102','11-oct-98'),‬
‭('31','103','11-jun-98'),‬
‭('31','104','11-dec-98'),‬
‭('64','101','9-may-98'),‬
‭('64','102','9-aug-98'),‬
‭('74','103','9-aug-98');‬
‭SELECT*FROM Reserves;‬

‭Table 7 - Boats‬

‭ reate table Boats‬

C
‭(‬
‭Bid int,Bname varchar,Color varchar‬
‭);‬
‭Insert Into Boats Values‬
‭('101','Interlake','Blue'),‬
‭('102','Interlake','Red'),‬
‭('103','Clipper','Green'),‬
 Jenil shah visaria - 2303051051010

(‭ '104','Marine','Red');‬
‭SELECT*FROM Boats;‬

‭Table 8 - Client‬

‭ reate table Client‬

C
‭(‬
‭ClientNo varchar,Name varchar,City varchar,Pincode int,State‬
‭varchar,BalanceDue int‬
‭);‬
‭Insert Into Client Values‬
‭('C0001','Ivan Bayross','Mumbai','400054','Maharashtra','15000'),‬
‭('C0002','Mamta Muzumdar','Madras','780001','Tamil Nadu','100'),‬
‭('C0003','Chhaya Bankar','Mumbai','400057','Maharashtra','5000'),‬
‭('C0004','Ashwini Joshi','Banglore','560001','Karnataka','500'),‬
‭('C0005','Hansel Colaco','Mumbai','400060','Maharashtra','2000'),‬
‭('C0006','Deepak Sharma','Mangalore','560050','Karnataka','1000');‬
‭SELECT*FROM Client;‬
 Jenil shah visaria - 2303051051010

‭Table 9 - Product‬

‭ reate table Product‬

C
‭(‬
‭ProductNo varchar,Description varchar,Profit int,Unit varchar,Quantity‬
‭int,ReorderLevel int,SellPrice int,CostPrice int‬
‭);‬
‭Insert Into Product Values‬
‭('P00001','T-Shirts','5','Piece','200','50','350','250'),‬
‭('P00345','Shirts','6','Piece','150','50','500','350'),‬
‭('P06734','Cotton Jeans','5','Piece','100','20','600','450'),‬
‭('P07865','Jeans','5','Piece','100','20','750','500'),‬
‭('P07868','Trousers','2','Piece','150','50','850','550'),‬
‭('P07885','Pull Overs','3','Piece','80','30','700','450'),‬
‭('P07965','Denim Shirts','4','Piece','100','40','350','250'),‬
‭('P07975','Lycra Tops','5','Piece','70','30','300','175'),‬
‭('P08865','Skirts','5','Piece','75','30','450','300');‬
‭SELECT*FROM Product;‬
 Jenil shah visaria - 2303051051010

‭Table 10 - Salesman‬

‭ reate table Salesman‬

C
‭(‬
‭Sl_No varchar,Name varchar,Address1 varchar,Address2 varchar,City‬
‭varchar,Pincode varchar,State varchar,Amount int,Target int,Sales‬
‭int,Rem varchar‬
‭);‬
‭Insert Into Salesman Values‬
‭('S00001','Aman','A/14','Worli','Mumbai','400002','Maharashtra','3000','1‬
‭00','50','Good'),‬
‭('S00002','Omkar','65','Nariman','Mumbai','400001','Maharashtra','3000','‬
‭200','100','Good'),‬
‭('S00003','Raj','P-7','Bandra','Mumbai','400032','Maharashtra','3000','200'‬
‭,'100','Good'),‬
‭('S00004','Ashish','A/5','Juhu','Mumbai','400044','Maharashtra','3500','20‬
‭0','150','Good');‬
‭SELECT*FROM Salesman;‬
 Jenil shah visaria - 2303051051010

‭Table 11 - Salesorder‬

‭ reate table Salesorder‬

C
‭(‬
‭Od_No varchar,Cl_No varchar,Od_date date,Sl_No varchar,D_Type‬
‭varchar,Bill varchar,Dlvr_date date,Status varchar‬
‭);‬
‭Insert Into Salesorder Values‬
‭('O19001','C00001','12-June-04','S00001','F','N','20-July-04','In Process'),‬
‭('O19002','C00002','25-June-04','S00002','P','N','20-July-04','Cancelled'),‬
‭('O46865','C00003','18-Feb-04','S00003','F','Y','20-Feb-04','Fulfilled'),‬
‭('O19003','C00001','03-April-04','S00001','F','Y','07-April-04','Fulfilled')‬
‭,‬
‭('O46866','C00004','20-May-04','S00002','P','N','22-May-04','Cancelled')‬
‭,‬
‭('O19008','C00005','24-May-04','S00004','F','N','26-July-04','In‬
‭Process');‬
‭SELECT*FROM Salesorder;‬

‭Table 12 - Deposit‬

‭ reate table Deposit‬

C
‭(‬
‭Act_No varchar,Cname varchar,Bname varchar,Amount float,Day date‬
‭);‬
 Jenil shah visaria - 2303051051010

I‭ nsert Into Deposit Values‬

‭('100','Anil','VRCE','1000.00','01-March-95'),‬
‭('101','Sunil','AJNI','5000.00','04-Jan-96'),‬
‭('102','Mehul','KAROLBAGH','3500.00','17-Nov-95'),‬
‭('104','Madhuri','CHANDI','1200.00','17-Dec-95'),‬
‭('105','Pramod','M.G.ROAD','3000.00','27-March-96'),‬
‭('106','Sandip','ANDHERI','2000.00','31-March-96'),‬
‭('107','Shivani','VIRAR','1000.00','05-Sept-95'),‬
‭('108','Kranti','NEHRU PLACE','5000.00','02-July-95'),‬
‭('109','Minu','POWAI','7000.00','10-Aug-95');‬
‭SELECT*FROM Deposit;‬

‭Table 13 - Borrow‬

‭ reate table Borrow‬

C
‭(‬
‭Loan_No int,Cname varchar,Bname varchar,Amount float‬
‭);‬
‭Insert Into Borrow Values‬
‭('201','Anil','VRCE','1000.00'),‬
‭('206','Mehul','AJNI','5000.00'),‬
‭('311','Sunil','DHARAMPETH','3000.00'),‬
‭('321','Madhuri','ANDHERI','2000.00'),‬
 Jenil shah visaria - 2303051051010

(‭ '375','Pramod','VIRAR','8000.00'),‬
‭('481','Kranti','NEHRU PLACE','3000.00');‬
‭SELECT*FROM Borrow;‬

‭Table 14 - Branch‬

‭ reate table Branch‬

C
‭(‬
‭BranchName varchar,City varchar‬
‭);‬
‭Insert Into Branch Values‬
‭('VRCE','NAGPUR'),‬
‭('AJNI','NAGPUR'),‬
‭('KAROLBAGH','DELHI'),‬
‭('CHANDI','DELHI'),‬
‭('DHARAMPETH','NAGPUR'),‬
‭('M.G.ROAD','BANGLORE'),‬
‭('ANDHERI','MUMBAI'),‬
‭('VIRAR','MUMBAI'),‬
‭('NEHRU PLACE','DELHI'),‬
‭('POWAI','MUMBAI');‬
‭SELECT*FROM Branch;‬
 Jenil shah visaria - 2303051051010

‭Table 15 - Customers‬

‭ reate table Customers‬

C
‭(‬
‭CustomerName varchar,City varchar‬
‭);‬
‭Insert Into Customers Values‬
‭('ANIL','KOLKATA'),‬
‭('SUNIL','DELHI'),‬
‭('MEHUL','VADODARA'),‬
‭('MANDAR','PATNA'),‬
‭('MADHURI','NAGPUR'),‬
‭('PRAMOD','NAGPUR'),‬
‭('SANDIP','SURAT'),‬
‭('SHIVANI','MUMBAI'),‬
‭('KRANTI','MUMBAI'),‬
‭('NAREN','MUMBAI');‬
‭SELECT*FROM Customers;‬
Jenil shah visaria - 2303051051010