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.