Question

Can you look and see where I could improve on this ERD and ensure that the ERD is correct? For this task, you are to normalize the ERD that has been developed to remove any partial dependencies or transitive dependencies that may exist. Two things about customers to consider when modifying your ERD are that customers may have more than one shipping address and multiple credit cards they can use to pay for their order. Also, there are several shipping options that can be used such as the shipping company (UPS, Fedex, USPS) and method for deliver (Standard, Ground, Next day Air, etc). Your database must take this additional information into consideration along with normalizing the ERD we have already developed. The goal of this task is to create a normalized ERD that fully captures the logical design needed for our eCommerce database. This is the final step of the design process and once approved, that ERD will be used to develop the database. You may need to add new tables and/or attributes to complete your final ERD. Customer orders orderID product PK CustID PK OID PK OID PK prodID fName FK custID FK prodID prodName email orderDt qty desc DOB shipMethod price rprice Gender shipCost sprice ccType dept ccNum category expired keywords billAddress billCity billState billZip shipAddress shipCity shipState shipZip

Answer 1

I could improve on this ERD and ensure that the ERD is correct? For this task, you are to normalize the ERD that has been developed to remove any partial dependencies or transitive dependencies that may exist. Two things about customers to consider when modifying your ERD are that customers may have more than one shipping address and multiple credit cards they can use to pay for their order. Also, there are several shipping options that can be used such as the shipping company (UPS, Fedex, USPS) and method for deliver (Standard, Ground, Next day Air, etc). Your database must take this additional information into consideration along with normalizing the ERD we have already developed. The goal of this task is to create a normalized ERD that fully captures the logical design needed for our eCommerce database. This is the final step of the design process and once approved, that ERD will be used to develop the database. You may need to add new tables and/or attributes to complete your final ERD. Customer orders orderID product PK CustID PK OID PK OID PK prodID fName FK custID FK prodID prodName email orderDt qty desc DOB shipMethod price rprice Gender s