(Solved) : 1 Generate Logical Model Following Problems Sure Appropriate Pks Fks Resolve Many Many Rel Q34834959 . . . .

1. Generate a logical model for each of thefollowing problems. Be sure to have appropriate PKs and FKs,resolve any many to many relationships, convert compositeattributes to their component attributes, resolve multivaluedattributes with a one to many relationship with a new table, andremove any derived attributes.

Problem A – Sales Sales rep data include a sales repnumber (unique identifier), name, and phone number. A sales repservices 0 or more customers. Customer data includes a customernumber (unique identifier), name, address, and phone. Each customerplaces 1 or more orders. Order data include an order number (uniqueidentifier) and order date. Each order contains 1 or