Figure 4-32 shows a class list for Millennium College. Convert this user view to a set o...

Explanation:

OBJECT (OID, ObjectType)

• In the above line, OBJECT is the relation; the attributes inside the relation are OID and ObjectType.

• Here, OID acts as a primary key as well as enterprise key, this key is unique across the database.

INSTRUCTOR (OID, InstructorName, InstructorLocation)

• In the above line, INSTRUCTOR is the relation; the attributes inside the relation are OID, Instructor Name and Instructor Location.

• Instructor Location is unique in the database, using the enterprise key OID, the instructor location and instructor name can be gathered.

COURSE (OID, CourseNumber, CourseTitle, InstructorName)

• In the above line, COURSE is the relation; the attributes inside the relation are OID, CourseNumber, CourseTitle and InstructorName.

• Using the enterprise key, OID, the data of course number, course title and instructor name can be retrieved from the database.

STUDENT (OID, StudentNumber, StudentName, Major)

• In the above line, STUDENT is the relation; the attributes inside the relation are OID, StudentNumber, StudentName and Major.

• Using the enterprise key, OID, the data from the student table such as student number, student name and the unique major can be retrieved from the database.

OUTCOME (OID, StudentNumber, CourseNumber, Grade)

• In the above line, OUTCOME is the relation; the attributes inside the relation are OID, StudentNumber, CourseNumber and Grade.

• Using the enterprise key, OID, the data from the outcome table such as student number, course number and the student grade can be retrieved from the database.