Sub - view / External Schema 1 : Student , Parent , Emergency Contact , and Teacher information The school must store basic information for each parent , emergency contact , student , and teacher assigned to the school . Each person is assigned a unique ID number . First and last names , addresses ( including street , city , state , and zip code ) , and up to 2 contact phone numbers must be stored . The person type is recorded for each person - type values are* Student , Teacher , or Parent / Guardian / Emergency Contact . For teachers , their primary subject area taught , their start date at the school , and their highest level of college degree earned is also stored . For students , their dates of birth and their grade levels are stored . Grade levels are 6 , 7 , or 8 at this school . For parent / guardians / emergency contacts , their relationship to the student is stored . Report 1 : Sample Student Emergency Contact List The school must be able to produce an emergency contact report for each student as required . See the business rules for more details . Omaha Middle School STUDENT EMERGENCY CONTACT REPORT Student : Teresa Jacobson Student Number : 11223 Last Name First Name Relationship Contact Number 1\\ | Contact Number 2 Jacobson Kim Mother 402- 123 - 1234 402 - 654 - 321 1 Jacobson Jose Father 402- 123- 1234 402 - 654- 2323 Jacobson Sara Grandmother" 402- 234 - 1234 Anderson! Joseph Other 402 - 321 - 11 1 1 402 - 4 4 4- 6578 Additional Business Rules :` 1 . Each student must have one or more emergency contact entries . At least one contact should be a parent / guardian . Emergency contacts may be a parent ( father , mother ) , guardian , grandparent or other . 2 . Each parent / guardian / emergency contact entry includes the address , city , state , zip code and up to 2 phone* numbers for each person ." 3. A parent can have more than one student in attendance at the school