The instructor for your database course that an excellent way to understand is to apply them to a situation with which all students are familiar, Use the and presented in this chapter to design a database to meet the following A database for a college must support the following requirements: a. For a department, store its name. b. For an store his or her number, last name, first name, and the department number to which the advisor is assigned. c. For a course, store its code and description, for example, CIS 101. d. For a student, store his or her number, first name, and last name. For each course the student takes, store the course code, the course description, and the grade earned. e. Also store the number and name of the student's advisor, Assume that an advisor may advise any number of students, but that each student has just one advisor. Use your own experience as a student to determine any functional dependencies. 2. Based on these requirements: a. Identify and list the entities and the attributes of those entities. b. Identify and list the functional dependencies. c. Create a set of 3NF relations using the shorthand notation given in the chapter. Be sure to identity all primary keys and foreign keys appropriately. Submit your database design in the format specified by your instructor