数据库规范化需要信息

13 浏览
0 Comments

数据库规范化需要信息

我从数据库中获取了一种视图

非规范化：

(CustomerID, Firstname, Lastname, Address, City, Province, Postalcode, Prepaidtip, Routeid, Routename{PaperIDDescription, DeliveryTypeID, Deliverytypedescription, Deliverytypecurrentcharge}

第一范式：

(CustomerID, Firstname, Lastname, Address, City, Province, Postalcode, Prepaidtip, Routeid, Routename)

(PaperIDDescription, CustomerID, DeliveryTypeID, Deliverytypedescription, Deliverytypecurrentcharge)

第二范式：

Customer(CustomerID, Firstname, Lastname, Address, City, Province, Postalcode, Prepaidtip)

Route(CustomerID, PaperIddescription, RouteID, Routename)

Delivery(PaperIDDescription, DeliveryTypeID, Deliverytypedescription, DeliveryTypeCurrentCharge

第三范式：无更改。

  • 加粗的列是主键
  • 斜体是外键
  • 斜体+加粗是两者兼有
  • "{}"代表重复组。

我的规范化看起来正确吗？

0