|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Friday, October 30, 2009 5:18 AM
Points: 2,
Visits: 2
|
|
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
|
|
|
|
|
SSChampion
Group: Administrators
Last Login: Today @ 10:32 AM
Points: 21,891,
Visits: 6,104
|
|
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.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Friday, October 30, 2009 5:18 AM
Points: 2,
Visits: 2
|
|
| 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!!
|
|
|
|
