Introduction to Databases

Case Study

1.      Determine, on paper, the tables you will need for your database. Your purpose was defined in the previous information into subjects. Each subject will be a table in your database.

2.      Create a new database and name it "first name initial + last name.".

Define Primary Key. Define Foreign Key. Define a "relationship" between two or more tables.

3.      Set a Primary Key

4.      Set Format Properties

5.      Set Field Size Properties for Text Fields

6.      Set the Foreign Key

7.      Create a relationship between the tables

8.      Create a New Query

9.      Using Criteria to Select Records