ull 3:42 Safari Practice Question Typically, you will be given a use case. This use is generally written as business rules. If you remember the business rules, we have the following information: 1. Entities Name 2. Relationship/Association/Cardinality Another important information: 3. Attributes/Columns names 4. Keys (i.e., primary and foreign) Example of use case (business rules) A sales representative is assigned to more than one customer in a given period. A Customer belongs to a classification (For example: basic, silver, gold, platinum). A customer can only belong to one classification, but a classification can have more than one customer. Information of assignment includes the assignment cost and duration Customer ID must be exactly 5 digits Assignment Instructions: For the above case, please answer the following questions: 1. Draw an Entity Relationship Diagram (ERD) for the above problem. You may propose suitable attributes. Make sure you identify correct relationships, attributes, and identifiers (keys). 3:42 Safari ... 2. Implement the database design into tables using an industrial-strength database management system (e.g. Oracle SQL+). CREATE TABLE Sales Representative SalesRepID NUMBER(6) PRIMARY KEY, Firstname VARCHAR2(20). Lastname VARCHAR2(20), Email VARCHAR2(20). phone NUMBER(6) CREATE TABLE Customer CustomerID CHAR(5) PRIMARY KEY, ); Example of decimal point NUMBER(6,2) -> 1234.56 NUMBER(5,2) -> 123.45 *7 Customer Sales Representative PK SalesRepID Firstname Lastname Email phone PK Customer FK ClassificationID belongs Assign Classification PK ClassificationID Type PK AssignID FK SalesRepID FK Customer AssignCost AssignDuration