- 浏览: 317724 次
- 性别:
- 来自: 广州
文章分类
- 全部博客 (107)
- Linux (16)
- Android (20)
- Network Pay (0)
- UI (8)
- Program Language (13)
- Java (8)
- Web Design (3)
- Database (5)
- SQLite (2)
- Vi/Vim (4)
- CSS (2)
- Network (3)
- PHP (20)
- Web Service (3)
- Troubleshooting (37)
- MySQL (3)
- System Management (3)
- Tools (27)
- Others (7)
- Eclipse (3)
- Framework (5)
- Python (1)
- JavaScript (1)
- Git (1)
- SCM (1)
- Video (0)
- Testing (0)
- Windows (1)
- http://service.oray.com/question/116.html (1)
- Python Troubleshooting (1)
最新评论
-
xwv:
能对你有启发和帮助就好
为什么Android的Adapter中,bindview被调用了多次 -
lipei.98:
哈哈 谢谢你的博客,解决了我一个头痛的问题。
为什么Android的Adapter中,bindview被调用了多次
【转】Identifying and Non-Identifying Relationships
- 博客分类:
- Troubleshooting
- Database
这是一篇关于关系数据库中 Identifying 和 Non-Identifying Relationships的解释,下面转贴以做参考.
Identifying and Non-Identifying Relationships
An identifying relationship means that the child table cannot be uniquely identified without the parent. For example, you have this situation in the intersection table used to resolve a many-to-many relationship where the intersecting table's Primary Key is a composite of the left and right (parents) table's Primary Keys.
Example...
Account (AccountID, AccountNum, AccountTypeID)
PersonAccount (AccountID, PersonID, Balance)
Person(PersonID, Name)
The Account to PersonAccount relationship and the Person to PersonAccount relationship are identifying because the child row (PersonAccount) cannot exist without having been defined in the parent (Account or Person). In other words: there is no personaccount when there is no Person or when there is no Account.
A non-identifying relationship is one where the child can be identified independently of the parent ( Account - AccountType)
Example...
Account( AccountID, AccountNum, AccountTypeID )
AccountType( AccountTypeID, Code, Name, Description )
The relationship between Account and AccountType is non-identifying because each AccountType can be identified without having to exist in the parent table.
You can define the relationship type (identifying/non identifying) in the DeZign for Databases in the relationship dialog. Double click on the relationship line in the diagram window to display the relationship dialog.
发表评论
-
Linux的文件权限和ACL的一些问题
2016-06-20 18:48 0关于Linux上的权限和ACL的一些问题: ... -
linux中find命令的mtime参数使用问题
2016-05-12 17:43 0在Linux中,使用find的参数mtime时的 ... -
关于MySQL的主机名解析问题
2016-05-12 12:03 0在实际中遇到MySQL错误日志中有类似这样的信息 ... -
PHP使用OpenSSL进行RSA签名和验证的一些资料
2015-10-16 17:57 0在PHP使用OpenSSL来进行RSA签名和验 ... -
Vim中如何转换字母大小写
2015-10-16 15:25 0如何在Vim中对字母大小写进行转换? ... -
Linux Shell如何解析JSON格式数据
2015-09-24 15:27 0今天遇到一个,如果在Linux系统下,想要使用 ... -
MySQL中进行授权和取消授权的操作
2015-08-26 18:18 0一些关于MySQL中对用户授权和取消授权操作的资 ... -
SVN的反向合并
2015-08-21 13:58 0关于SVN的反向合并,查些资料帮助熟悉: ... -
MySQL中修改数据库名的方式
2015-08-20 16:13 0MySQL中如何修改数据库名,找找资料: ... -
通过网络服务获取本地的外网IP地址
2015-08-03 14:26 1561想要在Linux环境下,通过网络服务获取本地的 ... -
PHP的内存泄漏的检测方法资料
2015-07-14 15:53 0今天遇到PHP内存泄漏的问题,如何检查,下面是些 ... -
关于Widget的资料
2015-07-03 14:48 0最近,对Widget进行一些了解: ... -
YAML资料
2015-06-04 17:32 0YAML资料: 1. XML 问题 ... -
浏览器端结合ZendStudio调试PHP
2015-04-08 17:39 0需要使用XDebug和ZendStudio调试 ... -
在PHP中获取MySQL数据库表信息,生成HTML格式数据字典
2015-03-30 14:48 0在实际中见到他人项目中生成的HTML格式数据字 ... -
关于非对称密码体系的一些资料
2015-03-27 15:46 0关于非对称密码体系的一些资料: 1 ... -
vi中的编码问题
2015-03-26 22:09 0关于在vi中设置编码问题的一些讨论资料: ... -
PHP中的HTTP_X_FORWARDED_FOR,REMOTE_ADDR,HTTP_CLIENT_IP
2015-03-23 11:06 0在PHP中尝试获取客户端IP时,查找几个资料: ... -
Ubuntu 10.10下将PHP升级到5.4过程中的资料
2015-02-07 13:09 0最近,在Ubuntu 10.10下将PHP升级到 ... -
权限系统设计的参考资料
2014-12-30 17:10 01. 访问控制 2. 第六章 访 ...
相关推荐
"Identifying Medical Diagnoses and Treatable Diseases by Image-Based Deep Learning" 本文总结了基于图像的深度学习在医疗诊断和可治疗疾病中的应用。该系统使用迁移学习技术,能够有效分类图像,诊断糖尿病...
从很多的水果中找出指定的水果,并在找到的水果上标记下来。
Yelp-Project-in-identifying-categories-and-projecting-top-5-positives-and-negatives Yelp - 识别业务类别和查找业务的主要正面/负面项目在本项目中,您将有机会练习从 Z534 课程中学到的信息检索和文本挖掘方法...
**识别加密恶意软件流量的关键知识点** 随着网络加密的普及,识别加密流量中的恶意软件成为网络安全领域的一大挑战。传统的基于深度包检测(Deep Packet Inspection, DPI)和签名匹配的方法在面对加密流量时失效,...
JAccount-identifying-code-cracker 工具:在交大JAAccount网站上说出识别码是什么
Infrared thermometers find extensive use in numerous industries due to their non-contact nature and fast response time. Some common applications include: 1. Manufacturing: In process control, ...
"Identifying code-red.rar" 提供了一个利用Python3和Tesseract OCR(Optical Character Recognition)库来识别红色字符的验证码解决方案。Tesseract是一款强大的开源OCR引擎,由Google维护,能够将图像中的文本转换...
利用Windows自带的声卡采集器,通过麦克风将声音采集。将录制的声音分为一系列频率,将基频进行比较,从而进行简单的声音识别。
识别与症状状态相关的基因
1. **Identifying the Challenge**: The paper highlights the issue of non-determinism in parallel programming and its implications for software reliability and safety. 2. **Proposing a Novel Solution**:...
### SSD7 Unit1 Skill Builder: Identifying Keys and Integrity Constraints B #### 客户表 (Customer) **主键(Primary Key, PK):** - **ID**: 每个客户都有一个唯一的标识符,用于区分不同的客户。这个字段是...
From identifying common mistakes to offering practical solutions and best practices, this book is essential for ensuring the quality and reliability of C and C++ applications. Whether you're a ...
In the Entity-Relationship model, properties that characterize entities and relationships are modeled as (a) attributes (b) participation constraints (c) entity types (d) weak entities Correct...
This book combines the advantages of high-dimensional data visualization and machine learning in the context of identifying complex n-D data patterns. It vastly expands the class of reversible ...
近战武器和枪支的武器分类专家系统。
Soft computing and nature-inspired computing both play a significant role in developing a better understanding to machine learning. When studied together, they can offer new perspectives on the ...