ify"> `Cargo` CHAR (10),
`Car` CHAR (8),
`Driver work onemployee empNum` CHAR (10), constraint` Transporting_PK` primary key (`trNum`)); table` Route` (
`RtName` CHAR (25),
`RtNum` CHAR (10),
`RtLength` INTEGER,
`RtRate` INTEGER, constraint` Route_PK` primary key (`RtName`)); table` Repair` (
`rpNum` CHAR (10),
`Mechanic` CHAR (10),
`Car` CHAR (8),
`RepDate` CHAR (10),
`RepDescription` CHAR (40), constraint` Repair_PK` primary key (`Mechanic`,` rpNum`)); table `Employee` (
`empNum` CHAR (10),
`EmpFName` CHAR (15),
`EmpSName` CHAR (15),
`EmpMName` CHAR (15),
`EmpDoB` DATETIME,
`EmpDateOfEmployment` DATETIME,
`EmpTown` CHAR (15),
`EmpStreet` CHAR (15),
`EmpBuilding` CHAR (7),
`EmpRoom` CHAR (4), constraint` Employee_PK` primary key (`empNum`)); table` Mechanic` (
`empNum` CHAR (10),
`MhGarageNum` CHAR (2), constraint` Mechanic_PK` primary key (`empNum`)); table` Measure` (
`MsName` CHAR (3),
`MsTypeOfCargo` CHAR (10), constraint` Measure_PK` primary key (`MsName`)); table` Foreman` (
`empNum` CHAR (10),
`FrDiplomNum` CHAR (8),
`FrDiplomSeries` CHAR (2), constraint` Foreman_PK` primary key (`empNum`)); table` Driver` (
`empNum` CHAR (10),
`DrLicenseNum` CHAR (10),
`DrLicenseDate` DATETIME,
`Team` CHAR (15), constraint` Driver_PK` primary key (`empNum`)); table` Cargo` (
`crgNum` CHAR (10),
`CrName` CHAR (10),
`CrSize` CHAR (10),
`CrTipe` CHAR (10),
`Measure` CHAR (3), constraint` Cargo_PK` primary key (`crgNum`)); table` Car` (
`CarLicenseNum` CHAR (8),
`Driver` CHAR (10),
`CarModel` CHAR (15),
`CarTipe` CHAR (15),
`CarDoM` DATETIME,
`CarMileage` INTEGER,
`CarFuelPer100km` DOUBLE, constraint` Car_PK` primary key (`Driver`,` CarLicenseNum`)); table `Team`constraint` Foreman_Team_FK1` foreign key (
`Foreman`)` Foreman` (
`empNum`); table` Transporting`constraint `Route_Transporting_FK1` foreign key (
`Route`)` Route` (
`RtName`); table` Transporting`constraint `Cargo_Transporting_FK1` foreign key (
`Cargo`)` Cargo` (
`crgNum`); table` Transporting`constraint `Car_Transporting_FK1` foreign key (
`Driver work onemployee empNum`,
`Car`)` Car` (
`Driver`,
`CarLicenseNum`); table` Repair`constraint `Car_Repair_FK1` foreign key (
`Mechanic`,
`Car`)` Car` (
`Driver`,
`CarLicenseNum`); table` Repair`constraint `Mechanic_Repair_FK1` foreign key (
`Mechanic`)` Mechanic` (
`empNum`); table` Mechanic`constraint `Employee_Mechanic_FK1` foreign key (
`empNum`)` Employee` (
`empNum`); table` Foreman`constraint `Employee_Foreman_FK1` foreign key (
`empNum`)` Employee` (
`empNum`); table` Driver`constraint `Team_Driver_FK1` foreign key (
`empNum`,
`Team`)` Team` (
`Foreman`,
`TmName`); table` Driver`constraint `Employee_Driver_FK1` foreign key (
`empNum`)` Employee` (
`empNum`); table` Cargo`constraint `Measure_Cargo_FK1` foreign key (
`Measure`)` Measure` (
`MsName`); table` Car`constraint `Driver_Car_FK1` foreign key (
`Driver`)` Driver` (
`empNum`);
.3 Перевірка моделі помощью правил нормалізації
Нормалізація - метод создания набору отношений Із завданні властівостямі на Основі вимог до ...
