Lets consider the information that your school tracks for a class. In this instance, a class is a scheduled course. For example, your school may have FINA 2100 Introduction to International Financial Markets as a course. If the school offers it in the fall, then it becomes a class. Below, weve provided many pieces of information that your school probably tracks about the class. First, which is the primary key (place an X in the second column)? Second, for each piece of information, identify if its a foreign key (a primary key of another file). If it is, write down the filename in the third column. Finally, in the fourth column for each piece of information, write down any integrity constraints you can think of. For example, can it be blank, or must it contain something? Can it be duplicated across multiple records (classes)? If its a number, does it have a specific range in which it must fall? There are many others.

INFORMATION FOREIGN KEY? PRIMARY KEY? INTEGRITY CONSTRAINTS E.g., Short Text E.g., Department File Department Designation Course Number Course Name Course Description Prerequisite Number of Credit Hours Lab Fee Instructor Name Room Number Time of Day Day of Week