The database for this assignment is attached within the project itself. No need to set up databases or deal with mystical incantations. It's like having a treasure map without the need for a shovel. Dive into this fun interactive project, where I have completed several SQL queries to access this embedded database and unravel its secrets. Armed with wit, wisdom, and a dash of SQL magic, let's embark on this adventure together! 🎩💻"
This page includes details about the database used in this assignment.
The ERD includes the following tables:
- table: student
- PK: sid int
- fName varchar(50)
- lName varchar(50)
- table: course_student
- PK, FK1: student_id int
- PK, FK2: course_id int
- table: course
- PK: cid int
- courseCode varchar(50)
- courseDesc varchar(50)
- teacherId int
- table: teacher
- PK: tid int
- tFName varchar(50)
- tLName varchar(50)
- dept varchar(10)
The ERD contains the following relationships:
- a one-to-many relationship between student and course_student
- a one-to-many relationship between course and course_student
- a one-to-many relationship between teacher and course
The data tables are listed below.
| cid | courseName | courseDesc | teacherId |
|---|---|---|---|
| 1 | CS148 | Intro to Data Structures | 1 |
| 2 | CS100 | Intro to Java | 2 |
| 3 | CS202 | Intermediate Java | 1 |
| 4 | CS305 | Advanced Python | 5 |
| 5 | CS407 | Information Systems Management | 4 |
| 6 | CS206 | Network Design | 4 |
| 7 | CS503 | Advanced Cyber Security | 3 |
| 8 | CS326 | Advanced Fortran | 5 |
| 10 | CS324 | Advanced Web Services with Java API | 3 |
| 11 | EN220 | Fictional Writing | 10 |
| 12 | EN250 | Fantasy Fictional Writing | 11 |
| 14 | EN100 | Writing Basics | |
| 15 | EN200 | English Composition | |
| 16 | EN300 | Poetry Writing |
| student_id | course_id |
|---|---|
| 1 | 1 |
| 1 | 2 |
| 2 | 1 |
| 2 | 2 |
| 2 | 3 |
| 1 | 3 |
| 1 | 5 |
| 2 | 4 |
| 2 | 6 |
| 3 | 2 |
| 3 | 3 |
| 3 | 4 |
| 3 | 5 |
| 4 | 1 |
| 4 | 4 |
| 4 | 5 |
| 4 | 6 |
| 4 | 7 |
| 5 | 1 |
| 5 | 2 |
| 5 | 4 |
| 5 | 6 |
| 6 | 1 |
| 6 | 3 |
| 6 | 5 |
| 6 | 6 |
| 6 | 7 |
| 7 | 1 |
| 7 | 2 |
| 7 | 3 |
| 7 | 5 |
| 7 | 6 |
| 7 | 7 |
| 9 | 3 |
| 9 | 5 |
| 9 | 6 |
| 9 | 7 |
| sid | fName | lName |
|---|---|---|
| 1 | Jolene | Westcott |
| 2 | Tabby | Daniell |
| 3 | Hans | Wozniak |
| 4 | Ifeanyi | Derichs |
| 5 | Guafrid | Lopez |
| 6 | Helena | Abbandonato |
| 7 | Aime | Larsen |
| 9 | Milada | Dreher |
| tid | tFName | tLName | dept |
|---|---|---|---|
| 1 | Hedy | Lamarr | Computer Science |
| 2 | Radia | Perlman | Computer Science |
| 3 | Annie | Easley | Computer Science |
| 4 | Peter | Denning | Computer Science |
| 5 | Ravi | Sethi | Computer Science |
| 7 | Hilary | Mantel | English |
| 8 | Margaret | Atwood | English |
| 9 | David | Mitchell | English |
| 10 | Michael | Chabon | English |
| 11 | Neil | Gaiman | English |