学生管理系统数据库设计报告

5.数据库设计

5.1概念结构设计

5.1.1 整体关系图如下：

PaymentMethod pMethodFor Invoice PartOf Product Customer Places Order Raises Has OrderDetail ShipmentMethod sMethodFor Employee Prepares Shipment Processes PackagedIn

客户订购登记 E-R图

5.1.2 各个实体及其属性：

（1）实体Customer及其属性： customerNO creditRating customerName maritalStatus customerStreet DOB Customer customerCity custTelNo customerState custFaxNo customerZipCode

（2）实体Employee及其属性： employeeNo dateStartetitle salary sex position Employee firstName middleName lastName DOB address

（3）实体Invoice及其属性：

expiryDate

orderNo

pMethodNo

（4）实体Order及其属性： customerNo status promiseDate billingZipCode holdersName creditCardNo Invoice datePaid dateRaised invoiceNo employeeNo orderNo orderDate Order billingStreet billingState billingCity

（5）实体OrderDetail及其属性： productNo orderNo quantityOrdered

OrderDetail

（6）实体PaymentMwthod及其属性： pMethodNo paymentMethod PaymentMethod

（7）实体Product及其属性： reorderQuantity reorderLeadTime reorderLevel Product productNo quantityOnHand productName unitPrice serialNo

（8）实体Shipment及其属性：

sMethodNo employeeNo shipmentNo productNo Shipment

（9）实体ShipmentMethod及其属性： sMethodNo shipmentMethod

ShipmentMethod

5.2逻辑结构设计

根据实验中提供的条件，确定该实验中涉及的实体及其属性定义如下：

Customer

Employee Invoice Order

(customerNo,customerName,customerStreet,customerCity, customerState,customerZipCode,custTelNo,custFaxNo,DOB, maritalStatus,creditRating）

(employeeNo,title,firstName,middleName,lastName,address, workTelExt,homeTelNo,empEmailAddress,socialSecuritNumber, DOB,position,sex,salary,dateStarted)

(invoiceNo,dateRaised,datePaid,creditCardNo,holdersName, expiryDate,orderNo,pMethodNo)

(orderNo,orderDate,billingStreet,billingCity,billingState, billingZipCode,romisedDate,status,customerNo,employeeNo)

(orderNo,productNo,quantityOrdered)

OrderDetail