Question: Using Figure 1 as your guide, work Problems 1-3 The Tiny College relational diagram shows the initial entities and attributes for Tiny College. COURSE
Using Figure 1 as your guide, work Problems 1-3 The Tiny College relational diagram shows the initial entities and attributes for Tiny College. COURSE CRS_CODE DEPT CODE CRS_DESCRIPTION CRS CREDIT CLASS CLASS_CODE CRS_CODE CLASS_SECTION CLASS TIME CLASS_ROOM PROF_NUM ENROLL CLASS_CODE STU_NUM STUDENT STU_NUM STU_LNAME ENROLL GRADE STU_FNAME STU_INIT STU DOB STU_HRS STU_CLASS STU_GPA STU_TRANSFER DEPT CODE STU_PHONE PROF NUM Figure 1.The Tiny College relational diagram 1. Identify each relationship type and write all of the business rules. 2. Create the basic Crow's Foot ERD for Tiny College. 3. Create the UML class diagram that reflects the entities and relationships you identified in the relational diagram.
Step by Step Solution
There are 3 Steps involved in it
To address the problems lets break it down into steps 1 Identify each relationship type and write al... View full answer
Get step-by-step solutions from verified subject matter experts
