CS224 Chapter 4 Notes

• ❑ Preparations: Selecting the Database's Storage Location
• ❑ Creating the New Database
• ❑ Creating the Tables within the Database Structure
• ❑ Creating Fields for the Table
• ❑ Saving the Table and Setting the Primary Key
• ❑ Modifying the Table Structure
• ❑ Date Fields: Data Formats and the Millenium Bug Problem
• ❑ Controlling Data Input: Validation, Input Masks, and Default Values
• ❑ Indexes
• ❑ Data Entry
• ❑ Edit and Delete
• ❑ Editing Table Components
• ❑ Deleting and Inserting Fields
• ❑ Editing the Table Contents
• ❑ Deleting Records
• ❑ Deleting Tables
• ❑ Importing and Exporting Tables
• ❑ Creating Relationships Between Tables
• ❑ The Equijoin
• ❑ Referential Integrity Enforcement and Field Properties: Unintended Consequences?
• ❑ Editing the Relationships
• ❑ Managing the Effects of the Relationshiops
• ❑ Outer Joins