MySQL-driven Web Site Construction (Cont.)
  1. Database Design
    2.  Relational database design uses either one of the two methods:

    • Entity-relationship modeling, dividing your database in two logical parts, entities (such as “customer” and “product”) and relations (such as “buys” and “pays for”).

    • Normalization, a series of steps followed to obtain a database design that allows for efficient access and storage of data in a relational database.

    Since the number of database tables may not be high for this exercise, you do not need to use the above methods. Instead, a scratch paper may be enough after studying the exercise specifications very carefully.
  1. Database Implementation Using MySQL Workbench (SQL)
    2.  MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation, and maintenance into a single integrated development environment for MySQL.


    †Note that this database implementation is only an example and it is not related to this exercise.