Hey everyone...first time poster here. I'm a college student attending for the IT side of business...db's, network admin, programming...stuffs like that.
Anyways, we have to do an assignment for a database in Access 07 that involves this:
Prepare a database of items of value(furniture, jewelery, cars, etc) their locations(bedroom, hallway, bathroom, etc) the material they are made from(wood, metal, plastic, etc) and the purchase date and purchase price.
My main problem with databases is the relationship table. Whenever I do them, they always end up being a spider...with one massive join table.
I've stared at this for like an hour and can not seem to get around doing it again. It has to be normalized, no repeating values, avoid transitive dependencies, etc etc.
I have it set up like this(table wise) locationtbl, materialtbl, categorytbl, itemtbl. Included in the itemtbl are purchase price & date.
This brings me to my question. I'm not asking you to tell me how to do this assignment, just throw out some pointers as to table/relationship setups.
I have it right now that location, material and category all link into the item table(relationship wise).
It just doesn't look right to me. If anyone has some juicy tidbits of info or wisdom they could slide my way..rock on.
Thanks!
Anyways, we have to do an assignment for a database in Access 07 that involves this:
Prepare a database of items of value(furniture, jewelery, cars, etc) their locations(bedroom, hallway, bathroom, etc) the material they are made from(wood, metal, plastic, etc) and the purchase date and purchase price.
My main problem with databases is the relationship table. Whenever I do them, they always end up being a spider...with one massive join table.
I've stared at this for like an hour and can not seem to get around doing it again. It has to be normalized, no repeating values, avoid transitive dependencies, etc etc.
I have it set up like this(table wise) locationtbl, materialtbl, categorytbl, itemtbl. Included in the itemtbl are purchase price & date.
This brings me to my question. I'm not asking you to tell me how to do this assignment, just throw out some pointers as to table/relationship setups.
I have it right now that location, material and category all link into the item table(relationship wise).
It just doesn't look right to me. If anyone has some juicy tidbits of info or wisdom they could slide my way..rock on.
Thanks!
