实体：
管理员、导游、订单、游客
属性：
订单：订单号、时长、费用、人数
游客：身份证号、姓名、年龄、性别
导游：身份证号、姓名、年龄、性格
管理员：管理员ID
其中有下划线的订单号，身份证号，管理员ID是他们的主键属性，此属性唯一对应；订单的人数属性是多值属性，一次订单可涉及多个游客。
关系
实体之间的关系是游客产生订单，管理员发布订单，导游接受订单，其中对应的数量关系是：一批游客产生一个订单，管理员可同时发布多个订单，都有可多次接受订单。管理员与导游之间有管理关系，一个管理员管理多名导游，游客可对服务的导游产生多条评价。
Model
Entity:
Administrators, tour guides, orders, tourists
Properties:
Order: order number, duration, expense and number of people
Tourist: ID number, name, age, gender
Guide: ID number, name, age, personality
Administrator: administrator ID
Among them, the underlined order number, ID number, administrator ID is their primary key attribute, and this attribute is unique. The number of people attribute of the order is a multi value attribute. One order can involve multiple tourists.
relationship
The relationship between entities is that tourists generate orders, administrators publish orders, and tour guides accept orders. The corresponding quantitative relationship is: a batch of tourists generate one order, administrators can publish multiple orders at the same time, and all orders can be accepted multiple times. There is a management relationship between the administrator and the tour guide. One administrator manages multiple tour guides, and tourists can produce multiple comments on the tour guides served
参考资料：百度百科
翻译：Google翻译
文中部分图片和文字均来源于网络，如有侵权请联系删除！
版权声明：本文转载于今日头条，版权归作者所有，如果侵权，请联系本站编辑删除