Ask a question from expert

Ask now

Normalization & Customer Service Professional

3 Pages690 Words381 Views
   

Added on  2019-09-30

Normalization & Customer Service Professional

   Added on 2019-09-30

BookmarkShareRelated Documents
NormalizationCustomer service professionalLogin_idPasswordPK ↑In Customer service professional table there is not any repeating group within the table with multiple values and there is not partial dependency due to not having two primary keys in table. The normalization of 2nf relations to 3nf involves the removal of transitive dependencies. If a transitive dependency exists but in this table transitive dependency is not exists.CustomerCust_idCust_namee-mailAddressMobilenolidPK ↑FK↑In Customer table there is not any repeating group within the table with multiple values and there is no partial dependency due to not having two primary keys in the table. The normalization of 2nf relations to 3nf involves the removal of transitive dependencies. If a transitive dependency exists but in this table transitive dependency is not exists.PackageTracking_idWeightDeliveryoptionSource addressDestinationaddressDate of pickupTime of pickupLocationof pickuplidPK ↑ FK↑In Package table there is not any repeating group within the table with multiple values and there is no partial dependency due to not having two primary keys in the table. The normalization of 2nf relations to 3nf involves the removal of transitive dependencies. If a transitive dependency exists but in this table transitive dependency is not exists.ShipmentShipment_idCurrent locationSource addressDestinationaddressStatusConditionCust_idlidPK ↑FK↑ FK↑In Shipment table there is not any repeating group within the table with multiple values and there is no partial dependency due to not having two primary keys in the table. The normalization of 2nf relations to 3nf involves the removal of transitive dependencies. If a transitive dependency exists but in this table transitive dependency is not exists.ReportReport_idReport listingReport durationlidPK ↑FK↑In Report table there is not any repeating group within the table with multiple values and there is no partial dependency due to not having two primary keys in the table. The normalization of 2nf relations to 3nf involves the removal of transitive dependencies. If a transitive dependency exists but in this table transitive dependency is not exists.
Normalization & Customer Service Professional_1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Assignment On Customer Service Professional | Normalization Assignment
|3
|690
|400

Normalization of Bank, Manager, Branch, Customer, Employees, Deliveries and Products
|3
|574
|54

Introduction to the ERD diagram
|6
|1099
|602

Design, Normalization and Data Dictionary for Festival Database
|14
|2021
|90

Database implementation Assignment
|6
|1153
|103

Entity Relationship Diagram : PDF
|10
|1685
|236