Relationships

[ansentry]

I have following and would like someone to check to see if the setup is OK. If I have not explained clearly, let me know and i will post a sample db.




tbl_deliverydates

deliverydateID (PK)
DeliveryDate

One DeliveryDate can have many Vehicles

tbl_vehicles
vehicleID (PK)
deliverydateID (FK)
other fields......

One vehicle can have many PrepItems ( This table is for the "Many" items that are added to each new vehicle before delivery)


tbl_prepitems
prepitemsID (PK)
vehicleID (FK)
other fields....


or should it be


The same as the "northwind"

tbl_deliverydate = Orders
tbl_vehicles = Order Details
tbl_prepitems = Products



I don't understand why in Northwind the Orders PK has the same name as the Order Details PK and
why the table Order Details has 2 PK's. If someone could look at my table setup and explain about Northwind I would be grateful




Regards,

 

[FoFa]

Unless your delivery dates table is driving which dates can be used, it appears you could do away with it, if it is driving usable dates (like work days, etc.) than it is ok. I think your key relationship is fine otherwise.