信息系统分析细设计.ppt

第11章 详细设计;本章内容;先导案例;概述;11.1 数据库设计;11.1.1 主键的生成;1. 将对象标识符映射为主键;带有关联类的大学课程注册类图;2. 将对象的某些属性映射为主键;11.1.2 属性类型到域的映射;11.1.3 类的属性到列的映射;11.1.4 类到表的映射;1. 所有的类均映射为DB中的表;Pilot ;2. 具有属性的类映射为DB表;employeeID;3. 将超类的属性下移;Pilot ;4. 将子类的属性上移;Pilot ;11.1.5 关联关系的映射 ;四种类间的关联;1. 多对多关联的实现[可选对可选(0..1 : 0..*)];flightID;2. 一对多关联的实现[强制对可选(1 : 0..*)];Flight;使用关联表;3. “零或一”对一关联的实现[可选对强制 (0..* : 1)];CompanyID;4. 一到一关联的实现[强制对强制(1..* : l..*)] ;5. UML模型的映射实例 航空公司的类图 ;航空公司的数据库表;CREATE TABLE Airline (airlineID integer CONSTRAINT nn_airline1 NOT NULL, name text(40) CONSTRAINT nn_airline2 NOT NULL, symbol text(10) CONSTRAINT nn_airline3 NOT NULL, CONSTRAINT PrimaryKey PRIMARY KEY(airlineID), CONSTRAINT uq_airline1 UNIQUE(name), CONSTRAINT uq_airline2 UNIQUE(symbol)); CREATE TABLE Flight (flightID integer CONSTRAINT nn_flight1 NOT NULL, flightNum text(10) CONSTRAINT nn_flight2 NOT NULL, date dateTime CONSTRAINT nn_flight3 NOT NULL, airlineID integer CONSTRAINT nn_flight4 NOT NULL, pilot integer CONSTRAINT nn_flight5 NOT NULL, copilot integer CONSTRAINT nn_flight6 NOT NULL, CONSTRAINT PrimaryKey PRIMARY KEY (flightID)); ALTER TABLE Flight ADD CONSTRAINT fk_flight1 FOREIGN KEY(airlineID)REFERENCES Airline ON DELETE NO ACTION; ALTER TABLE F1ight ADD CONSTRAINT fk_flight2 FOREIGN KEY(pilot)REFERENCES Pilot ON DELETE NO ACTION; ALTER TABLE Flight ADD CONSTRAINT fk_flight3 FOREIGN KEY(copilot)REFERENCES Pilot ON DELETE NO ACTION; CREATE INDEX index flight1 ON Flight(airlineID); CREATE INDEX index flight2 ON Flight(pilot); CREATE INDEX index flight3 ON F1ight(copilot); CREATE TABLE Employee (employeeID integer CONSTRAINT nn_employee1 NOT NULL, name text(40) CONSTRAINT nn_employee2 NOT NULL, taxpayerNumber text(20) CONSTRAINT nn_employee3 NOT NULL, employeeType text(20) CONSTRAINT nn_employee4 NOT NULL, airlineID integer CONSTRAINT nn_employee5 NOT NULL, CONSTRAINT PrimaryKey PRIMARY KEY(employeeID