Data Dictionary 1

Database Name: SECA Table Name: tblStudents Description: Student information of each student is found in this table. Field Name studId lastName firstName middelName bDay yearLevel sectionId status father fatherOccu mother motherOccu username password remarks

Description Unique student identifier Last name of the student First name of the student Middle name of the student Birth date of student Year level of the student To identify section information of student To identify whether student enrolled or not Father’s name of student Father’s occupation of the student Mother’s name of the student Mother’s occupation of the student Student’s username Student’s password Remarks about the student

Length

8 32 32 32 8 8 10 32 32 32 32 32 32 500

Data Type VARCHAR VARCHAR VARCHAR VARCHAR DATE VARCHAR INT VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR

Table Name: tblSections Description: Different sections in the school found in this table Field Name sectionId sectionName yearLevel slotsAvailable

Description Section unique identifier Name of section Year level on which the section belongs Number of students in section

Length

4 32 8

Data Type INT VARCHAR VARCHAR

Table Name: tblRooms Description: Different rooms information in the school found in this table Field Name roomed roomName description

Description Room unique identifier Name of room Description of room

Length

4 32 250

Data Type INT VARCHAR VARCHAR

Table Name: tblTeachers Description: Some teacher’s information are found in this table

Field Name teacherId lastName firstName middleName remarks

Description Teacher unique identifier Last name of the teacher First name of the teacher Middle name of the teacher Remarks about the teacher

Length

4 32 32 32 500

Data Type INT VARCHAR VARCHAR VARCHAR VARCHAR

Table Name: tblSubjects Description: Student’s subject information are found in this table Field Name subjId subjName timeSlot sectionId teacherId roomId yearLevel

Description Subject unique identifier Name of subject Time slot of the subject To identify section information of the subject To identify teacher information of the subject To identify room information of the subject Year level where the subject belongs

Length

4 32 16 4 4 4 8

Data Type INT VARCHAR VARCHAR INT INT INT VARCHAR

Table Name: tblStudMsgs Description: Student’s messages are found in this table Field Name msgId studId subject msg sender dateSent

Description Unique identifier of student’s message Student unique identifier What the student’s message is all about The contents of student’s message The sender of the message When the message was sent

Length

4 4 32 1000 64

Data Type INT INT VARCHAR VARCHAR VARCHAR DATE

Table Name: tblUsers Description: User’s information are found in this table Field Name userId username password accessLevel

Description Unique identifier of the user Username of the user Password of the user User access level

Length

4 32 32 16

Data Type INT VARCHAR VARCHAR VARCHAR

Table Name: tblAdminMsgs Description: administrator’s messages are found in this table Field Name msgId subject msg sender dateSent

Description Unique identifier of administrator’s message What the administrator’s message is all about The contents of administrator’s message The sender of the message When the message was sent

Length

4 32 1000 64

Data Type INT VARCHAR VARCHAR VARCHAR DATE

Table Name: tblRegMsgs Description: registrar’s messages are found in this table Field Name msgId subject msg sender dateSent

Description Unique identifier of registrar’s message What the registrar’s message is all about The contents of registrar’s message The sender of the message When the message was sent

Length

4 32 1000 64

Data Type INT VARCHAR VARCHAR VARCHAR DATE

Table Name: tblNews Description: School updates or news are found in this table Field Name NewsId Title Contents dateAdded author

Description Unique identifier of news Title of the news Contents of the news When the news was published The author of the news

Length

4 32 2500 64

Data Type INT VARCHAR VARCHAR DATE VARCHAR

Table Name: tblSchoolCalendar Description: Different school activities are fund in this table Field Name activityId date activity

Description Unique identifier of the school activity When the school will be held What is the activity

Length

4 250

Data Type INT DATE VARCHAR