Q$1$ Create New Table and Fields $(2$ pts$)$

$1.$ Open previous MedicalRentals.db file from the last unit $($DB IP $2-1).$

$2.$ Create a new Invoices table and Add the eight corresponding fields to contain your data.

$$ InvoiceID as an Integer $($and primary key$)$

$$ Month as Text

$$ InvoiceDate as Text

$$ BillDueDate as Text

$$ RentalRate as Numeric

$$ RentPaid as Numeric

$$ PaymentDate as Text

$$ FKRentalID as Integer $($Note: you don$$t necessarily have to include the foreign key constraint$).$

$$ Q$1$ Document your work by including a screenshot of the final product. Include the table name, the eight fields, and the respective properties as instructed

Q$2$ Populate Your Records $(2$ pts$)$

$3.$ Click on Execute SQL

$4.$ Enter the records as an INSERT INTO query

$$ Tip: If you need a reminder on how to do this step, review our guided project for this unit and tweak the parameters for the different data types.

InvoiceID Month InvoiceDate BillDueDate RentalRate RentPaid PaymentDate FKRentalID

$12023-$Sept $2023-09-012023-09-15200020002023-09-031$

$22023-$Sept $2023-09-012023-09-15500050002023-09-062$

$32023-$Sept $2023-09-012023-09-15600060002023-09-153$

$42023-$Sept $2023-09-012023-09-15300030002023-09-104$

$52023-$Sept $2023-09-012023-09-15400040002023-09-125$

$62023-$Sept $2023-09-012023-09-15500050002023-09-166$

$72023-$Sept $2023-09-012023-09-15400040002023-09-137$

$82023-$Sept $2023-09-012023-09-15300030002023-09-018$

$92023-$Sept $2023-09-012023-09-15350035002023-09-019$

$102023-$Sept $2023-09-012023-09-15600060002023-09-0410$

$112023-$Oct $2023-10-012023-10-15200020002023-10-041$

$122023-$Oct $2023-10-012023-10-15500050002023-10-022$

$132023-$Oct $2023-10-012023-10-15600060002023-10-153$

$142023-$Oct $2023-10-012023-10-15300030002023-10-034$

$152023-$Oct $2023-10-012023-10-15400040002023-10-125$

$162023-$Oct $2023-10-012023-10-15500050002023-10-156$

$172023-$Oct $2023-10-012023-10-15400040002023-10-137$

$182023-$Oct $2023-10-012023-10-15300030002023-10-018$

$192023-$Oct $2023-10-012023-10-15350035002023-10-019$

$202023-$Oct $2023-10-012023-10-15600060002023-10-0410$

$5.$ Click Write Changes to commit your changes to your database.

$6.$ View your results under Browse Data

$$ Q$2$ Capture your version of the screenshot above. Include at least ten of your rows and ensure that your syntax is correct for the type of data added $($numeric versus text$).$ Include the log text that says that Execution finished without errors.

Q$3$ JOIN Tables to Add Rental and Invoice Information $(2$ pts$)$

In this step, we want to add the tenant$$s information to the invoice information by joining the two tables together.

Make sure the following columns are visible:

$$ Invoices.InvoiceID

$$ Invoices.Month

$$ Invoices.RentPaid

$$ OfficeRentals.FirstName

$$ OfficeRentals.LastName

$$ Q$3$ Capture a screenshot that shows the SQL commands you used, at least five of your results rows and include the log text that says that Execution finished without errors.