PROFESSOR SCHOOL PROF NUM is dean of PK SCHOOL CODE PK FK1 DEPT CODE PROF SPECIALTY PROF_RANK PROF LNAME PROF FNAME PROF INITIAL PROF_EMAIL SCHOOL_NAME FK1 PROF_NUM opetates DEPARTMENT employs advses PK DEPT CODE has DEPT NAME OFK1 SCHOOL_CODE FK2 PROF_NUM %3D chairs 3D teaches offers STUDENT CLASS COURSE PK STU NUM PK CLASS CODE PK CRS CODE generates. HtrK1 DEPT CODE FK1 DEPT CODE STU LNAME STU_FNAME STU INITIAL STU EMAIL FK2 PROF_NUM CLASS SECTION CLASS TIME FK1 CRS_CODE FK2 PROF NUM FK3 ROOM CODE CRS TITLE CRS DESCRIPTION CRS CREDIT is used for is writen in ROOM PK ROOM CODE ENROLL is found in ROOM_TYPE FK1 BLDG CODE PK,FK2 CLASS CODE PK.FK1 STU NUM BUILDING PK BLDG CODE ENROLL DATE ENROLL_GRADE i- coataina -- +H BLDG_NAME BLDG LOCATION Cnga teaming 0 2015

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

I need the discussion about this figure Tiny College ERD.

PROFESSOR
SCHOOL
PK
PROF NUM
is dean of
SCHOOL CODE
PK
FK1 DEPT_CODE
PROF SPECIALTY
PROF_RANK
PROF LNAME
PROF_FNAME
PROF_INITIAL
PROF_EMAIL
SCHOOL_NAME
FK1 PROF_NUM
opetates
DEPARTMENT
advses
employs
DEPT CODE
PK
has
-OH
----
DEPT_NAME
OHFK1 SCHOOL_CODE
FK2 PROF_NUM
chairs
teaches
offers
STUDENT
STU NUM
CLASS
COURSE
CLASS CODE
PK
PK
PK CRS CODE
HHFK1 DEPT_CODE
FK1 DEPT CODE
STU LNAME
STU_FNAME
STU_INITIAL
STU EMAIL
FK2 PROF_NUM
generates
CLASS_SECTION
CLASS_TIME
FK1 CRS_CODE
FK2 PROF_NUM
FK3 ROOM CODE
CRS TITLE
CRS DESCRIPTION
CRS CREDIT
is used for
is writen in
ROOM
PK ROOM CODE
ENROLL
is found in
ROOM_TYPE
FK1 BLDG CODE
PK,FK2 CLASS CODE
PK,FK1 STU NUM
BUILDING
PK BLDG CODE
ENROLL DATE
ENROLL_GRADE
i- contains --HH
BLDG_NAME
BLDG_LOCATION
Cengage leaming O 2015
Transcribed Image Text:PROFESSOR SCHOOL PK PROF NUM is dean of SCHOOL CODE PK FK1 DEPT_CODE PROF SPECIALTY PROF_RANK PROF LNAME PROF_FNAME PROF_INITIAL PROF_EMAIL SCHOOL_NAME FK1 PROF_NUM opetates DEPARTMENT advses employs DEPT CODE PK has -OH ---- DEPT_NAME OHFK1 SCHOOL_CODE FK2 PROF_NUM chairs teaches offers STUDENT STU NUM CLASS COURSE CLASS CODE PK PK PK CRS CODE HHFK1 DEPT_CODE FK1 DEPT CODE STU LNAME STU_FNAME STU_INITIAL STU EMAIL FK2 PROF_NUM generates CLASS_SECTION CLASS_TIME FK1 CRS_CODE FK2 PROF_NUM FK3 ROOM CODE CRS TITLE CRS DESCRIPTION CRS CREDIT is used for is writen in ROOM PK ROOM CODE ENROLL is found in ROOM_TYPE FK1 BLDG CODE PK,FK2 CLASS CODE PK,FK1 STU NUM BUILDING PK BLDG CODE ENROLL DATE ENROLL_GRADE i- contains --HH BLDG_NAME BLDG_LOCATION Cengage leaming O 2015
Expert Solution
steps

Step by step

Solved in 7 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY