You are considering the purchase of a new home offered at a price of $225,000. Create an amortization table in a new workbook that shows how much interest and principal you will pay each month for the duration of the loan. The following is a list of assumptions and requirements you need to consider for this assignment: 1. You will be making a down payment of 20% on the home (refer to Table 2.5 in the textbook for loan and lease terms). 2. The bank will offer you a loan at an annual interest rate of 5.5% for 30 years. 3. Your mortgage payments will be made at the end of each month. 4. You must construct the amortization table so that any change in the loan variables, down payment percent, length of loan, interest rate, and so on will automatically produce new outputs for each month of the amortization table. 5. The amortization table must show the interest payment, principal payment, and balance remaining to be paid on the loan for every month of the loan duration. The beginning balance for the last month of the loan should be equal to the principal payment in the last month. Refer to Figure 2.29 in the textbook for establishing the format for the table. 6. Remember to use column and/or row headings, add a title to your worksheet, and rename the worksheet tab with an appropriate label. 7. Include your name in the file name of the workbook.

110. The normal form which consider all the types of constraints and dependencies is classified as a. domain-key normal form b. foreign-key normal form c. candidate-key normal form d. primary-key normal form

Create a Crow’s Foot ERD to include the following business rules for the EaonCo company:   Each sales representative writes many invoices. Each invoice is written by one sales representative. Each sales representative is assigned to one department. Each department has many sales representatives. Each customer can generate many invoices.   Each invoice is generated by one customer.

Draw clearly from existing scenario text the Entity Relationship Diagram (ERD) “There is a group of employees who have run the website. Three admins are responsible to check registration forms filled by babysitters.  An accountant is responsible to check fees payments. All these employees are supervised by the manager.    Each babysitter can register on the website one time by filling in her data including first and last names, qualifications, fee rate per hour (25 SAR per Hour), contact information, address, photo, and years of experience.  The system will issue for her id and registration date.   Mothers can make booking as many as they need.  For each time, they must fill in their names, contact information, address, number of children, the date and time (e.g. from 2:00 PM to 4:PM) of booking.    The website will generate the booking report including mother’s data, babysitter’s contact data, number of booked hours, fee rate per hour, fees total amount, and tax (%5).  To make a…