Start with the Excel workbook $($finalex$2021.$xls$)$ as found in Blackboard

There are three separate sheets in the workbook

$($Business$\_$Info, Order$\_$Info, Salesmen$)$

$$

Create your own table design based on the Excel data, and include any and all relationships $($joins$).$ Apply referential integrity rules wherever appropriate

$$

Import the data from Excel to your database $($you must use Access$)$ to populate tables

$$

$$

Use the Chen technique and illustrate the E$-$R diagram for the tables you created.$$ You can use Visio, Word, etc but this document must also be submitted in Blackboard for grading.

Note:$$ It may be necessary to change the data composition due to normalization issues, if you change the composition detail how and why;$($you may find it necessary to create additional tables or fields$)$

$$

$$

In Access, create the appropriate SQL or use Access Queries to complete the following:

$$

Find businesses and their orders sorted by Salesman Last Name.$$ Include the following attributes: Business Number, Business Name, Order Number, Billing Date, Salesman Last Name, and Commission Amount $($derived attribute based upon Invoice Amount and Commission Rate$).$

$$

For all salesmen with current customers, create a list of each business $($one record per business$)$ with unpaid orders.$$ Include the following attributes: Salesman Number, Salesman Full Name $($derived from Salesman Last Name and Salesman First Name$),$ Business Number, Business Name, and Owner Name.