Trinity Institute of Professional Studies

Affiliated To Guru Gobind Singh Indraprastha University

SECTOR 16-C, DWARKA, NEW DELHI

INFORMATION SYSTEM MANAGEMENT LAB

------------------------------------------------------------------------------
PRACTICAL FILE
-----------------------------------------------------------------------------------------------

SUBMITTED BY: SUBMITTED TO:

Name of Student: Lalit Rawat Name of Faculty: Dr. SANDHAYA

Enrollment No. : 10120601721 Designation: Deputy Director
Course: BBA
Semester: 5th
Shift: 1st Year: 3rd
 TO WHOM SO EVER IT MAY CONCERN

This is to certify that the project work “INFORMATION SYSTEM LAB FILE”
made by Lalit Rawat, BBA (g), 5TH SEM, 10120601721 is an authentic work
carried out by him/her under guidance and supervision of Dr. Sandhaya.

The project report submitted has been found satisfactory for the partial
fulfilment of the degree of bachelors of business administration.

PROJECT SUPERVISOR
Dr. Sandhaya
 DECLARATION

I hereby declare that the following documented project file on “Information

System Management” is an original and authentic work done by me for the
partial fulfilment of Bachelor of Business Administration (general) degree
program.

I hereby declare that all the endeavour put in the fulfilment of the task is
genuine and original to the best of my knowledge & I have not submitted it
earlier elsewhere.

SIGNATURE:
Lalit Rawat
BBA(G)
SEMESTER – 5th
SHIFT – 1st
 ACKNOWLEDGEMENT

It is in particular that I am acknowledging my sincere feeling towards my

mentors who graciously gave me their time and expertise.

They have provided me with the valuable guidance sustained and friendly
approach otherwise it would have been difficult to achieve the results in such a
short span of time without their help.

I deem it my duty to record my gratitude towards my internal project

supervisor Dr. Sandhaya who devoted her precious time to interact, guide, and
gave me the right approach to accomplish the task and also helped me to
enhance my knowledge understanding of the project.

Lalit Rawat
BBA(G)
SEMESTER- 5th
SHIFT- 1st
 INDEX

S.NO. TOPIC Teacher’s Signature

PRACTICAL-1

1. Create table student with column, roll

no, name, subject, marks.
2. Describe the table student.
3. Insert ten records in the student table.
4. Display the details of all the student.
5. Display the details of students whose
marks is greater than 90.
6. Display the details of students whose
subject is ISM.
7. Display the details of students whose
name starts with B.
8. Display the details of students whose
marks are between 80-90.
9. Display the details of students whose
marks are either 94 or 85.
10. Display the details of students
whose subject is either English
or Maths.

PRACTICAL-2

1. Create table student with column, roll

no., name, subject, marks.
2. Insert 5 records in the Student table.
3. Update the marks of the student to 60
whose roll no is 3.
4. Delete the column whose name is
Marks.
5. Add a column whose name is Mobile
no. and datatype is ‘int’.
6. Modify the datatype of column
whose name is subject to char (20).
7. Modify the table name to Student’s
Details.

PRACTICAL-3

1. Create a table students with column

no, name, subject, marks.
2. Find the average marks group by
subjects

3. Find the maximum marks group by

subjects

4. Find the minimum marks group by

subjects

5. Find the sum of marks group by

subjects

6. Find the total count of marks

group by subjects
 PRACTICAL-4

1. Create table ‘bakery’ with any

no. Of columns.

2. Describe the table

3. Display the details of all

the items in the table
4. Display the details of all the
items whose item Qty is greater
than 200
5. Display the details of all the
items whose item name is ‘bread’

6. Display the details of all the

items whose item name starts
with ‘b’
7. Display the details of all the
items whose price is either 10000
or 12000
8. Display the details of all the
items whose item whose price is
between 5000 and 15000
9. Display the details of all the
items whose item name is ‘milk’
or ‘ice cream’
10. Update the price of the item to
9000 whose item number is 1.
11. Delete the record of item
whose item no. Is 5.

12. Add a column name

‘supplier_no.’ and datatype ‘int.’

13. Delete the column whose name is

‘supplier_no.’

14. Modify the datatype of

column whose name is
item_name to char(30).
15. Modify the table name to
Bakeryproducts.

16. Find the average price and group

by item_supplier.

17. Find the maximum price and

group by item_supplier.

18. Find the minimum price and

group by item_supplier.

19. Find the sum of price and group

by item_supplier.

20. Find the count of price and group

by item_supplier.
 INTRODUCION TO SQL

SQL is a language to operate databases; it includes database creation, deletion,

fetching rows, modifying rows, etc. SQL is an ANSI (American National
Standards Institute) standard language, but there are many different versions of
the SQL language.

What is SQL?
SQL is Structured Query Language, which is a computer language for storing,
manipulating and retrieving data stored in a relational database.
SQL is the standard language for Relational Database System. All the
Relational Database Management Systems (RDBMS) like MySQL, MS
Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their
standard database language.

Why SQL?
SQL is widely popular because it offers the following advantages −
 Allows users to access data in the relational database management
systems.
 Allows users to describe the data.
 Allows users to define the data in a database and manipulate that data.
 Allows to embed within other languages using SQL modules, libraries &
pre-compilers.
 Allows users to create and drop databases and tables.
 Allows users to create view, stored procedure, functions in a database.
 Allows users to set permissions on tables, procedures and views.

A Brief History of SQL

 1970 − Dr. Edgar F. "Ted" Codd of IBM is known as the father of
relational databases. He described a relational model for databases.
 1974 − Structured Query Language appeared.
 1978 − IBM worked to develop Codd's ideas and released a product
named System/R.
  1986 − IBM developed the first prototype of relational database and
standardized by ANSI. The first relational database was released by
Relational Software which later came to be known as Oracle.

SQL Commands
The standard SQL commands to interact with relational databases are
CREATE, SELECT, INSERT, UPDATE, DELETE and DROP. These
commands can be classified into the following groups based on their nature −

DDL - Data Definition Language

Sr.No. Command & Description

CREATE
Creates a new table, a view of a table, or other object in
1
the database.

ALTER
Modifies an existing database object, such as a table.
2

DROP
Deletes an entire table, a view of a table or other objects in
3 the database.
DML - Data Manipulation Language

Sr.No. Command & Description

1 SELECT
Retrieves certain records from one or more tables.

INSERT
2
Creates a record.

UPDATE
3
Modifies records.

DELETE
4
Deletes records.

DCL - Data Control Language

Sr.No. Command & Description

1 GRANT
Gives a privilege to user.

REVOKE
2
Takes back privileges granted from user.
 PRACTICAL-1
Ques1- Create table student with column, roll no., name, subject,
marks.

Ques2 - Describe the table student.

Ques3- Insert ten records in the student table

.
Ques4-Display the details of all the student.

Ques5- Display the details of students whose marks is greater than

90.
Ques6- Display the details of students whose subject is ISM.

Ques7- Display the details of students whose name starts with ‘b’

Ques8- Display the details of students whose marks are between 80-
90.
Ques9-Display the details of students whose marks are either 94 or
85.

Ques10- Display the details of students whose subject is either

English or Maths.
 PRACTICAL-2

Ques1- Create table student with columns, roll no, name, subject,
marks.

Ques2- Insert five records in the student table.

Ques3- Update the marks of the student to 60 whose roll no is 3.
\

Ques 4- Delete the column whose name is marks.

Ques 5- Add a column whose name is mobile number and data type
is integer

Ques 6- Modify the data type of column whose name is subject

tchar(20)
Ques 7- Modify the table name to student details.
 PRACTICAL-3

Ques 1- Create a table student with column no, name, subject,

marks.
Ques 2-Find the average marks group by subjects.

Ques 3- Find the maximum marks group by subjects

Ques 4-Find the minimum marks group by subjects.

Ques 6- Find the sum of marks group by subjects

Ques 7- Find the total count of marks group by subjects
 PRACTICAL-4

Ques 1 Create table ‘bakery’ with any no. Of columns

Ques2 Describe the table

Ques3- Display the details of all the items in the table

Ques4 Display the details of all the items whose item Qty is
greater than 200
Ques5 Display the details of all the items whose item name
is ‘bread’

Ques6 Display the details of all the items whose item name
starts with ‘b’

Ques7 Display the details of all the items whose price is either
10000 or 12000

Ques8 Display the details of all the items whose item whose
price is between 5000 and 15000
Ques9 Display the details of all the items whose item name
is ‘milk’ or ‘ice cream’.

Ques10 Update the price of the item to 9000 whose item

number is 1.

Ques11 Delete the record of item whose item no. Is 5.

Ques12 Add a column name ‘supplier_no.’ and datatype ‘int.’

Ques13 Delete the column whose name is ‘supplier_no.’

Ques14 Modify the datatype of column whose name is

item_name to char(30).
Ques15 Modify the table name to ‘Bakeryproducts’.

Ques16 Find the average price and group by item_supplier.

Ques17 Find the maximum price and group by item_supplier.

Ques18 Find the minimum price and group by item_supplier.

Ques19 Find the sum of price and group by item supplier.

Ques20 Find the count of price and group by item supplier.