2.3 A SAMPLE DATABASE
We will use a sample database, CSE _ DEPT, to illustrate some essential database concepts.
Tables 2.1~2.5 show sample data Tables stored in this database.
FIGURE 2.1 Records and fields in a Table.
The data in CSE _ DEPT database is stored in five Tables—LogIn, Faculty, Course, Student and StudentCourse. A Table consists of rows and columns (Figure 2.1). A row represents a record, and a column represents a field. A row is called a tuple, and a column is called an attribute. For example, the Student Table has eight columns or fields—student_id, student_name, gpa, credits, major, schoolYear, email and simage. It has five records or rows.