-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathidentifier.sqlite
78 lines (78 loc) · 44.2 KB
/
identifier.sqlite
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
SQLite format 3 @ � � � .O}
� �
� 4a �� �
� �
Z� �,!!�#tableEnrolls_inEnrolls_in
CREATE TABLE Enrolls_in
(
flag VARCHAR NOT NULL,
student_ID INT NOT NULL,
course_link INT NOT NULL,
PRIMARY KEY (student_ID, course_link),
FOREIGN KEY (student_ID) REFERENCES Student(student_ID),
FOREIGN KEY (course_link) REFERENCES Section(course_link)
)� x�tableCourseCourseCREATE TABLE Course
(
description VARCHAR NOT NULL,
course_ID VARCHAR NOT NULL,
credits INT NOT NULL,
PRIMARY KEY (course_ID)
) � =G! indexsqlite_autoindex_Enrolls_in_1Enrolls_in -}A indexsqlite_autoindex_Student_1Student a 3{G! indexsqlite_autoindex_Instructor_1Instructor+y? indexsqlite_autoindex_Course_1Course �!!�#tableEnrolls_inEnrolls_in
CREATE TABLE Enrolls_in
(
flag VARCHAR NOT NULL,
student_ID INT NOT NULL,
course_link INT NOT NULL,
PRIMARY KEY (student_ID, course_link),
FOREIGN KEY (student_ID) REFERENCES Student(student_ID),
FOREI3� G! indexsqlite_autoindex_Enrolls_in_1Enrolls_in �A~�YtableSectionSectionCREATE TABLE Section
(
course_link INTEGER PRIMARY KEY,
section_ID INT NOT NULL,
capacity INT NOT NULL,
course_ID VARCHAR NOT NULL,
instructor_ID INT NOT NULL,
FOREIGN KEY (course_ID) REFERENCES Course(course_ID),
FOREIGN KEY (instructor_ID) REFERENCES Instructor(instructor_ID)
)�
|�ktableStudentStudentCREATE TABLE Student
(
student_ID INT NOT NULL,
student_name VARCHAR NOT NULL,
PRIMARY KEY (student_ID)
)� z!!�tableInstructorInstructorCREATE TABLE Instructor
(
instructor_ID INT NOT NULL,
instructor_name VARCHAR NOT NULL,
PRIMARY KEY (instructor_ID)
)
G ���rG )IPerforming in Stand- Up ComedyCOM210 AnimationANI3300WIntro. To Stage Acting Voice-Over forDRM150!ExpressionDRM350-QBeginning Studio Art Adv. DramaticART101
� �����
COM210
ANI330
DRM150
DRM350 ART101
{ ������{sl b fa- Leonardo DaVinci%7Mickey Mouse!(Judi Dench+
Martin Scorsese+#Vincent VanGogh)<Robin Williams
-Tom Hanks
� ��������� 7(
#< -
� �������{lpe �� 1test icle� #@test person%
�Hank Abrahms#9Cheddar Bob �Sam Smith#�Angus Akedo) �Roger Molinari
!{OtherBobby
� ����������� � � 1 � @{
�9�� �
� ������ DRM350
ART101# COM210< DRM150( ANI330< ANI330-
� ���� None
� None
� None
�#Excess Cred
�
� ����
�
�
�
�