Traditional Databases

Describe how you would follow the three phases of the traditional database design method, considering the following scenario. Feel free to make some assumptions and/or sample data to complete the process. Be sure to detail all your answers.

Fernando Culebra has always been fascinated by skateboards. Fernando has won several contests, both locally and nationally. His interest in skateboards led him to open Fernando's Skate Shop in Denton, Maine. Fernando sells street, trick, and children's skateboards. The store has only been open for a couple of months, yet sales have been very high. Recently, Fernando has come to realize that he will need some help to manage the information his business is creating. He has contacted you to help him design a database.

After meeting with Fernando, you have learned that he purchases the skateboards he sells from three suppliers, but he plans to add new suppliers in the near future. Fernando has realistic expectations that his business will continue to grow, and soon, he will be unable to manage the information on suppliers and products. He realizes the database will need to contain two tables: a supplier table and a product table. He also knows that there will be have to be a relationship between the two tables. Now, he needs your help to complete the design.