没有primary key时,combine两列内容作为PK
    Screen Shot 2020-04-21 at 7.29.10 PM.png
    凡是有duplicated 数据,说明不满足2NF;
    通过count(*)和count(distinct())对比,可以发现哪些列有重复的值;
    Screen Shot 2020-04-21 at 7.40.29 PM.png
    时间是容易忽略的duplicated value;
    把时间作为一个entity,满足提取多种时间类型;
    满足2NF(即无duplicated value),目的是用数字123代替字段的长字符,节省储存空间
    Screen Shot 2020-04-21 at 7.35.22 PM.png