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?
Expert Solution
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
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
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
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
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning