database design

Create Indexes for Natural, Foreign Key, and Frequently Queried Columns 

Unlike primary keys that have unique indexes created automatically, you must create indexes forever natural key that is not included in the primary/composite key as well as all foreign keys and frequently queried columns. Note: you may not yet have queries built for your database yet but you will during project part 4. Keep this in mind as you will need to create indexes to support these queries.

Create a Minimum of Two Views

You are required to create at least two views though it is recommended that you create the number of views that are most appropriate to support your business requirements.