October 29, 2009 at 4:35 pm
I need help. I want to create an inventory database for a cigarrette store. Here are the different products sell in this store and I need help creating the tables and relationship. Please help.
1. Products
>a. Cigarrettes
>b. Snow_Cones
>c. Soda_Drinks
>d. Candies
>e. Chips
>f. Cig_Lighters
>
>2. Cigarrettes
>a. Brand
>b. Type
>c. Price
>d. Qty
>3. SNOW_CONES TABLE
>a. Flavor
>b. Cups
>c. Spoon
>d. Ice
>e. Price
>f. Qty
>4. SODA_DRINKS TABLE
>a. Type
>b. Price
>c. Qty
>5. CANDIES TABLE
>a. Type
>b. Price
>c. Qty
>6. CHIPS TABLE
>a. Type
>b. Price
>c. Qty
>7. CIG_LIGHTERS TABLE
>a. Price
>b. Qty
Here's what I have so far:
PRODUCT TABLE
ProductNo
ProductName (PK)
ITEM TABLE
ItemNo (PK)
ProductName (FK)
Brand
Type
Package_Qty
Single_Qty
Price
October 29, 2009 at 4:38 pm
So it almost appears this is an assignment of some sort. We don't do homework for you. If you have a specific question, or you are wondering if there is an issue with a design, we can help. But we do not do this for you. If it's homework, this is unethical. If it's for work, then you are looking for consulting help.
October 29, 2009 at 6:32 pm
Steven, you will not help me because you think this is either my homework or work related....why are you or how did you even sign up to be in the admin group? I layout the data, did 80-90%, and just asking you to check and maybe give me some advises/ideas......and all I received from you is ....... thanks for your help, sir!!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply