STUDENT RECORD KEEPING
SYSTEM DATABASE
TEAM MEMBERS
Vadlamudi Divya(ID :14322)
B L Priyanka(ID :14347)
Ettireddy Sruthi Reddy(ID :14337)
Bolla Bhavya(ID :14616)
Mettu Sri Divya Reddy(ID :14859)
Polagouni Harini(ID :14388)
Katikireddy Vinusha Reddy(ID :14784)
CONTENTS
INTRODUCTION
ENTITIES
ER-DIAGRAM
TABLES
CONCLUSION
SQL
Structured Query Language (SQL) : SQL can execute queries in database
where we can access and manipulate data in database using SQL commands
like DDL,DML,TCL and DCL.
we can retrieve data, insert records, update records and delete records from
database using SQL.
We can create new database , create new tables in a SQL and can set
permissions on tables.
INTRODUCTION
Student record keeping system database can handle all the details about
student. The details include course details, Student and student details, exam
details, department details, attendance details, faculty details, college details,
etc. The student record keeping system is an automated version of manual
student record keeping system.
The main purpose of the project is to integrate and store distinct sections of
colleges and schools into consistent manner, so that complex functions can be
handled smoothly by utilizing the powerful database management, data
retrieval and data manipulation.
The objective is to replace the existing student record keeping system that is
maintained manually.
EXISTING SYSTEM
All the details of the students are
maintained in different entities and
maintained manually, so they
should be centralized as
information from one entity will be
needed by other entities. For
example, if student needs his course
details, then it needs to contact to
other module and get the results.
PROPOSED SYSTEM
The student record keeping system is an automated version of manual student
record keeping system. It is used to maintain the details of the student information.
The updated information about the student is necessary in colleges and schools. It
tracks all the details of a student from the day one to the end of the course which
can be used for all reporting purpose, tracking of attendance, progress in the
course, exam details, and all these will be available for future purpose too.
Extensive information is available at fingertips through this system.
ENTITIES:
1. COLLEGE
2. STUDENT
3. STUDENT_DETAILS
4. DEPARTMENT
5. COURSE
6. FACULTY
7. EXAMS
8. ATTENDANCE
COLLEGE
It contain details like college id,
college name, student id,
department id . The college is
responsible for entering the new
student and department. The
college entity has the highest level
of power in the student record
keeping system.
STUDENT
It contains the details of student like
student ID, student name, ID number,
department ID and course ID. It can
access the information of course
details, department details and student
details. Student will be added by
college.
COURSE
It contains the details of course like
course ID, department ID, course name,
course credit, faculty ID. It can access
details from student , attendance,
exams, faculty and department.
STUDENT DETAILS
It contain details of student like
student ID, address, city, state, zip,
contact number and email. It access
details from student.
DEPARTMENT
It contain details like department id
,department name, department head,
credits required. The department is
responsible for providing different
departments and the courses provided
by each department and also the credits
that they offer in the particular course
which student have selected. The
student may belong to any of the
departments. It is added by college. It
can access details from student and
course.
ATTENDANCE
It contain details like total classes,
classes present, classes absent,
percentage, course ID. It is
accessed by course .
FACULTY
It contain details like faculty ID,
faculty name, faculty mail. It can
access details of course.
EXAM
The exams contains details like
exam ID, course ID, exam date,
marks, credits received. It can
access details from course
ER DIAGRAM
COLLEGE
COLLEGE_ID
COLLEGE_NAME
STUDENT_ID
DEPARTMENT_ID
STUDENT_DETAILS DEPARTMENT
DEPARTMENT_ID NOT NULL
STUDENT_ID NOT NULL (FK) DEPARTMENT_NAME NOT NULL
ADDRESS NOT NULL STUDENT DEPARTMENT_HEAD NOT NULL
CITY NOT NULL CREDITS_REQURIED NOT NULL
STATE NOT NULL STUDENT_ID NOT NULL
ZIP NOT NULL DEPARTMENT_ID NOT NULL (FK)
CONTACT_NUMBER NOT NULL STUDENT_NAME NOT NULL
EMAIL NOT NULL COURSE_ID NOT NULL (FK)
EXAMS
EXAM_ID NOT NULL
COURSE_ID NOT NULL (FK)
ATTENDANCE EXAM_DATE NOT NULL
MARKS NOT NULL
CREDITS_RECEIVED NOT NULL
CLASSES_PRESENT NOT NULL COURSE
CLASSES_ABSENT NOT NULL
PERCENTAGE NOT NULL COURSE_ID NOT NULL
COURSE_ID NOT NULL (FK) DEPARTMENT_ID NOT NULL (FK)
COURSE_NAME NOT NULL FACULTY
COURSE_CREDIT NOT NULL
FACULTY_ID NOT NULL
FACULTY_ID NOT NULL (FK)
FACULTY_NAME NOT NULL
FACULTY_MAIL NOT NULL
CREATE TABLES
TABLES
COLLEGE TABLE
FIELDNAME DATATYPE DESCRIPTION
COLLEGE_ID INT PRIMARY KEY
COLLEGE_NAME VARCHAR -
STUDENT_ID INT FOREIGN KEY
DEPARTMENT_ID INT FOREIGN KEY
DEPARTMENT TABLE
FIELD NAME DATATYPE DESCRIPTION
DEPARTMENT_ID INT PRIMARY KEY
DEPARTMENT_NAME VARCHAR -
CREDITS_RECEIVED NUMBER -
STUDENT TABLE
FIELD NAME DATATYPE DESCRIPTION
STUDENT_ID INT PRIMARY KEY
DEPARTMENT_ID INT FOREIGN KEY
STUDENT_NAME VARCHAR -
COURSE_ID INT FOREIGN KEY
STUDENT DETAILS
FIELDNAME DATATYPE DESCRIPTION
STUDENT_ID INT FOREIGN KEY
ADDRESS VARCHAR -
CITY VARCHAR -
ZIP INT -
CONTACT_NUMBER VARCHAR -
EMAIL_ID VARCHAR -
COURSE TABLE
FIELD NAME DATATYPE DESCRIPTION
COURSE_ID INT PRIMARY KEY
DEPARTMENT_ID INT FOREIGN KEY
COURSE_CREDIT INT -
FACULTY_ID INT FOREIGN KEY
ATTENDANCE TABLE
FIELD NAME DATATYPE DESCRIPTION
CLASSES_PRESENT INT -
CLASSES_ABSENT INT -
PERCENTAGE INT -
COURSE_ID INT FOREIGN KEY
FACULTY TABLE
FIELD NAME DATATYPE DESCRIPTION
FACULTY_ID INT PRIMARY KEY
FACULTY_NAME VARCHAR -
FACULTY_MAIL VARCHAR -
EXAMS TABLE
FIELD NAME DATATYPE DESCRIPTION
EXAM_ID PRIMARY KEY INT
COURSE_ID INT FOREIGN KEY
EXAM_DATE DATE -
CREDITS_RECIEVED INT -
MARKS INT -
NORMALIZATION IS NOT REQUIRED
CONCLUSION
STUDENT RECORD KEEPING SYSTEM DATABASE which is automated
version, helps colleges and schools for managing the details of the student
which can be accessed at any point of time. Faculty and management can get
the required information without delay. It saves valuable time and reduces huge
manual work.
