Project $1$: Daily Invoice

Design the following four tables using personal DBMS package $($preferably Microsoft Access$).$ The primary keys are shown in bold in these design view tables.

$($Marks: $10)$

Invoices

Invoice number Customer ID

Dute

Total

Transactions

Transaction Number Invoice number

Quantity Item Number Cost

Items Item Number

Customers

Customer ID

Customer name Customer address

Customer state

Description

Price

Customer postcode

Customer phone

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$)$