Create the basic crows foot erd for tiny college

Chapter 2 Data Models

Chapter 2

Each customer has only one agent.

Given these business rules, you can conclude that there is a 1:M relationship between AGENT and CUSTOMER.

1

Chapter 2 Data Models

5. Create the basic Crow’s Foot ERD for DealCo.

The Crow’s Foot ERD is shown in Figure P2.5a.

	We have added an attribute, ENROLL_SEMESTER, to identify the enrollment period. Naturally, no grade has yet been assigned when the student is first enrolled, so we have entered a default value “NA” for “Not Applicable.” The letter grade – A, B, C, D, F, I

(Incomplete), or W (Withdrawal) -- will be entered at the conclusion of the enrollment period, the SPRING-10 semester.

STU_NUM	CLASS_CODE	ENROLL_SEMESTER	ENROLL_GRADE
11324		SPRING-10	NA
11324		SPRING-10	NA

2

Chapter 2 Data Models

All of the relationships are 1:M. The relationships may be written as follows:

COURSE generates CLASS. One course can generate many classes. Each class is generated by one course.

The OO Model for Tiny College (UML Class Diagram will be written on the

board in class.)

Figure P2.13 The Crow’s Foot ERD for Problem 13 The business rules may be written as follows:

• • • •