![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
envisat
这个作者很懒,什么都没留下…
展开
-
integrity constraint
Integrity rules candidate keys& primary key constraints unique PK - not null and unique constraint checks foreign key constraint any FK can only contain either null values or values from a parent table’s PK or a candidate key not null constraint domai原创 2020-05-11 18:12:11 · 489 阅读 · 0 评论 -
normalization
normalization Unnormalized form (UNF) - 1NF Remove repeating groups (eliminate repeating fields/eliminate non-atomic attributes/rows uniquely identified) step 1.split non-atomic attributes, remove grouping attributes possible anomaly modification anoma原创 2020-05-11 12:49:15 · 145 阅读 · 0 评论 -
SQL create database script 导出问题
SQL create database script 导出问题 file - new model add new schema add table database - forward engineer - continue - continue - continue script… save to file - continue 5. 进入connection, 若没有...原创 2020-05-06 21:32:16 · 162 阅读 · 0 评论