Not sure if this is the right place to put this message but, I am creating a stock control system for pc componenets, and need some help normalising the data, so that i can then implement the database.
The attibutes which need normalising are:
ProductID
Component
Price
Stock_level
Minimum_level
Reorder_amount
SupplierID
Supplier_name
Address1
Address2
Address3
Postcode
County
Email
TelNo
OrderCode
Quantity
Date_of_Order
Price
Quantity
Date
Total
If anybody could show me how to normalise this to third normal form, and show first and second Normal form, i would be very grateful.Hello,
is this a kind of homework ?
Think about the objects in the table ... there are
products, suppliers, addresses, orders ... these are the main objects.
Therefore you need a product, supplierer, address and order table.
The question is the relations between each object ??
Are there many prices for one product ??
Are there many adresses for one supplier and so on and so on
The other question ist ... what do you want with the second normal form ? Never heard, that somebody use this to create a physical database model ?!?!?!!?
Regards
Manfred Peter
(Alligator Company GmbH)
http://www.alligatorsql.comsql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment