如何设置RDBMS的发货和收货表？

Question

好的，我是一名学生，对数据库的经验非常有限，但我正在为一家航运公司的一项任务建立表。目前我有以下10个表with attributes：

Table1 
======
Customer[PK - CustId, CustAddressId(FK from table "Address"), CustBusName,....], 

Table2 
======
PU_Man [PK - PUManId, PUDate, PUComments, PUPackageId (FK from table "Package"), 
PUCustId (FK from table "Customer"), PUDTID (FK from table DriverTruckRef)]

Table3 
======
Del_Man [PK - DelManId, DelDate, DelComments, 
DelPackageId (FK from table "Package"), 
DelCustId (FK from table "Customer"), 
DelDTId (FK from table DriverTruckRef)]

Table4 
======
Truck [PK - TruckVin#, TimeLoggedOut, .....], 

Table5 
======
Driver [PK - DriverId, DriverFN, DriverLN, 
DriverRoute# (FK from table "Route"),....]

Table6 
======
DriverTruckRef [PK - DTId, DriverId (FK from table "Driver")]

Table7 
======
Address [PK - AddressId, 
AddressCustId (FK from Customer table), 
Address1, Address2, City, State, Zip]

Table8 
======
Package [PK - PackageId, PackagePUCondition, 
PackagePUProblems, PackageDelCondition, PackageDelProblems]

Table9
======
Route [PK - RouteId, AddressId (FFK from table "Address")]

Table10
=======
Payment [PK - PaymentId, 
PaymentCustomerId (FK from customer table), 
PaymentPackageId (FK from "Package" table), 
PaymentType, PaymentInfo, PaymentAmt, 
PaymentAddressId (FK from table "Address")]

我知道对于任何有经验的人来说，这可能是最简单的情况，但我希望有人能把这一块撕碎，这样我就能看到大局。在我的骄傲开始分解之前，我知道1:1/n:m/1:m/etc关系是不正确的，但我需要表的可视化表示，而Access是我必须使用的。PK/FK更是焦点所在。

另外，我在想，也许我也需要分解一下支付表。

任何批评和建议都将不胜感激。

Answer 1

也许这将帮助您入门--每一行都是一个表，表的细节被省略，重点放在键上

Customer
Customer*-Addresses*
Addresses
Packages
Destinations[Addresses,Packages]

DeliveryLog[Package,Driver,Route]
DeliveryAttemptLog[...]


Trucks
Trucks*-Drivers*
Drivers

Hubs
Hubs*-Trucks*
Hubs*-Drivers*
Locations[Packages,Hubs]
Loadings[Packages,Trucks]


Routes
Routes*-Addresses*

Packages*-Routes*

它可能会变得非常复杂，这取决于您想要的灵活性。