EXAMPLE DATABASE

The following E/R diagram and tables are used in the examples throughout this post.

STUDENT

STUID LNAME FNAME MAJOR CREDITS
S1001 Smith Tom History 90
S1010 Burns Edward Art 63
S1015 Jones Mary Math 42
S1002 Chin Ann Math 36
S1020 Rivera Jane CIS 15
S1015 McCarthy Owen Math 9

CLASS

COURSENUM FACID SCHED ROOM
ART103A F101 MWF9 H221
CIS201A F105 TUTHF10 M110
MTH101B F110 MTUTH9 H225
HST205A F202 MWF11 H221
MTH103C F110 MWF11 H225
CIS203A F105 MTHF12 M110

FACULTY

FACID FACNAME DEPT RANK
F101 Adams Art Professor
F202 Smith History Associate
F105 Tanaka CIS Instructor
F110 Byrne Math Asistant
F221 Blume CIS Professor

ENROLL

COURSENUM STUID GRADE
ART103A S1001 A
CIS201A S1020 B
CIS201A S1002 F
ART103A S1010 -0-
ART103A S1002 D
MTH101B S1020 A
HST205A S1001 C
MTH103C S1010 -0-
MTH103C S1002 B

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>