## Programming 2 Midterm

Interface Computer College
Database 1
Midterm Exams

I. Program Making. (60 pts.)

Create an application that shows how to calculate the compound interest of a saving.

Prerequisites:
• Dialog Boxes
• Group Box
• Labels
• Text Boxes
• Buttons

When you deposit money in a savings account, your money earns interest that is calculated every month or quarter, etc. Because this is not money you need right away, the amount accrued can be reinvested, thus boosting your interest so the next calculation would be based on the original amount plus the new added value. This is the basis of compound interest.

The compound interest can be calculated monthly or quarterly, etc based on the original amount you deposited, the interest rate, and the period you and the institution agreed upon.

This application uses a dialog box equipped with the necessary controls used to perform the type or related calculated. The formula we will use to perform the calculations is as follows:

Design the form as follows:

## Physics 1 Midterm Exam

Interface Computer College
Physics 1
Midterm Exams

I. Multiple Choice:

1. A car moved 80 km to the South. What is its displacement?

A: 20 km South          B: 50 km East                   C: 80 km South            D: 160 km North

2. A car moved 60 km East and 90 km West. What is the distance?

A: 30 km             B: 60 km                 C: 90 km                D: 150 km

3. A car moved 60 km East and 90 km West. What is the displacement?

A: 30 km West                B: 60 km West               C: 30 km East               D: 150 km

4. Average velocity can be calculated by dividing displacement over what?

A: time                B: distance                C: mass                    D: density

5. What is the average velocity of a car that moved 60km in 3 hours?

A: 10 km/h              B: 20 km/h             C: 30 km/h                D: 60 km/h

6. What is the average velocity of a car that moved 40 km East and 80 km West in 2 hours?

A: 5 km/h               B: 10 km/h               C: 15 km/h                  D: 20 km/h

7. How far will a car travel in 25 min at 12 m/s?

A: 10 km                B: 14 km                    C: 18 km                    D: 24 km

8. How far will a car travel in 2 hours at 20 m/s?

A: 144 km               B: 158 km                C: 168 km                D: 234 km

II. Problem Solving: (Show your solutions)

1. A truck starts from rest and gains a velocity of 20 km/hr in 8 seconds while moving on a straight road. What is the magnitude of acceleration of the truck?
2. A mountain climbing expedition establishes a base camp and two intermediate camps, A and B. Camp A is 11,200 m east of and 3,200 m above base camp. Camp B is 8,400 m east of and 1,700 m higher than Camp A. Determine the displacement between base camp and Camp B.
3. An ambitious hiker walks 25 km west and then 35 km south in a day. Find the magnitude and direction of the hiker’s resultant displacement (relative to due west).
4. I went for a walk the other day. I went four avenues east (0.80 miles), then twenty-four streets south (1.20 miles), then one avenue west (0.20 miles), and finally eight streets north (0.40 miles).
a. What distance did I travel?
b. What’s my resultant displacement (magnitude and direction relative to due east)?
5. While Dexter is on a camping trip with his boy scout troop, the scout leader gives each boy a compass and a map. Dexter’s map contains several sets of directions. For the two sets below, draw and label the resultant (R). Then use the Pythagorean theorem to determine the magnitude of the resultant displacement for each set of two directions.
a. Dexter walked 50 meters at a direction of 225° and then walked 20 meters at a direction of 315°.

b. Dexter walked 60 meters at a direction of 135° and then walked 20 meters at a
direction of 45°.

## Database 1 Prefinal Exam

Normalization. using MS-Access (50 pts.)

A engineering consultancy firm supplies temporary specialized staff to bigger companies in the country to work on their project for certain amount of time. The table below lists the time spent by each of the company’s employees at other companies to carry out projects. The National Insurance Number (NIN) is unique for every member of staff.

 NIN Contract No Hours Employee Name Company ID Company Location 616681B SC1025 72 P. White SC115 Belfast 674315A SC1025 48 R. Press SC115 Belfast 323113B SC1026 24 P. Smith SC23 Bangor 616681B SC1026 24 P. White SC23 Bangor

Normalize the above using MS-Access.  Submit your .accdb file to beduya22@gmail.com