Using Figure P$2\mathrm{.}6$ as your guide, work Problems $6-8.$ The Tiny College relational diagram shows the initial entities and attributes for the college.

FIGURE P$2\mathrm{.}6$ THE TINY COLLEGE RELATIONAL DIAGRAM

OURSE

$7$ CRS$\_$CODE

DEPT$\_$CODE

CRS$\_$DESCRIPTION

CRS$\_$CREDIT

CLASS

$8$ CLASS$\_$CODE CRS$\_$CODE

CLASS$\_$SECTION

CLASS$\_$TIME

CLASS$\_$ROOM

PROF$\_$NUM

ENROLL

$8$ CLASS$\_$CODE

$8$ STU$\_$NUM

ENROLL$\_$GRADE

STUDENT

$7$ STU$\_$NUM STU$\_$LNAME STU$\_$FNAME

STU$\_$INIT

STU$\_$DOB

STU$\_$HRS

STU$\_$CLASS STU$\_$GPA

STU$\_$TRANSFER

DEPT$\_$CODE STU$\_$PHONE PROF$\_$NUM

$6.$ Identify each relationship type and write all of the business rules.

$7.$ Create the basic Crow's Foot ERD for Tiny College.

$8.$ Create the UML class diagram that reflects the entities and relationships you identified in the relational diagram.