Shop LZK - discuss objects and attributes needed and create tables for these

[surfmuggle]

We have discussed the objects needed for the Shop LZK.

1. Please discuss them further and decide together which object names you are going to use and create tables for these object
2. Discuss also which relations (1 to 1, 1 to many, many to many) should exist between the tables
3. How can you enforce relations between records in different tables?
4. To create the tables please discuss what attributes (which columns) are needed for the tables
5. Please commit the create sql statements to your own LZK repository
6. Please commit some records with Insert Statements