## Mth 113 Prefinal Exam

For Test I, the following symbols are used for the various connectives:

1. • (AND)
2. v (OR)
3. (Negation or NOT)
4. ⊃ (Implication or IF-THEN)
5. ≡ (IF AND ONLY IF)

Test I. Write T (for tautology), CN (for contradiction), or  CY (contingency):

1. G G
2. D (B B)
3. K (M K)
4. (S H) (H S)
5. (R E) H
6. (N (D E)) D

Test II. Write P (for permutation) or C (for combination) then solve for its value [For example  your answer could be –>  P (285)   or C (392)]

1. If 110 people will exchange hugs with everyone else, how many hugs will take place?
2. Using 7 letters only (A,B,C,D,E,F,G), how many 2-letter passkeys can we make if we are to use each letter only once?
3. If we have a total of 12 ice cream flavors to choose from,  how many possible selections can we make if we are only allowed 3 flavors on an ice cream cone?
4. There are nine Asian participants out of the 15 contestants in an international competition.  How many possible ways can we form a group composed of 10 contestants with 6 Asians?

## Networking Midterm Exam

1. You just bought the public IP:  110.0.0.0 from IANA.  If you plan to have at least 20,000 subnetworks, compute for the following:
• ( 2 pts.) What is the class of this IP.
• ( 2 pts.) How many bits should we borrow from the host octets of this IP to accomodate at least 20,000 subnets (The number of bits should just be enough: not too little, not too much).
• ( 2 pts.) If your answer above results in more than 20,000 subnets and you plan to use all of the 20,000 subnets to your various company branches worldwide, how many unused subnet addresses do you still have for future use. (Hint:  Do not include the broadcast address of your company as a single entity.)
• (3 pts.) What is the broadcast address of your company as a single entity on the Internet?
• (3 pts.) What is the last possible host IP address that can be given to any client PC on our 5th subnet?
• (3 pts.) What is the broadcast address of our 5th subnet? (Hint: It is not the same as the broadcast address mentioned in the second question.)
• (3 pts.) What is the first possible host IP address that can be given to any client PC on our 9th subnet?
• (15 pts.) What are the last 5 possible host IP addresses that can be given to any client PC on our 9th subnet?
• ( 3 pts.) What is the maximum number of possible host IP addresses can each subnet have? (Hint: It should not include subnet address itself and its subnet mask)
• (15 pts.) What are the last 5 possible host IP addresses that can be given to any client PC on our 4th subnet?
• (15 pts.) What are the first 5 possible host IP addresses that can be given to any client PC on our 11th subnet?

## Database 1 Pre-final Exam

The management of Philippine Air Lines has decided to use a Database Management System for their operations. To construct the DBMS, we are given with the following pertinent items:

• Each PAL plane model is given a a registration number.
• Each PAL plane model is also given a specific number (e.g., PA-22)
• Each PAL plane model is also given its own weight and capacity.
• All PAL technicians’ information(i.e. name, SSS, address, telephone number, and salary) should be stored in the DBMS.
• PAL technicians are experts on one or more plane model(s).  His expertise may overlap with that of other technicians. This should also be recorded.
• All PAL traffic controllers must have a yearly physical examination and you should store the date of the most recent exam.
• Each PAL worker (including technicians) is a member of their respective labor unions. The union membership number of each employee must be part of the DBMS as well.
• Each PAL employee is assigned with a unique social security number.
• NAIA has several tests regularly to make sure that their vehicles are still airworthy. Each test has a Civil Aviation Authority (CAA) test number, a name, and a maximum possible score.
• The CAA requires NAIA to keep track of these tests and store the following: the date, the number of hours the technician spent doing the test, and the score that the airplane received on the test.
1. Draw an ER diagram using ERD Plus for the airport database.

## ERD Exercise

Prepare an Entity Relationship Diagram for Patty’s Daycare Centre. For each entity indicate the primary key by underlining attribute(s) making up primary key and also specify 1 additional significant attribute. Identify and label significant relationships between pairs of entities (either 1:1, 1 : M or M:N).

Patty’s Playschool is a child daycare centre. A parent registers their child or children at the school using a registration form. A parent can submit more than one registration form. Each room in the daycare is assigned an age group. For example an infant is under 1 yearof age and toddlers are from 1 to 3 years of age. A child is assigned to a room based on their age and availability of space. A room may be assigned one or more employees. An employee can only be assigned to one room. The minimum number of employees required for a room is determined by the number of children assigned to the room and the child:staff ratio identified by the government. For example one employee can care for 5 infants or 8 toddlers.

## 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