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

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

1 Expert Approved Answer
Step: 1 Unlock

To address the problems lets break it down into steps 1 Identify each relationship type and write al... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!