Answer Happy

(1) Complete the logical database design. Check the direction of the relationship given in the Class Diagram on the next page. Fill-in the blanks CharID deptideptID, deptName, officePhone p fact factD, facName, higherDegree, majorimajoriD, majorName, totalCredits courses/cours!D coursePrefix, courseCode, courseDescription, requiredCourses(majoriD, courstD) We need one more table: Write the table outline and underline the primary keys. (2) Design the relationships. Note the navigational directions given in the relationships. For example, the application includes a functionality that requires to find the chair, if a department is given; not in the reverse direction. If there is no direction given then the relationship it is bi-directional. The relationships between Faculty and Department is already designed- that is, required attributes are included in the classes to represent the relationships "belong-to" and "chair". Fill in the 5 blanks (??) with suitable attributes to design other relationships.