BACHELOR OF BUSINESS ADMINISTRATION
INFORMATION MANAGEMENT SYSTEM LAB
(BBA- 212)
PRACTICAL FILE
BATCH: 2019-2022
-
Submitted By: Submitted To:
Name: Dheeraj Ms. Saba Hussain
Enrollment No.: 00120601719 Designation:
BBA 4thSemester Section-A/ 1st Shift Assistant Professor
Trinity Institute of Professional Studies
Affiliated To Guru Gobind Singh Indraprastha University, New Delhi
I
DECLARATION
I hereby declare that the following documented project report on
"Information Systems Management" is an original and authentic work
done by me for the partial fulfilment of Bachelor of Business
Administration degree program.
I hereby declare that the entire endeavour put in the fulfilment of the
task are genuine and original to the best of my knowledge & I have
not submitted it earlier elsewhere.
Student’s Sign Supervisor’s Sign
__________ ___________
DHEERAJ MS. SABA HUSSAIN
BBA (G) (ASSISTANT PROFESSOR)
00120601719
4th Sem Sec-A / 1st shift
II
CERTIFICATE
TO WHOM IT MAY CONCERN
This is to certify that the project work of "Information Systems
Management" made by Dheeraj, B.B.A 4TH Semester Section-A/ 1st
Shift, (00120601719) is an authentic work carried out by her under
the guidance and supervision of Ms. Saba Hussain.
The project report submitted has been found satisfactory for the partial
fulfilment for the degree of Bachelor of Business Administration.
Student’s Sign Supervisor’s Sign
____________ ______________
DHEERAJ MS. SABA HUSSAIN
III
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 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 "Ms. Saba Hussain" 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 and understanding of
the project.
Name: DHEERAJ
Enrollment No.: 00120601719
BBA, 4th Sem Sec-A
1st Shift
IV
INDEX
S. TOPIC Page Teacher’s
No. No. Sign
1. Create table student with columns Rollno, 1
Name, Subject, Marks.
2. Describe the table Student. 1
3. Insert ten records in the student table. 2
4. Display the details of all the students. 2
5. Display the details of students whose marks 3
are greater than 70.
6. Display the details of students whose subject 3
is ‘English’.
7. Display the details of students whose name 4
starts with ‘S’.
8. Display the details of students whose marks 4
are between 70 to 90.
9. Display the details of students whose marks 5
are either 50 or 49.
10. Display the details of students whose subject 5
is either ‘English’ or ‘Maths’.
11. Update the marks of the student to 90 whose 6
Rollno is 3.
12. Delete the column whose name is Marks. 6
13. Add a column whose name is ‘Mobile No’ 7
and datatype is ‘int’.
14. Modify the datatype of column whose name 7
is Subject to char (20).
15. Modify the table name to Student Details. 8
V
Question 1. Create table student with columns Rollno, Name, Subject, Marks.
Question 2. Describe the table Student.
1
2
Question 3. Insert ten records in the student table.
Question 4. Display the details of all the students.
3
Question 5. Display the details of students whose marks are greater than 70.
Question 6. Display the details of students whose subject is ‘English’.
4
Question 7. Display the details of students whose name starts with ‘S’.
Question 8. Display the details of students whose marks are between 70 to
90.
5
Question 9. Display the details of students whose marks are either 50 or 49.
Question 10. Display the details of students whose subject is either ‘English’
or ‘Maths’.
6
Question 11. Update the marks of the student to 90 whose Rollno is 3.
Question 12. Delete the column whose name is Marks.
7
Question 13. Add a column whose name is ‘Mobile No’ and datatype is ‘int’.
Question 14. Modify the datatype of column whose name is Subject to char
(20).
8
Question 15. Modify the table name to Student Details
