问题描述
规范化数据库; orignally它conatin列如姓名，Phoneno，EmailAddress，地址，技能
因为每个学生可能有更多技能。
1 NF：
Studentid（PK）FirstName LastName Phoneno EmailAddress StreetName City
1 F1 L1 88889 [email protected] westend pune
2 F2 L2 8888 [email protected] Eastend Mumbai
skillid（PK）skillname studentid（FK）
1 Java 1
2 .Net 2
3 Android 1
4甲骨文1
你可以指导我应该是我的2NF和3NF正常形式：
将技能（PK）需要删除所以数据库是否在2NF？
每次我去采访时我都没能写数据库规范化到3NF
normalizing Database; orignally it conatin column like Name,Phoneno,EmailAddress,Address , skill
As each student may have more skill.
1 NF:
Studentid(PK) FirstName LastName Phoneno EmailAddress StreetName City
1 F1 L1 88889 [email protected] westend pune
2 F2 L2 8888 [email protected] Eastend Mumbai
skillid(PK) skillname studentid(FK)
1 Java 1
2 .Net 2
3 Android 1
4 Oracle 1
Can u guide me what should be my 2NF & 3NF Normal form:
will skillid(PK) need to remove so database to be in 2NF?
Each time as i go to interview & i failed to write databse normalization upto 3NF
推荐答案
这篇关于将数据库规范化为3NF的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！