Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Question
COURSE
CRS_CODE
DEPT_CODE
CRS_DESCRIPTION
CRS_CREDIT
CLASS
CLASS_CODE
CRS_CODE
CLASS_SECTION
CLASS_TIME
CLASS ROOM
PROF_NUM
00
ENROLL
CLASS_CODE
STU_NUM
ENROLL_GRADE
STUDENT
STU_NUM
STU_LNAME
STU_FNAME
STU_INIT
STU_DOB
STU_HRS
STU_CLASS
STU_GPA
STU_TRANSFER
DEPT_CODE
STU_PHONE
PROF_NUM
Review the relational diagram above and briefly describe the following in one sentence.
1. How would you extend this database to identify the Professor who taught a class?
2. How would you extend this database to identify the Department that had a course?
expand button
Transcribed Image Text:COURSE CRS_CODE DEPT_CODE CRS_DESCRIPTION CRS_CREDIT CLASS CLASS_CODE CRS_CODE CLASS_SECTION CLASS_TIME CLASS ROOM PROF_NUM 00 ENROLL CLASS_CODE STU_NUM ENROLL_GRADE STUDENT STU_NUM STU_LNAME STU_FNAME STU_INIT STU_DOB STU_HRS STU_CLASS STU_GPA STU_TRANSFER DEPT_CODE STU_PHONE PROF_NUM Review the relational diagram above and briefly describe the following in one sentence. 1. How would you extend this database to identify the Professor who taught a class? 2. How would you extend this database to identify the Department that had a course?
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education