Lab4: Structured Query Language (SQL)
RSaleem
week_4_lab_2.vsdtext�
�
Table
Table
TEACHER_COURSE
PK 10031 PK,FK1 10019 PK 10003 PK 10015 Business 100 Sociology 101 Calculus Programming
TEACHER_I.D.
PK 10031 Haley Hafford [email protected] (443) 569-9889 Female 1555 Lexington St. 31201 13-Apr-1960 Business Section 1
COURSE CODE
PK 001 Business 100
STUDENT I.D. and COURSE I.D.
PK 1001 PK,FK1 001
STUDENT_I.D.
Female 2-Jan-1989 133 Broklyn Drive 21161 1-Sep-2015 FK1 1001 FK1 001
generates
generates
generates
enrolls
TEACHER_I.D.
PK 10019 William Smith [email protected] (301) 556-5555 Male 909 Boston St 16313 1-Aug-1957 Sociology Section 1 FK1 10031
TACHER_I.D.
PK 10003 Kelly Moore [email protected] (415) 560-2010 Female 2901 Texas Ave 60103 11-Nov-1950 Calculus Section 1 FK1 10019
TEACHER_I.D.
PK 10015 Inwoo Cho [email protected] (218) 849-9013 Male 14 Baltimore St 10002 12-Dec-1961 Computer Science Section 2 FK1 10003
Student I.D.
PK 1011 Veena Green [email protected] (781) 362-2141 Female 13-Jul-1989 69 Woodlawn St 11814 1-Jan-2015
STUDENT I.D.
PK 1110 Eric Clapton [email protected] (301) 879-9549 Male 12-Dec-1978 3033 Ostend St 23136 7-Jun-2014 FK1 1011
STUDENT I.D.
PK 1990 George White [email protected] (443) 331-8990 Male 4-Dec-1984 177 Wakefield Ave 60120 1-Dec-2014 FK1 1110
STUDENT I.D. and COURSE I.D.
PK 1110 PK 003 FK1 1001 FK1 001
STUDENT I.D. and COURSE I.D.
PK 1990 PK 004 FK1 1110 FK1 003
STUDENT I.D. and COURSE I.D.
PK 1011 PK 005 FK1 1990 FK1 004
COURSE CODE
PK 003 Sociology 101 FK1 001
COURSE CODE
PK 004 Calculus FK1 003
COURSE CODE
PK 005 Programming FK1 004
has
has
has
has
has
has
has
has
has
has
has
has
Lab 2: Modifying a Database Design in Visio This assignment contains two (2) Sections: Visio Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Use “Appendix A: Designing Databases with Visio Professional: A Tutorial,” to help you complete Section 1: Visio Database Design. (Note: This tutorial focuses on the use of Microsoft Visio. Open source applications are not covered in Appendix A; however, the use of open source applications within labs is permitted.) Click here to download Appendix A. After reviewing your database design from Lab 1: Creating a Database Design in Visio, the college has provided more information for the database that they want developed: For each student, the college needs to track the student ID, student names, addresses, start date, phone numbers and types (such as mobile, home, work), email addresses and types (such as personal, school, work), gender, and birth date. For each course, the college needs to track the course ID, course name, department, quarters offered, sections, and instructor teaching each course. For each instructor, the college needs to track the instructor ID, name, address, phone numbers and types (such as mobile, home, work), email addresses and types (such as personal, school, work), gender, birth date, and the courses that each instructor is qualified to teach. Additionally, the college needs to track the final grades for each student after each course has completed.
