当前位置:网站首页>[csnote] ER diagram
[csnote] ER diagram
2022-04-23 12:37:00 【Review of the white speed Dragon King】
【ER chart 】
entity-relationship, There are three components : Entity 、 attribute 、 Chain system
Used for relational dbs The conceptual design of
【 Three connections of entities 】
Including one-on-one 、 One to many 、 Many to many three
If A To B It's a one to many relationship , Then draw a line with an arrow pointing to B
If it's one-on-one , Draw two lines with arrows
If it's many to many , Draw two lines without arrows
( Pointed at 1?)
【 It means that there are many relationships 】
How many times does an entity appear in the chain , It's going to take a couple of lines to connect .
The following figure shows the prerequisite relationship of a course , There are two in the priori relationship Course Entity , The first is to repair first, and the second is to repair later , Two lines should be used to represent this relationship :
【 The multidirectionality of connections 】
Although teachers can offer many courses , And teach multiple students , For specific students and courses, only one teacher teaches , This is enough to become a ternary connection
【 Denotes a subclass 】
Use a triangle and two lines to represent classes and subclasses , The attributes and connections related to subclasses are connected , And related to parent and child classes, even the parent class
版权声明
本文为[Review of the white speed Dragon King]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204231233448304.html
边栏推荐
- How do programmers finalize nucleic acid statistics with 130 lines of code
- 甲辰篇 創世紀《「內元宇宙」聯載》
- 航芯技术分享 | ACM32 MCU安全特性概述
- BUUCTF WEB [BJDCTF2020]ZJCTF,不过如此
- Debug Jest test cases in VSCode, debug Jest test cases in VSCode, middle note basedir=$(dirname "$" (echo "$0" sed -e -e, s, \ \, / "-e").
- The database navigator uses the default MySQL connection prompt: the server time zone value 'Ö Ð¹ ú±ê ×¼ ʱ ¼ ä’ is unrecognized or repres
- 洛谷P3236 [HNOI2014]画框 题解
- bert-base-chinese下载(智取)
- Zigbee之CC2530最小系统及寄存器配置(1)
- Qt双缓冲绘图
猜你喜欢
没有空闲服务器?导入 OVF 镜像快速体验 SmartX 超融合社区版
基于卷积神经网络的遥感影像分类识别系统
网站首页文件被攻击篡改的形式有哪些
Fastjson 2 来了,性能继续提升,还能再战十年
Try the server for one month for free, and attach the tutorial
Aviation core technology sharing | overview of safety characteristics of acm32 MCU
SSL证书退款说明
编程辅助工具推荐:图片工具snipaste
如何防止网站被黑客入侵篡改
为什么要有包装类,顺便说一说基本数据类型、包装类、String类该如何转换?
随机推荐
[redis series] redis learning 13. Redis often asks simple interview questions
Uni app native app local packaging integrated Aurora push (jg-jpush) detailed tutorial
Why is the premise of hash% length = = hash & (length-1) that length is the nth power of 2
Stacks and queues a
Realize several "Postures" in which a box is horizontally and vertically centered in the parent box
QT redraw events and cuts
力扣刷题之完全二叉树的节点个数
Metalama简介4.使用Fabric操作项目或命名空间
Aviation core technology sharing | overview of safety characteristics of acm32 MCU
SynchronousQueue 源码解析
QT draw image
BUUCTF WEB [GXYCTF2019]禁止套娃
甲辰篇 創世紀《「內元宇宙」聯載》
消息队列概述
【unity笔记】L4Unity中的基础光照
Next. JS static data generation and server-side rendering
Source code analysis of synchronousqueue
uni-app 原生APP-本地打包集成极光推送(JG-JPUSH)详细教程
How much does software testing help reduce program bugs?
风尚云网学习-input属性总结