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.



      “The man who says his wife can’t take a job,    
      forgets that she took him.”    
      ― Oscar Wilde