admin 管理员组

文章数量: 1087675


2023年12月22日发(作者：rawhide)

大作业名称：数据库概念设计-类图

一、 目的与要求

依据下面的需求分析进行数据库概念设计（使用类图）和逻辑设计（类图转化为关系模型）。

1. Bank database:

A bank database involves customers and accounts:

For the customers, there is information of their names and addresses.

For the accounts, there is information of their numbers and balances.

Customers may have several accounts.

Accounts may be held jointly by several customers.

① 概念设计（类图）：

② 逻辑设计（关系模型）：

Customer (ID, name, address)

Account (number, balance)

Has (ID, number)

2. Shop database:

There is a shop with the following information:

Staff: ID, name, address, branch(shop_branch)

Branch: ID,name,staff, manager, merchandise(商品)

Merchandise: ID, name, factory, price, model(defined by the

internal_ID(defined by the shop)

Factory: ID, name, address, price

① 概念设计（类图）：

factory),

② 逻辑设计（关系模型）：

Staff (sID, sname, saddress, bID)

Branch (bID, bname, baddress)

Merchandise (mID, mname, bID, Internal_ID, price1)

Factory (fID, fname, faddress)

Produce (mID, fID, price2, model)

3. Airport database:

keeps track of airplanes, their owners, airport employees and pilots.

Each airplane has a registration number, is of a particular plane type and is stored in a

particular hanger（机库）. Each plane type has a model number, capacity and weight.

Each hanger has a number, capacity and location. The database also keeps track of

who owns which plane. Persons have name, address and phones. A person buys a

plane on a particular date and cost.

Each plane undergoes service many times. A service information contains date of

work, nature, hours spent, cost, etc. Pilots and employees are persons. Pilots have

a license number with validity and salary. Employees have a number, rank and

salary. Each pilot is authorized to fly certain types of planes. Employees are

involved in servicing of planes.

① 概念设计（类图）：

② 逻辑设计（关系模型）：

Plane (reg_no, number, model_no, pID, date, cost)

Hanger (number, capacity, location)

Person (pID, name, address, phone)

Service (sID, date, nature, hours, cost, reg_no)

Employee (number, pID, rank, salary)

Involve (sID, pID, number)

Type (model_no, weight, capacity)

Pilot (pID, salary, License_no)

Fly (pID, model_no)

License (License_no, vadility)


本文标签： 概念设计 类图 数据库

版权声明：本文标题：广东工业大学数据库设计作业 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.roclinux.cn/p/1703242229a443726.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。