information systems design question

You have recently been hired by an appliance repair company. First, normalize the following relation.

Client No.

Last Name

Street Address

City

State

Technician No.

Technician  Last Name

Service Date

Type of Service

After normalization, identify at least four relations. You may include additional fields.

"Get 15% discount on your first 3 orders with us"
Use the following coupon
FIRST15

Order Now