(a)
Change the requirements specified in question 7 if the student must be assigned an advisor who is in the department in which the student is majoring.
(a)
Explanation of Solution
The given DBDL in question 7 is as follows:
The changes in the DBDL after assigning an advisor who is in the department in which the student is majoring is as follows:
Since the department from which the student is majoring and the department of the advisor must be the same. Therefore, a new relation studentAdvisordept should be created in which each combination of StudentNum and AdvisorNum will be related to a common department.
(b)
Change the requirements specified in question 7 if the student’s advisor does not necessarily have to be in the department in which the student is majoring.
(b)
Explanation of Solution
The given DBDL in question 7 is as follows:
The changes in the DBDL after assigning an advisor who is not required to be in the department in which the student is majoring is as follows:
Since the department from which the student is majoring and the department of the advisor need not be the same. So, the DeprtmenttNum in Student table will refer to the DepartmentNum in Department table.
Want to see more full solutions like this?
Chapter 6 Solutions
CONCEPTS OF DATABASE MGMT.>CUSTOM<
- Computer Networking: A Top-Down Approach (7th Edi...Computer EngineeringISBN:9780133594140Author:James Kurose, Keith RossPublisher:PEARSONComputer Organization and Design MIPS Edition, Fi...Computer EngineeringISBN:9780124077263Author:David A. Patterson, John L. HennessyPublisher:Elsevier ScienceNetwork+ Guide to Networks (MindTap Course List)Computer EngineeringISBN:9781337569330Author:Jill West, Tamara Dean, Jean AndrewsPublisher:Cengage Learning
- Concepts of Database ManagementComputer EngineeringISBN:9781337093422Author:Joy L. Starks, Philip J. Pratt, Mary Z. LastPublisher:Cengage LearningPrelude to ProgrammingComputer EngineeringISBN:9780133750423Author:VENIT, StewartPublisher:Pearson EducationSc Business Data Communications and Networking, T...Computer EngineeringISBN:9781119368830Author:FITZGERALDPublisher:WILEY