(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 MANAGEMENT
- What is the difference between the World Wide Web (WWW) and the Internet? Give two references from a journal along with your answer.arrow_forwardDiscuss with appropriate examples, the types of relationship in a database. Give two references from an article.arrow_forwardWhat is a cloud and why do we use it? Give one reference with your answer.arrow_forward
- What are triggers and how do you invoke a trigger on demand? give one reference with your anwer.arrow_forwardWhy is database normalization important? Give one reference with your answer.arrow_forwardDescribe the role of databases and database management systems in the context ofenterprise systems. Give two references with your answer.arrow_forward
- Is it advisable to run a test on a live database? Give reasons. Also give one reference from an article.arrow_forwardFor context and I am looking for someone with experience in either computer graphics with companies, or at least has an expertise or experiences in engine development.I am developing a game engine. The niche that I want to focus in open-world development to specialize in.I have seen, heard, and had discussions about various approaches to scene graphs and ways they get handled to be sent to the renderer.If I wanted to focus on open-world, what are different tips and approaches you can tell me of how complex scenes. Like open-world get rendered? What I mean when asking this question, what is the design layout typically of a few approaches that is used for rendering not just basic scenes but complex scenes? Especially since I want to focus on building a game engine that hopes to focuse in open-world.I am using the entity component system framework EnTT, and would like to know if you can also provide tips and how that framework can be incorporated into the design layouts of how you've…arrow_forwardPlease original work Describe the steps of the process of data discovery Why each one is important to data analysis and data warehousing frameworks. Please cite in text references and add weblinksarrow_forward
- The following is code for a disc golf program written in C++: player.h: #ifndef PLAYER_H #define PLAYER_H #include <string> #include <iostream> class Player { private: std::string courses[20]; // Array of course names int scores[20]; // Array of scores int gameCount; // Number of games played public: Player(); // Constructor void CheckGame(const std::string& courseName, int gameScore); void ReportPlayer(int playerId) const; }; #endif // PLAYER_H player.cpp: #include "player.h" #include <iomanip> Player::Player() : gameCount(0) {} void Player::CheckGame(const std::string& courseName, int gameScore) { for (int i = 0; i < gameCount; ++i) { if (courses[i] == courseName) { // If course has been played, check for minimum score if (gameScore < scores[i]) { scores[i] = gameScore; // Update to new minimum score } return; // Exit after…arrow_forwardWhat is the cyclomatic complexity of the diagram below, and how did you find it?arrow_forwardWrite the following code segment in MARIE’s assembly language:if X <= Y thenY = Y - 1;else if X != Zthen Y = Y + 1;else Z = Z - 1arrow_forward
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr