student takes ID ID course id sec id name dept name tot_cred semester vear grade section course department course id sec id semester Course id advisor title dept name id dept_name building budget vear time_slot credits building гоот_литber time_slot_id time slot id day start time end_time prereq instructor classroom Course id REereg id building room_number capacity пате dept_name salary teaches ID Course id sec id semester ear Figure 2.9 Schema diagram for the university database.
student takes ID ID course id sec id name dept name tot_cred semester vear grade section course department course id sec id semester Course id advisor title dept name id dept_name building budget vear time_slot credits building гоот_литber time_slot_id time slot id day start time end_time prereq instructor classroom Course id REereg id building room_number capacity пате dept_name salary teaches ID Course id sec id semester ear Figure 2.9 Schema diagram for the university database.
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
Related questions
Question
Consider the advisor relation shown in the schema diagram in Figure 2.9, with
s_id as the primary key of advisor. Suppose a student can have more than one
advisor. Then, would s_id still be a primary key of the advisor relation? If not,
what should the primary key of advisor be?
![student
takes
ID
ID
course id
sec id
name
dept name
tot_cred
semester
vear
grade
section
course
department
course id
sec id
semester
Course id
advisor
title
dept name
id
dept_name
building
budget
vear
time_slot
credits
building
гоот_литber
time_slot_id
time slot id
day
start time
end_time
prereq
instructor
classroom
Course id
REereg id
building
room_number
capacity
пате
dept_name
salary
teaches
ID
Course id
sec id
semester
ear
Figure 2.9 Schema diagram for the university database.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F510d20c4-9d52-4a9c-a6cc-28cfc6af0e49%2F950bae99-26ba-444b-9bbb-83b3d536797d%2Fucgmre.png&w=3840&q=75)
Transcribed Image Text:student
takes
ID
ID
course id
sec id
name
dept name
tot_cred
semester
vear
grade
section
course
department
course id
sec id
semester
Course id
advisor
title
dept name
id
dept_name
building
budget
vear
time_slot
credits
building
гоот_литber
time_slot_id
time slot id
day
start time
end_time
prereq
instructor
classroom
Course id
REereg id
building
room_number
capacity
пате
dept_name
salary
teaches
ID
Course id
sec id
semester
ear
Figure 2.9 Schema diagram for the university database.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
![LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.](https://www.bartleby.com/isbn_cover_images/9781337569798/9781337569798_smallCoverImage.gif)
LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
Computer Science
ISBN:
9781337569798
Author:
ECKERT
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
![LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.](https://www.bartleby.com/isbn_cover_images/9781337569798/9781337569798_smallCoverImage.gif)
LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
Computer Science
ISBN:
9781337569798
Author:
ECKERT
Publisher:
CENGAGE L
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
![Fundamentals of Information Systems](https://www.bartleby.com/isbn_cover_images/9781337097536/9781337097536_smallCoverImage.gif)
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning