eemployment-h100
ee_logo_90
Index of the Handbook Index of the Lesson First Page Previous Page Next Page Last Page Objectives of the Lesson Download Questions Bibliography of the Lesson Knowledge Consolidation Page Assistent
Movie Quizzes of the Lesson 50
9 / zyxxyz en-language

1.1. Setting up a database

Now you have a database. You can start to organize it into tables.

 

For your "estore_db" database, you need four tables:

         "members" -  table with informations about members(customers)

         "products" -  table with informations about products

         "orders" -  table with informations about customer’s orders

         "orders items" -  table with informations about ordered items (products)

 

In addition, for each table you need fields.

 


Index of the Handbook Index of the Lesson First Page Previous Page Next Page Last Page Objectives of the Lesson Download Questions Bibliography of the Lesson Knowledge Consolidation Page Assistent Movie Quizzes of the Lesson
This project has been funded with the support of the European Community. The contect of this project does not necessarily reflect the position of the European Community or the National Agency, nor does it involve any responsability on their part.