Chapter No 5 DATA
DICTIONARY
DATA DICTONARY
5.1 INTRODUCTION TO DATA DICTONARY:
Data dictionary is a structure repository of the Metadata. It represents the
entire proposed system in a document form. It is an organized listing of all data
elements that are related to the system with precise definitions.
A database model or database schema is the structure or format of a
database, described in a formal language supported by the database management
system. Schemas are generally stored in a data dictionary.
5.2 TABLES DATA DICTONARY:
Data dictionary of the tables which are used in this Project is given below:
5.2.1 Student Table:
Entity Name: STUDENT
Description: Maintains overall student information
Attribute Name Data Type Description
Adm_No Varchar2(6) Unique Admission Number for a student
Std_Name Varchar2(20) Define name for a student
F_Name Varchar2(20) Define father name for a student
Date_Of_Birth Date Define the student’s date of birth
F_Occupation Char(20) Define student’s father occupation
Caste Char(20) Define caste of a student
Contact_No Varchar2(11) Define Contact number of a student
Address Varchar2(60) Define address for a student
Tab 5.1 Student Table
Examination System of Hamdard Public High School 22
Chapter No 5 DATA
DICTIONARY
5.2.2 Class Table:
Entity Name: CLASS
Description: Contains information about a Class
Attribute Name Data Type Description
Class_Id Number(2) Unique ID of a class
Class_Name Varchar2(7) Define student’s class name
Section Varchar2(1) Define section of class
Tab 5.2 Class Table
5.2.3 Enrollment Table:
Entity Name: ENROLLMENT
Description: Contains information about a student enrollment
Attribute Name Data Type Description
Adm_No Varchar2(6) Foreign key references to Student table
Class_Id Number(2) Foreign key references to Class table
Roll_No Number(2) Define Roll Number of a student
Adm_Date Date Define date of admission of a student
Tab 5.3 Enrollment Table
5.2.4 Subjects Table:
Examination System of Hamdard Public High School 23
Chapter No 5 DATA
DICTIONARY
Entity Name: SUBJECTS
Description: Contains Subjects information of a student and/or class
Attribute Name Data Type Description
Sub_Id Number(3) Unique ID of a Subject
Class_Id Number(2) Foreign key references to Class table
Sub_Name Varchar2(20) Define the subject name
Total_Marks Number(3) Define total marks of a subject in a class
Tab 5.4 Subjects Table
5.2.5 Exam Table:
Entity Name: EXAM
Description: Contains information about Examination
Attribute Name Data Type Description
Adm_No Varchar2(6) Foreign key references to Student table.
Exam_Date Date Define Examination date.
Class_Id Number(2) Foreign key references to Class table.
Sub_Id Number(3) Foreign key references to Subject table.
Term Varchar2(10) Define term information of Examination
Exam_Session Varchar2(7) Define Session of the Examination
Result_Date Date Define Result declaration date
Obt_Marks Number(3) Define obtained marks of a student in a
subject
Tab 5.5 Exam Table
Examination System of Hamdard Public High School 24
