Assignments

__**Assignment # 1 - Due on December 2, 2010**__ //Create a visual representation of the organic database that shows the primary key-foreign key relationships of the tables. Post this image to your wikispace and write a brief description of what the table represents.//



This table represents the primary-foreign key relationships present in the organic shop database found here.

The red cells are the primary key(s) of the table, whose title is highlighted yellow (i.e. the primary key of ORDERS is ORDERNBR ). The green cells are the foreign keys of the table (i.e. the foreign keys of EMPLOYEE are STORE and MANAGER ). The blue keys are simply attributes (i.e. ORDERDATE and CUSTOMERID of the ORDERS table are simply attributes).

The arrows point to keys in other tables that have the same entries (or limits the entries) to the ones given in that key. For instance, the NUMBER key in EMPLOYEE, HOURLY_EMPLOYEE, CONSULTANT and SALARIED_EMPLOYEE are related, because the NUMBER key entries are based on what is found in the EMPLOYEE table. In a way, the primary keys can be foreign keys at the same time.