Project: Customer Relations

Design the following four tables using personal DBMS package $($preferably Microsoft

Access$).$ The primary keys are shown in bold in these design view tables.

You need to add hypothetical entries into these tables $($at least $3$ in each$)$ and develop the entity$-$relationship diagram.

A customer can be issued more than one invoices. $($one to many relationship$)$

An Invoice can include more than one transactions. $($one to many relationship$)$

A transaction can include more than one items. $($one to many relationship$)$

Criteria

Answer questions $(2)$: Access file with the relations