With your knowledge in database design and normalization, design the database above with $4$

tables as follows.

$-$ Income

$-$ IncomeCategory

$-$ Expense

$-$ ExpenseCategory

Include all the columns, constraints relationships necessary on the respective tables. The income

categories are Salary and Tips while the expense categories are rents, airtime, socials,

loanpayment. Every income and expenses should have the date associated to it

$-$ Create files groups of each income and expense category.

$-$ Insert the expense and income categories record in the tables.

$-$ Record $2$ incomes and $2$ expenses for reach categories with any amount of your choice on

the tables

$-$ Create a database diagram showing all the tables and the relationships.