database design

  

You are a book store chain like Barnes and Nobles or 2nd and Charles.

You decide that your current application is not up to date anymore and is not serving your company like it should. To gain more speed and agility you decide to create a new application that will allow for customers to search and buy books online, but also in the store, rang out through a sales person.

The new application will need an up to date database. Design the database so books can be searched very quickly and everything goes fast.

 

• Step 1: Define the Purpose of the Database (Requirement Analysis) ...
• Step 2: Gather Data, Organize in tables and Specify the Primary Keys. ...
• Step 3: Create Relationships among Tables. ...
• Step 4: Refine & Normalize the Design