Question

Create an E-R diagram for the tables below:

a. Note: It may be necessary to change the data composition due to normalization issues.Either add additional tables or fields.

Business.Table

BusinessNmber

BusinessName

BusinessPhone

Street

City

State

Zipcode

OwnerFirstname

OwnerLastname

OwnerPhone

Order.Table

OrderNumber

BusinessName

Paid(Yes/No)

Invoice

BillingDate

Salesman.Table

SalesNumber

SalesManFirstName

SalesManLastName

Rate

SalesRegion

State

Answer 1

Friend, That was a nice question to answer
If you have any doubts in understanding do let me know in the comment section. I will be happy to help you further.
Please like it if you think effort deserves like.
Thanks