- 博客(3)
- 收藏
- 关注
原创 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
原创 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
原创 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
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人