Tiny College

Running Head : TINY COLLEGE

Tiny College

[Name of the writer]

[Name of the institution]

[Name of the Professor]

Tiny College

In the Tiny College Relational Diagram , all of the relationships between the entities are 1 :M (one to many

Figure 1 . Tiny College Relational Diagram (Rob , 2007

The relationships and the business rules are explained below

COURSE : CLASS (1 :M

The CLASS is generated because of the COURSE . There can be multiple number of classes of a single course . On the other hand , each CLASS teaches a

single COURSE only . A single CLASS cannot teach more than one COURSE at a time

CLASS : ENROLL (1 :M

ENROLL is the table in which classes are referenced . The ENROLL table can have many instances of a class . This is because different students can take the same class . That is why ENROLL is also related to STUDENT table

STUDENT : ENROLL (1 :M

Each entry in the ENROLL table is linked to a STUDENT and the CLASS for which the student has enrolled . A class cannot have two instances of the same student . However ,if a student takes for example three classes , then the ENROLL table will have three instances of the student each with a different class . This explains the 1 :M relationship between ENROLL and STUDENT

Following is an example of the flow of the relation diagram confirming all the business rules . I have created the tables shown in the relational diagram and populated them with data

Sample Contents of an ENROLL...