please do the erd in the ASTAH style. do it in astah or hand write it please for credit.

sepearte SQL code please.

Objective: For this assignment, you will demonstrate that you can properly manipulate MS Visio to create an ERD. You will also demonstrate your ability to convert an ERD into appropriate SQL DDL commands. Lastly, you will create appropriate SQL DML commands to load your tables with some demonstration data. This assignment includes following proper naming conventions, specifying proper attribute constraints and data types and using sequence(s) to generate identity values. Description: New customer contact information will be recorded into the master customer table. The contact information must contain the following: Company Name, Company Address Contact Name, Contact Phone Number and Date of First Contact. The contact information may contain the following additional information: Contact Email Address, Contact Fax Number. Each customer is assigned a single sales representative during the initial entry to the master customer table. The sales representatives are defined in a table with the following fields: EmployeelID FirstName, LastName. Assignment: Create an ERD in Visio based upon the above description o This ERD should be normalized to 3.5NF/BCNF Helpful Hint: A correct answer will have 3 entities at a minimum Recognize the need to split many of the described data attributes into atomic attributes (e.g. split Contact Name into FirstName and LastName) Recognize the needs for any lookup tables to remove multi-value attributes Use pseudo-keys to assist meeting the normal forms Make sure to account for all attributes specified in the above description * " * * Don't forget to indicate the attribute constraints where appropriate - Don't forget to indicate appropriate data tynes o Properly depict the relationship(s) between the various entities Make sure to indicate identifyingon-identifying as well as cardinality