Viewing 10 posts - 16 through 25 (of 25 total)
customer has many orders
so customer is foreign key in orders table
a supplier suplies many stock
so supplier is a foreign key in stock table
right?
March 27, 2012 at 11:00 am
foreign keys to order and supplier and stock
March 27, 2012 at 9:53 am
Customer
Customer Forename
Customer Surname
Street
Town
Postcode
Category
Order
Order Date
description
price
qty ordered
Stock
Stock Description
Price
Qty in Stock
i have a price in stock and order shall i take out the one in stock
Supplier
Supplier Name
Supplier Address
Supplier Town
Supplier...
March 27, 2012 at 7:08 am
qty ordered
description - what product was ordered
March 27, 2012 at 7:04 am
what else can i put in there as i have to make this up
i want to keep it simple as possible
what is my 1nf 2nd 3nf
March 27, 2012 at 6:39 am
Customer
Customer Forename
Customer Surname
Street
Town
Postcode
Category
Order
Order Date
Stock
Stock Description
Price
Qty in Stock
Supplier
Supplier Name
Supplier Address
Supplier Town
Supplier Postcode
Supplier Tel No
March 27, 2012 at 6:29 am
Viewing 10 posts - 16 through 25 (of 25 total)