亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

? 歡迎來到蟲蟲下載站! | ?? 資源下載 ?? 資源專輯 ?? 關于我們
? 蟲蟲下載站

?? normalization.txt

?? ssd7 exe6 my answer of this exercise
?? TXT
字號:
answer:
1.the primary key TrackingNum.

2.the FDs:
	EmpID --> EmpName  
	OrderNo --> ShipToAddr
  	TrackingNum --> EmpID  EmpName 
	TrackingNum--> OrderNo  ShipToAddr  ShippedDate

3.the update anomalies:

the Insertion anomalies:

	when you insert a new SHIPMENT you must insert the information of the employee and the order. for example when you insert a TrackingNum is 123456987, you should insert all the correct information of the employee and order, include the EmpID, OrderNo,EmpName, ShioToAddr and ShippedDate

	when you insert a new information for a employee, this employee may have not handles a shipment, the TrackingNum is null. for example when you insert a employee EmpID is 1455, because he is a new employee, he handles no shipment, but the TrackingNum is primary key so it could not be null, so there is a insertion anomaly.

the Deletion anomalies:

	when you delete a shipment, you also delete the information of the employee handles it. if the employee now handles the only one shipment, after you delete the shipment information, the imformation of this employee is miss. it is same to the order.

Modification anomalies:

	when you rework the information of order you must rework the information in all shipment belongs to this order. if you do not change all there may cause the shipment in same order have different address and date. it is same to the employee.

4.it is in 2NF.
  it is in 1NF because the domain of every attribute allows a single atomic value, every cell in the table contains one and only one value. the primary key is TrackingNum. the attributes in this table there is not composite or multi-value attributes.
  and it is defined in terms of partial and full dependencies and is associated with modification anomalies. the relation contains non-primary-key attribute that is transitively dependent on the primary key. so it is in 2NF.
  but there still have non-primary-key attribute that is transitively dependent on the primary key so it is not in 3NF.

5.for it is in 2NF, we just need to bring the relation to 3NF.
  because {EmpID --> EmpName} and {TrackingNum --> EmpID  EmpName} so the attribute EmpName transitively dependent on TrackingNum so split the original relations into two new relations Employee and Shipment.
  because {OrderNo --> ShipToAddr} and {TrackingNum--> OrderNo  ShipToAddr  ShippedDate} so the attribute ShipToAddr transitively dependent on TrackingNum so split the Shipment relations into two new relations Order and Shipment.

  so at the end split original relations into three new relations:
	SHIPMENT(TrackingNum(PK), EmpID, OrderNo, ShippedDate)
	Employee(EmpID(PK), EmpName)
	Order(OrderNo(PK), ShipToAddr)
  Employee
   	EmpID→EmpName

  Order
 	OrderNo→ShipToAddr
 
  Shipment 
 	TrackingNum→EmpID
 	TrackingNum→OrderNo
 	TrackingNum→ShippedDate
 
because it is in 2NF and does not contain a non-primary-key attribute that is transitively dependent on the primary key so it is 3NF. 


        

?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频
国产综合成人久久大片91| 久久精品视频一区二区三区| 成人精品视频网站| 国产一区二区三区免费看| 蜜臀精品久久久久久蜜臀| 日本强好片久久久久久aaa| 日韩和欧美的一区| 亚洲福利视频一区二区| 日本亚洲电影天堂| 久久aⅴ国产欧美74aaa| 国产精品77777竹菊影视小说| 国产精品1024| 91丨porny丨中文| 欧美三级在线播放| 日韩视频中午一区| 国产亚洲欧美中文| 亚洲人成网站在线| 日韩av电影一区| 国产乱一区二区| 色综合久久综合网欧美综合网| 色综合中文综合网| 中文字幕日韩一区二区| 亚洲精品一二三区| 日韩在线一区二区三区| 国内精品久久久久影院薰衣草| 国产aⅴ综合色| 91国偷自产一区二区开放时间| 88在线观看91蜜桃国自产| 26uuu欧美| 亚洲激情综合网| 激情小说欧美图片| 97超碰欧美中文字幕| 欧美一级欧美三级| 国产精品色婷婷| 手机精品视频在线观看| 国产乱码精品一区二区三区av| 91蜜桃网址入口| 久久亚洲一级片| 五月综合激情婷婷六月色窝| 国产盗摄视频一区二区三区| 欧美在线观看一二区| 亚洲精品在线一区二区| 亚洲综合自拍偷拍| 国产精品综合一区二区三区| 欧日韩精品视频| 国产欧美日韩三区| 免费人成在线不卡| 在线视频国产一区| 久久精品亚洲精品国产欧美kt∨ | 欧美三级一区二区| 国产精品久久久久桃色tv| 免费成人av资源网| 欧美视频一区二区三区| 亚洲日本在线天堂| 国产精品一二三四五| 日韩亚洲欧美一区| 午夜久久久久久| 色播五月激情综合网| 中文字幕日韩一区| 福利一区二区在线| 国产欧美一区二区精品婷婷| 免费观看91视频大全| 欧美日韩久久一区| 一二三四社区欧美黄| 99久久免费国产| 国产精品久久久久婷婷| 成人综合婷婷国产精品久久蜜臀 | 国产在线一区观看| 精品欧美乱码久久久久久| 性做久久久久久免费观看| 在线影视一区二区三区| 亚洲蜜臀av乱码久久精品| 91日韩在线专区| 国产精品国产三级国产普通话99 | 激情文学综合插| 精品国产欧美一区二区| 精品一区二区三区久久| 欧美sm美女调教| 国产一区二区三区免费观看| 久久日韩粉嫩一区二区三区| 国产一区二区在线观看视频| 久久免费的精品国产v∧| 国产成人av一区| 国产精品另类一区| 91免费观看视频| 亚洲午夜羞羞片| 91精品国产aⅴ一区二区| 免费精品视频最新在线| 精品剧情v国产在线观看在线| 激情久久久久久久久久久久久久久久| 日韩精品一区国产麻豆| 国产精品白丝jk白祙喷水网站| 亚洲国产精品t66y| 91麻豆123| 午夜伊人狠狠久久| 精品国精品自拍自在线| 国产v综合v亚洲欧| 有码一区二区三区| 日韩欧美国产午夜精品| 国产福利91精品一区| 亚洲美女偷拍久久| 91精品国产一区二区三区蜜臀| 九九精品视频在线看| 综合婷婷亚洲小说| 日韩一区二区三区精品视频| 国产成人av一区二区三区在线 | 亚洲色图一区二区三区| 在线成人av网站| 国产91综合一区在线观看| 亚洲色图欧美激情| 欧美电影免费观看高清完整版在线观看| 韩国三级中文字幕hd久久精品| 亚洲日本在线观看| 欧美大片一区二区| 色中色一区二区| 国产麻豆精品一区二区| 亚洲成人精品影院| 国产日韩亚洲欧美综合| 在线不卡中文字幕| 96av麻豆蜜桃一区二区| 蜜桃av一区二区三区| 一区二区欧美国产| 国产日韩精品一区二区浪潮av | 色婷婷av一区| 国产一区二区三区久久久| 午夜不卡av免费| 最新国产成人在线观看| 精品毛片乱码1区2区3区| 欧美日韩在线综合| 99热精品一区二区| 国产不卡视频在线播放| 精品一区二区三区不卡 | 不卡电影一区二区三区| 久久精品国产99国产精品| 亚洲成人av一区二区三区| 最新热久久免费视频| 国产女同互慰高潮91漫画| 欧美一区午夜视频在线观看| 91国偷自产一区二区使用方法| 成人午夜精品一区二区三区| 国内精品久久久久影院薰衣草| 爽爽淫人综合网网站| 亚洲国产欧美在线人成| 一区二区三区国产| 亚洲免费三区一区二区| 国产精品久久久久aaaa| 国产欧美日韩三级| 中文字幕va一区二区三区| 久久午夜国产精品| 久久精品欧美日韩| 国产丝袜美腿一区二区三区| 久久婷婷国产综合精品青草| 精品久久久久久久久久久久久久久久久| 欧美日韩一级黄| 欧美色欧美亚洲另类二区| 在线观看日韩精品| 欧美日韩一区不卡| 日韩一区二区在线看| 日韩免费观看高清完整版| 日韩精品一区二区三区老鸭窝| 日韩欧美在线网站| 国产午夜久久久久| 国产精品久久久久久久裸模| 亚洲欧洲日韩一区二区三区| 自拍视频在线观看一区二区| 亚洲激情校园春色| 亚洲国产婷婷综合在线精品| 日韩av电影免费观看高清完整版在线观看| 亚洲欧洲三级电影| 亚洲国产综合91精品麻豆| 免费在线观看视频一区| 美国十次了思思久久精品导航| 精品无码三级在线观看视频 | 亚洲主播在线观看| 亚洲电影欧美电影有声小说| 久久成人18免费观看| 成人免费高清在线观看| 色综合久久九月婷婷色综合| 日韩视频免费观看高清完整版 | 一区二区三区.www| 理论电影国产精品| 成人黄色av电影| 欧美日韩激情一区二区| 精品国产一区二区三区不卡 | 久久精品国产99久久6| 成人午夜免费电影| 欧美人妇做爰xxxⅹ性高电影| 欧美一区二区视频在线观看2020| 国产性做久久久久久| 亚洲福利国产精品| 国产福利电影一区二区三区| 欧美特级限制片免费在线观看| 精品国产乱码久久久久久浪潮 | 久久99精品国产麻豆婷婷| 国产精品小仙女| 337p亚洲精品色噜噜| 日韩理论片在线| 国产精品亚洲一区二区三区在线| 99久久免费视频.com| 日韩女优制服丝袜电影|