Here is a sample data organization for part of a university database. Each word that is in all capitals represents a database record type. You may find it easier to think of each as a separate table or file. Within each record type, the other words represent attributes (descriptive information) stored with each record. Thus, a DEPARTMENT record contains the DeptName, Office, Phone, Url, NumStudents, and StudentIDs (for the students in the department). You can picture the DEPARTMENT record as a table with one column for DeptName, one column for Office, and so on. This is *not* a good organization. You should try to think of what kinds of problems we might run into when using such an organization. STUDENT DEPARTMENT CLASS FINANCIAL_AID ------- ---------- ----- ------------- StudentID DeptName Program StudentID SocSecNum Office CourseNum LastName LastName Phone Title FirstName FirstName Url Year MiddleInitial MiddleName NumStudents Quarter Address Freshman StudentIDs Instructor Balance Sophomore Room Junior Senior Graduate Male Female Major DeptChair BUILDING -------- Name