当前位置:网站首页>[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
边栏推荐
- Debug Jest test cases in VSCode, debug Jest test cases in VSCode, middle note basedir=$(dirname "$" (echo "$0" sed -e -e, s, \ \, / "-e").
- Bert base Chinese Download (SMART)
- SynchronousQueue 源码解析
- BUUCTF WEB [BJDCTF2020]The mystery of ip
- Aviation core technology sharing | overview of safety characteristics of acm32 MCU
- MySQL函数-递归函数
- How to solve the computer system card?
- Markdown grammar learning
- Stm32cubeprogrammer basic instructions
- Metalama简介4.使用Fabric操作项目或命名空间
猜你喜欢
Dialogue with Bruce, author of PostgreSQL: "changing careers" is to better move forward
Everything can be expected in the future | one 2022 campus recruitment officially opened
基于卷积神经网络的遥感影像分类识别系统
解决disagrees about version of symbol device_create
网站首页文件被攻击篡改的形式有哪些
【每日一题】棋盘问题
万事有你 未来可期 | ONES 2022校园招聘正式开启
Kubernetes 入門教程
【unity笔记】L4Unity中的基础光照
QT draw text
随机推荐
Web17 -- use of El and JSTL
洛谷P3236 [HNOI2014]画框 题解
QT redraw events and cuts
What are the forms of attack and tampering on the home page of the website
AI 视频云 VS 窄带高清,谁是视频时代的宠儿
Outsourcing for five years, abandoned
How to prevent the website from being hacked and tampered with
worder字体网页字体对照表
大家帮我看一下这是啥情况,MySQL5.5的。谢了
为什么hash%length==hash&(length-1)的前提是 length 是 2 的 n 次方
I changed to a programmer at the age of 31. Now I'm 34. Let me talk about my experience and some feelings
Qt绘制文字
Symmetric encryption, certificate encryption
Solution of asynchronous clock metastability -- multi bit signal
Zigbee之CC2530最小系统及寄存器配置(1)
Flash project cross domain interception and DBM database learning [Baotou cultural and creative website development]
基于卷积神经网络的遥感影像分类识别系统
AI video cloud vs narrowband HD, who is the darling of the video era
网络信息安全之零信任
php生成json处理中文