RALLI
INTERNATIONAL
SCHOOL
SESSION – 2023-24
INFORMATION TECHNOLOGY
SUBJECT CODE - 402
PROJECT WORK
By – ANIRUDH KASANA (X - C)
ACKNOWLEDGEMENT
I would like to express my special thanks
of gratitude to my teacher – Ms.
Sandeep Kaur who gave me the
opportunity to prepare this Practical File
and doing a lot of research. I would also
like to extend my gratitude to Principal -
Ms. Neha Ralli for providing me with all
the facilities that were required.
Project Work
Database Creation:
● Database Name: SCHOOL
● Open OpenOffice Base and create a new database named "SCHOOL."
Table Creation - STUDENT:
● Open OpenOffice Base and create a new database named "SCHOOL."
● Navigate to the "Tables" tab and select "Create Table in Design View."
● Define the fields for the "STUDENT" table as follows:
● Field Name: Admno
● Data Type: TINYINT
● Field Properties: Primary Key
● Field Name: Name
● Data Type: Text
● Field Size: 25
● Field Name: Address
● Data Type: Text
● Field Size: 30
● Field Name: Class
● Data Type: Text
● Field Size: 15
● Field Name: Sec
● Data Type: Text
● Field Size: 3
● Field Name: DOB
● Data Type: Date
● Field Name: StreamID
● Data Type: TINYINT
● Field Properties: Foreign Key
● Save the table with the name "STUDENT."
Table Creation - STREAM:
● In OpenOffice Base, go to the "Tables" tab.
● Create a new table named "STREAM" with the following fields:
● Field Name: StreamID
● Data Type: TINYINT
● Field Properties: Primary Key
● Field Name: StreamName
● Data Type: Text
● Field Size: 25
● Save the table with the name "STREAM."
Relationship Creation:
● Establish a relationship between the "STUDENT" and "STREAM" tables using the common
field "StreamID" in "STUDENT" and "StreamID" in "STREAM."
Form Creation - STUDENT ENTRY:
a. Open OpenOffice Base:
● Launch OpenOffice Base and open your database (SCHOOL).
b. Access the Forms Section:
● In the main database window, click on the "Forms" icon in the left panel.
c. Create "STUDENT ENTRY" Form:
● Click on "Use Wizard to Create Form".
● Select the "STUDENT" table.
● Choose the fields (Admno, Name, Address, Class, Sec, DOB, StreamID) for the form.
● Complete the form creation wizard.
Form Creation - STREAM ENTRY:
a. Create Form:
● Click on "Use Wizard to Create Form".
● Select the "STREAM" table.
● Choose the fields (StreamID, StreamName) for the form.
● Complete the form creation wizard.
7. Data Entry:
a. Enter Records in "STUDENT" Table:
● Open the "STUDENT ENTRY Form."
● Enter 10 records for students. For example,
b. Enter Records in "STREAM" Table:
● Open the "STREAM ENTRY Form."
● Enter 4 records for different streams.
Report Creation:
a. Create "STUDENT DETAILS" Report:
● Go to the "Reports" section in OpenOffice Base.
● Click on "Use Wizard to Create Report".
● Select the necessary fields (Admno, Name, Address, Class, Sec, DOB, StreamID,
StreamName) from both "STUDENT" and "STREAM" tables.
● Complete the report creation wizard or manually arrange fields in design view.
Viewing Report:
a. Go to Report section and choose “STUDENT DETAILS”.