Table 1: Tables of Student Records
Primary Key: StudentID
Table 1.1 Student Name Table StudentID | LastName | FirstName | MiddleName | C13 – 8517 | Sarmiento | Lemuel | Ferrera |
Table 1.2 Student Basic Table StudentID | Age | Gender | Religion | Civil Status | Contact Number | C13 – 8517 | 17 | Male | Roman Catholic | Single | 09484994670 |
Table 1.3 Student Birthday Table StudentID | Month | Date | Year | C13 – 8517 | November | 15 | 1997 |
Table 1.4 Student Permanent Address Table StudentID | Barangay | Town | Province | ZipCodeP | C13 – 8517 | Malibago | Pola | Oriental Mindoro | 5206 |
Table 1.5 Student Current Address Table StudentID | Barangay | Town | Province | ZipCodeC | C13 – 8517 | Alcate | Victoria | Oriental Mindoro | 5205 |
Table 1.6 Student School StudentID | SchoolYear | ProgramEnrolled | Year | C13 – 8517 | 2015-2016 | BSIT Program | III |
Table 1.7 Student Image Table StudentID | Image | C13 – 8517 | Capture1.jpg |
Table 1.8 Student Fingerprint Table StudentID | Fingerprint | C13 – 8517 | SarmientoFGP.jpg |
Table 1.9 Person to be Notified Table StudentID | GuardianFirstName | GuardianLastName | GuardianMiddleName | | | | |
Table 1.10 Notification Address Table StudentID | GuardianBarangay | GuardianTown | GuardianProvince | GuardianZipCode | | | | | |
Table 1.11 Person-to-be-Notified Additional Details Record StudentID | Relationship | Contact Number | | | |
Table 2: Table of Employees Record
Primary Key: EmployeeID
Table 2.1 Employee Name Table EmployeeID | LastName | FirstName | MiddleName | | | | |
Table 2.2 Employee Basic Table EmployeeID | Age | Gender | Religion | Civil Status | Contact Number | | | | | | |
Table 2.3 Employee Birthday Table EmployeeID | Month | Date | Year | | | | |
Table 2.4 Employee Permanent Address Table EmployeeID | Barangay | Town | Province |