Download Database Schema for a School Information System and more Study Guides, Projects, Research Computer science in PDF only on Docsity!
Table Name Student Information Description This table will contain the detail information about the student associated with school.
Field Name Data Type Attribute studentId Integer Primary Key, Auto increment studentRegistrationNumber Varchar(45) Unique key studentFirstname Varchar(45) studentMiddlename Varchar(45) studentLastname Varchar(45) studentFathername Varchar(45) studentMothername Varchar(45) studentDOB Date/Time studentTemporaryAddress Varchar(45) studentpermanentAddress Varchar(45) studentSex Varchar(45) studentFatherOccupation Varchar(45) studentMotherOccupation Varchar(45) studentFatherNumber Varchar(20) studentMotherNumber Varchar(20) studentPhoneNumber Varchar(20) classId Integer Foreign key studentSection Varchar(1)
Table Name Class Description This table will contain the detail information about the subject associated with the class and fee related to it.
Field Name Data Type Attribute classId Integer Primary Key, Auto increment subjectUniqueKey Varchar(45) Foreign Key Class fee Varchar(45) Class Capacity Integer Class Teacher Varchar(45)
Table Name Subject Description This table will contain the detail information about the subject associated with the class.
Field Name Data Type Attribute subjectId Integer Primary Key, Auto increment subjectUniqueKey Varchar(45) Foreign Key subjectName Varchar(45)
Table Name Staff Description This table will contain the detail information about the staff associated with the school.
Field Name Data Type Attribute staffId Integer Primary Key, Auto increment staffName Varchar(45) Foreign Key staffTemporaryAddress Varchar(45) staffPermanentAddress Varchar(45) Staffphone Varchar(45) staffMobile Varchar(45) staffPreviousSchool Varchar(45) staffQualification Integer staffMaritalStatus Varchar(45) salary integer
Table Name StudentAttendance Description This table will contain the detail information about the student attendance
Field Name Data Type Attribute attendanceId Integer Primary Key, Auto increment
Feedback Varchar(255) Status Varchar(25) Date Date/Time
Table Name Result Description This table will contain the detail information about the student exam result
Field Name Data Type Attribute resultId Integer Primary Key, Auto increment studentId Integer Foreign key term Varcher(25) busRoute Varchar(25)
Table Name Library (Book information) Description This table will contain the detail information about the library book
Field Name Data Type Attribute bookId Integer Primary Key, Auto increment isbn Varchar(45) bookName Varchar(45) authorName Varchar(45) quantity Integer
Table Name Library (Member information)
Description This table will contain the detail information about the book issued from library
Field Name Data Type Attribute issueId Integer Primary Key, Auto increment bookid Integer Foreign key studentId Integer Foreign key issuedate Date/Time receivedate Date/Time
Table Name Library (Member information) Description This table will contain the detail information about the book issued from library
Field Name Data Type Attribute issueId Integer Primary Key, Auto increment bookid Integer Foreign key teacherId Integer Foreign key issuedate Date/Time receivedate Date/Time
Table Name Hostel Description This table will contain the detail information about the book issued from library
Field Name Data Type Attribute issueId Integer Primary Key, Auto increment bookid Integer Foreign key studentId Integer Foreign key issuedate Date/Time receivedate Date/Time
