Question
A database at a college is required to support the following requirments. complete the information level design for this set of requirments. Use your own
A database at a college is required to support the following requirments. complete the information level design for this set of requirments. Use your own experience to determine any constraints you need that are not stated in the problem. represent the answer in DBDL.
A. for a department, store its number and name.
B. for an advisor, store his or her number and name and the name and number of the department to which he or she is assigned.
C. for a course, store its code and description (for example, MTH110 or Algebra)
D. for have more than one advisor a student, store his or her number and name, for each course the student has take, store the course code and course description, and the grade recieved. in addition, store the number and name of the students advisor. Assume that an advisor may advise any number of students but that each student has just one advisor.
E. then List the changes that would need to be made if a student could have more than one advisor.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started