- 浏览: 318039 次
- 性别:
- 来自: 广州
文章分类
- 全部博客 (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 1566想要在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. 第六章 访 ...
相关推荐
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...
Mixed Identifying and Nonidentifying Patterns The For-Use-By Pattern Recursive Patterns The Data Modeling Process The College Report The Department Report The Department/Major Report The Student ...
- **Advanced Techniques**: Advanced techniques for handling non-linear relationships and model violations are introduced. #### Chapter 3: Model Evaluation - **Evaluation Metrics**: Key metrics for ...
4. **Calculating Time Parameters**: Time parameters like early start, late start, early finish, and late finish help in identifying the critical path and determining the flexibility of non-critical ...
2. **Generalized Linear and Nonlinear Models**: Incorporate nonlinear relationships and non-normal distributions. 3. **General Regression Models**: Similar to GLMs but more flexible in terms of model ...
This makes it particularly suitable for tasks like image classification, where non-linear relationships between image features can be crucial for accurate categorization. In the image classification...
The software architecture of a system is the structures of the system, which comprise software components, the externally visible properties of those components, and the relationships among them....
Iso and iEC shall not be held responsible for identifying any or all such patent rights 0m-0sz ISO/EC 27005 was prepared by Joint Technical Committee ISO/EC JTC 1, Information technology ...