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
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