Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
SCHOOL DATA BASE PowerPoint Presentation
Download Presentation
SCHOOL DATA BASE

SCHOOL DATA BASE

154 Vues Download Presentation
Télécharger la présentation

SCHOOL DATA BASE

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. 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

  2. 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