Blog

5.11 Future Value

Suppose you have a certain amount of money in a savings account that earns compound yearly interest (in decimal), and you want to calculate the amount that you will have after a specific number of months. The formula is as follows:

F = P × (1 + i)^t

The terms in the formula are:

• F is the future value of the account after the specified time period.
• P is the present value of the account.
• i is the yearly interest rate (in decimal).
• t is the number of months.

Write a program that prompts the user to enter the account’s present value, monthly interest rate, and the number of months that the money will be left in the account. The program should pass these values to a function that returns the future value of the account, after the specified number of months. The program should display the account’s future value.

Output each floating-point value with two digits after the decimal point, which can be achieved as follows:

print(f'{your_value:.2f}')

Special Note:

• Solutions that do not include a function will receive no credit.
• Solutions that use Python features that are not discussed in class will receive no credit.

# put your future value function here
def main():
    # put your solution here
main()

For this project, you will design and create a budget for a secure, internet connected Ethernet network in a multi-story building. You will use a school as your building for this project.

Scale used:

• School = 91.44 meters (m) = 300 feet wide (ft) = 6.45 inches (in)
• 1 in = 14.18 m
• Ceiling height = 3 m = 9.84 ft

There is one equipment room and three telecommunications closets used throughout the school with the equipment room on the first floor and one telecommunications closet on the basement level, second, and third floors respectively. All four rooms are located in the same location on all four floors so cable distances will be the same on every floor.

Distances:

• Furthest connection from the equipment room and telecommunications closets = 6.50 in = 92.17 m + 6 m ceiling run (up to the ceiling and down through the ceiling) = 98.17 m
• Closest connection to equipment room and telecommunications closets = 0.375 in = 5.32 m + 6 m ceiling run = 11.32 m
• Average cable length = 54.75 m

One equipment room and three telecommunications closets service 74 rooms (17 rooms on the basement level, 21 rooms on the first floor, 19 rooms on the second floor, and 17 rooms on the third floor) x 2 cables per room. Be sure to include all materials needed.

Successful projects are defined as:

1. The equipment is sufficient to build a working network
2. The equipment is appropriate for the needs: professional-grade (not consumer grade) and not unreasonably high-performance

Sub-measures include:

1. Appropriate cabling
2. Appropriate network technology
3. Appropriate infrastructure
4. Appropriate security technology

Hint: You should focus on the physical topology, cabling, and other materials needed, not hosts. You do not have to use the scale included to draw each room and the cable runs; the scale is for reference purposes.

Create the ERD using UML notation to show the relationships between DENTIST, PATIENT and SURGERY. Also show the multiplicity in the relationships and attributes. The patient must be examined by more than one dentist and a dentist can examine at least one patient; Dentist number, dentist name, office number, cellphone number and email address must be captured on the system; A dentist can examine more than the minimum of three patients per day; The following patient details need to be captured on the system: patient number, patient name, street address, email address; Each surgery is assigned an examination at the time as instructed by dental clinic policy.

Question 3 Complete the statements below by filling in the missing words. The words are provided in the table. Write down the question number and next to it the correct answer. For example, 3.1 Entity.

A table is perceived as a (Q.3.1) structure composed of tables, rows, and relationships (1). Each table column represents an (Q.3.2), and each column has a distinct name (1). Each cell or column/row intersection in a relation should contain (Q.3.3) atomic value (1). Each column has a specific range of values known as the (Q.3.4) (1). Each (Q.3.5) does not need to have an attribute or a combination of attributes that uniquely identifies each row (1). A foreign is an attribute in one table whose values must either match the primary key in another table or be (Q.3.6) (1). A candidate key is a minimal (Q.3.7) that does not contain a subset of attributes that is itself a superkey (1). A (Q.3.8) is a candidate key selected to uniquely identify all other attribute values in any given row and cannot contain null entries (1). A secondary key is an attribute used strictly for (Q.3.9) purposes (1). A (Q.3.10) is an attribute that uniquely identifies each row in a table (1).

The Monsters in The Odyssey – Modern Connections Project

Objective: Choose one monster from The Odyssey and connect it to a real-world problem we face today. Explain your reasoning in a written response and create a visual or physical representation of your idea.

Monsters to Choose From:

• Scylla
• Charybdis
• Cicones
• Polyphemus (the Cyclops)
• Sirens
• Circe
• Laestrygones

Part I: Written Response

Write at least 3 paragraphs. Do a File Upload and follow MLA format.

Paragraph 1 – Introduction

• Which monster did you choose?
• Briefly describe the monster.
• What real-world problem does the monster represent?
• Why did you choose this issue?

Paragraph 2 – Analysis

• Give background information about the problem.
• Explain 2 reasons why this monster represents the problem.
• Include at least one quote or example from The Odyssey.
• What moral, value, or life lesson is connected to this issue?

Paragraph 3 – Conclusion

• Summarize your main points.
• What can we learn from Odysseus’ experience with the monster?
• How can people today face or overcome the problem you described?

Part II: Creative Representation

Make a visual or physical representation of your idea! Choose one of the following:

• Drawing or painting
• Collage or digital poster
• Short comic strip
• 3D model (with labels)

Your visual must include:

• The name of the monster
• The modern problem it represents
• At least 2 symbols or elements that connect the monster to the issue

Problem

Write a program called Shapes that offers the user the choice of doing one of the following calculations:

• Calculate hypotenuse of a right triangle
• Calculate area of a right triangle
• Calculate perimeter of right triangle
• Calculate area of a rectangle
• Calculate perimeter of rectangle
• Calculate length of diagonal of a rectangle
• Calculate area of a square
• Calculate perimeter of square
• Calculate length of diagonal of a square

For triangle calculations the user will enter the lengths of the two shorter sides.

For rectangle calculations the user will enter the length and width.

For square calculations the user will enter the length of one side.

The program will ask for the user’s choice, get the necessary inputs, call a method and then display the answer to 3 decimal places. Each calculation must be done by calling one of the five methods below.

You must create exactly five methods as shown below and call one for each of the calculations:

Your program must validate all user choices and inputs and keep running until the user chooses to quit.

Turning in the Assignment

When you have finished, run your program once using the test data below:

The existing (Legacy) Table(s) Structure

Supplier table structure:

Location table structure:

Based on the table structures and business rules, match the following questions with the correct answers. Your answers should be in coordination with concepts discussed in Chapter-6.

1. Which attribute will serve as the FK in the newly created Location table?
2. Eliminate the Repeating Groups and create a new Location table with unique rows.
3. Jonny redesigned the Supplier table to?
4. Jonny created a 2NF-compliant database structure.
5. The existing Supplier table is in violation of?
6. If each value of A determines one and only one value of B.
7. To achieve 3NF-compliant database structure, Jonny should eliminate: Transitive Dependencies.
8. A functional dependence criterion is fulfilled: Supplier-ID.
9. Jonny removed City and State from the Location table and added a linked Zip table.
10. Jonny placed the Memo field in the redesigned Location table.
11. To avoid unnormalized data in the Supplier table, reflected by multivalued attribute: 1NF-compliant database structure.

Instruction