Answer Happy

CIS 2165 - Database ManagementQuestion 1Design a database for a customer-tracking service called CustomerResource ApplicationProcessing that tracks Customers, SalesReps, and Orders. A SalesRep can have multiple customers. For the SalesRep, trackthe first name, lastname, street, city, ZIP, base pay, commission rate, and hiredate. For the Customer, first name, last name, street, city, ZIP,customer type, balance, andamount paid. For the Orders, track the order amount, customer, and order date.There can bemultiple Orders for a Customer.Create a set of tables for the for this system in third normalform. Represent your answer inDBDL format. Give table names and fields. Use good namingconventions. Underline theprimary keys. Draw an entity-relationship diagram with crows' feetnotation showingcardinality