Download
1 / 2
20 likes | 223 Views
SCHOOL DATA BASE. SCHOOL DATA BASE. CSUEB TED5110 Razo / 2005. FIELDS. Last name. First name. MI. Soc Sec Num. ROOM. DOB. Home Phone#-1. # 2. 1. 207B. Chan. Samantha. B. 543-23-567. 10/12/95. 510-575-2212. INPUT. 2. Moore. Jeffrey. B. 543-23-567. 10/12/95. 133.
E N D
SCHOOL DATA BASE SCHOOL DATA BASE CSUEB TED5110 Razo / 2005 FIELDS Last name First name MI Soc Sec Num ROOM DOB Home Phone#-1 # 2 1 207B Chan Samantha B 543-23-567 10/12/95 510-575-2212 INPUT 2 Moore Jeffrey B 543-23-567 10/12/95 133 510-577-5010 Adams Luis B 543-23-567 10/12/95 125 3 510-577-2885 STORAGE RECORDS KEY Sort KEY Sort LINK Inquiries: STRUCTURED QUERY LANGUAGE (SQL) INPUT & Remote OUTPUT OUTPUT OUTPUT Formatted report OUTPUT list Screen RECORD # Data Bases Basic Components
SCHOOL DATA BASE SCHOOL DATA BASE CSUEB TED5110 Razo / 2005 Data Bases Extensions, Links, Relations, Hierarchies STUDENTS FIELDS RECORD # Last name First name MI Soc Sec Num DOB ROOM Home Phone#-1 # 2 207B 1 Chan Samantha B 543-23-567 10/12/95 510-575-2212 2 Moore Jeffrey B 543-23-567 10/12/95 133 510-577-5010 LINK 3 Adams Luis B 543-23-567 10/12/95 125 510-577-2885 RECORDS CLASSROOMS KEY-Sort KEY-Link TEACHER code Door KEY# ROOM Room phone# 100 V209 510-567-3106 C133 M345 C111 S122 510-567-3109 KEY Sort KEY Sort CLAB1 L23 T034 510-567-3115 510-567-3106 133 K818 TEACHERS LINK
