设有员工实体Employee(employeeID,name,sex,age,tel,department)，其中employeeID为员工号，name为员工姓名，sex为员工性别，age为员工年龄，tel为员工电话(要求记录该员工的手机号码和办公室电话)，departID为员工所在部门号(要求参照另一部门实体Department的主码departID)。

Employee实体中存在的派生属性及其原因是(51)；对Employee实体中属性departmentID的约束是(52)。

(85)

(84)

(82)

(83)

Microsoft's COM is a software(71) that allows applications to be built from binary software components. COM is the underlying architecture that forms the foundation for higher-level software services, like those provided by OLE. COM defines a binary standard for function calling between components, a way for components to dynamically discover the interfaces implemented by other components, and a mechanism to identify components and their interfaces uniquely.

 OLE is a compound(72) standard developed by Microsoft. OLE makes it possible to create(73) with one application and link or embed them in a second application. Embedded objects retain their original format and(74) to the application that created them. Support for OLE is built into the Windows and MacOS Operating Systems. A(75) compound document standard developed mainly by Apple and IBM is called OpenDoc.

(80)

某商场的部门、员工和商品3个实体之间的关系如图5-7所示。假设每个部门有若干名员工，每种商品只能由一个部门负责销售。如果用户要求得到如表5-7所示的结果，则需要(52)，并增加关系模式(53)。如果要求查询某部门负责销售的商品，则需要(54)。

(79)

(77)

(76)