Relational model - help -

wxdqz

New Member
Hi.
I'm in trouble with sql relational model.

i have this database keeping track of products in my store:
+------------------------------------+
| prod_name| pr_code |category|manufacturer|quantity|
+------------------------------------+
| +
| +
+------------------------------------+

Is possible to organize it in a set of tables following the relational model (one table for categories, one for manufacturers etc ..?)

I noticed that many datas (like manufacturer and category) are redundant and repeated.

I'm new to dbs! any help/suggestion will be appreciated!

Paolo
 
Back
Top