Exam Midterm

Exam:

1. Create a simple library system that will cater adding record, deleting record transaction
2. Database name: Library
3. Table: Student, Faculty, Book
   

Students Table:

Stud_ID

Stud_Fname

Stud_Lname

Stud_Course

Stud_Year

Date_Borrowed

Date_Returned

Book_Description

Book_Author

Faculty Table

Fuc_ID

Fuc_Fname

Fuc_Lname

Fuc_Subject

Fuc_status

Date_Borrowed

Date_Returned

Book_Description

Book_Author

Book Table

ISBN_no

Book_title

Book_Des

Book_Author

Your system is compose of a Main Menu that contains 3 buttons the students and Faculty and book. Design a Form for students, faculty and books with add,delete,clear and exit buttons. and display the current date and current time

Research No. 2

1. Relational Database

2. Entity Relationship Diagram (ERD)

2.1 Basic Symbol and its purpose

2.2. Give two example of ER diagram

Quiz 3 - IT Elective 1 - Visual Programming

Quiz 3

1.Create a program that determine the equivalent grade of each students in class as follows:

a. Read in the students name, midterm grade, minor B, and final exam ratings.

b.Determine the final grade of students by the formula:

Final grade = 0.30 of midterm grade + 0.10 of minor B + 0.60 of final exam

c. Determine the equivalent grade for the numerical value obtained by the following students:

98-100 = 4.00

95-97 = 3.75

89-94 = 3.50

89-91 = 3.25

86-88 = 3.00

83-85 = 2.75

80-82 = 2.50

77-79 = 2.00

74-76 = 2.00

71-73 = 1.75

68-70 = 1.50

64-67 = 1.25

60-63 = 1.00

below 60 = 0.00

PHP

1. Create the design form below:

2. Save your file under the filename the Form: Signup.html

3. Create a another page in php format that will display the inputted value using POST method, save your file under the filename: result.php

#include
#include

int a,b,ans;

first()
{
ans = a + b;
printf("The answer is %d",ans);
}

main()
{
clrscr();
printf("Enter num1: ");
scanf("%d",&a);
printf("Enter num2: ");
scanf("%d",&b);
first();
getch();
}

Activity 3 - Stopwatch

Set the Following Properties:

Form1:

BorderStyle 1-Fixed Single

Caption Stopwatch Application

Name frmStopWatch

Command1:

Caption &Start Timing

Name cmdStart

Command2:

Caption &End Timing

Name cmdEnd

Command3:

Caption E&xit

Name cmdExit

Label1:

Caption Start Time

Label2:

Caption End Time

Label3:

Caption Elapsed Time

Label4:

BorderStyle 1-Fixed Single

Caption [Blank]

Name lblStart

Label5:

BorderStyle 1-Fixed Single

Caption [Blank]

Name lblEnd

Label6:

BorderStyle 1-Fixed Single

Caption [Blank]

Name lblElapsed

Activity 2 - Calendar

Exer4 : Input Text

1. Open Notepad++
2. Design a Form as shown below













3. Save your file: Exer4

Quiz1

1. Open MS Access
2. Database Filename is : Quiz1
3. Create two Tables: Product, Customer

Product Table:

Prod_ID, Prod_Name, Prod_Description, Prod_Supplier

Customer Table:

Cust_ID, Custo_Name, Cust_Address, Cust_Phone, Cust_Date_Purchased

Primary key : Product Table: Prod_ID
: Customer Table: Cust_ID

Note: Input at least 10 records for product and customer

4. After creating the two tables, Design a FORM with 3 buttons (Add Record, Delete Record, Delete Record).

Operating System - SWOT Analysis

1. Create a SWOT analysis of the following. Windows OS (XP,VISTA,WINDOWS 7) and Mac OS

2. Document format: short bond paper, 12pts, Arial Narrow..Template can be downloaded to this link www.hubss.weebly.com click lesson..

3. Deadline of Submission: Friday

IT Ethics - Computer Hacking

Orange County Computer Hacker Sentenced to Prison for Breaking into University Computers, NASA Systems

A Mission Viejo man who admitted hacking into computers operated by NASA, Oregon State University and a San Francisco Bay area Internet service provider was sentenced today to 21 months in federal prison.

Jason Allen Diekman, 20, was sentenced on three separate computer hacking cases, one of which involved the use of stolen credit card numbers in an attempt to wire transfer money through the Western Union Corporation.

Diekman was sentenced by United States District Judge Dean D. Pregerson, who also ordered Diekman to pay a total of $87,736.29 in restitution to the victims of his crimes. In addition, once released from prison, Judge Pregerson imposed severe restrictions on Diekman’s use of computers while he is under supervised release for a period of three years.

In the first case, Diekman pleaded guilty in November 2000 to charges of hacking into NASA computers and using stolen credit card numbers to purchase electronic equipment. In that case, Diekman pleaded guilty to one misdemeanor count of intentional unauthorized access of a government computer; one felony count of knowingly transmitting a program, code and command which recklessly caused damage to a computer; and one felony charge of unauthorized use of a credit card to obtain over $6,000 in electronic equipment.

By pleading guilty in this first case, Diekman admitted he illegally accessed government computers at NASA’s Jet Propulsion Laboratory in Pasadena, NASA computers at Stanford University, and numerous other government and university computer systems. Diekman, who used the nicknames "Shadow Knight" and "Dark Lord," gained unauthorized "root-level" access to at least three computer systems at JPL. This hacking activity gave him control over all aspects of the computers, including the ability to modify files and alter security on the systems. The NASA computer systems at Stanford were used to develop sensitive satellite flight control software used to control NASA satellites. As part of his guilty plea, Diekman admitted that he had caused $17,000 in damage to these computers.

During the investigation into this first case, federal agents discovered evidence on Diekman’s computers indicating that he intercepted usernames and passwords from universities, including Harvard University in Massachusetts. In a statement he made to investigators, Diekman admitted that he has hacked into "hundreds, maybe thousands" of computers, including systems at JPL, Stanford, Harvard, Cornell University, the California State University at Fullerton, and University of California campuses in Los Angeles and San Diego.

While he was free on bond after pleading guilty in first case, Diekman used his home computer to gain unauthorized access to computers at Oregon State University in Corvallis, Oregon. Diekman hacked into the university’s computers 33 times from February through April of 2001. Diekman used the account of an OSU student to gain access to the school’s computer system, where he stored computer programs to control Internet Relay Chat channels on the Internet.

In relation to the OSU case, Diekman also pleaded guilty to a wire fraud charge after individuals affiliated with him attempted to make three wire transfers through Western Union. In all three attempts, a person telephoned Western Union and requested that money be transferred to Jason Diekman of Orange County, California. In only one of the three transfers did the issuing credit card company initiate the transfer process, and that transfer was halted by Western Union security personnel.

Diekman was caught in the fraud against Western Union as a result of an internal investigation by AT&T into the theft of its services. After security personnel from AT&T reviewed recordings of telephone conversations in which the callers discussed defrauding Western Union, tapes of these conversations were turned over to the FBI. On the tapes, Diekman - who was using an alias he has used in the past and who was identified by an FBI agent familiar with his voice - is heard discussing with other people the possibility of obtaining fraudulent wire transfers from Western Union. As part of the guilty plea in the case involving OSU, Diekman admitted that he fraudulently obtained more than 8,000 minutes of long-distance services from AT&T.

In the third case, which was filed by the United States Attorney’s Office in San Jose, Diekman pleaded guilty on September 20, 2001in Los Angeles to federal charges of hacking into Bay Area Internet Solutions, Inc., an Internet service provider in San Jose. Diekman and others gained unauthorized "root-level access," which gave them complete control of the compromised computer systems and allowed them to obtain copies of various company databases that contained account information and passwords. Diekman and others also used the company’s computer systems to store computer exploits (programs that enabled unauthorized intruders to later gain access to the system and other computers) and caused over $50,000 in damages due to costs associated with investigating the intrusion and re-securing the systems.

Diekman has been held in a federal jail without bond since his arrest in the OSU hacking case on April 18, 2001.

The case was investigated by Special Agents of NASA’s Office of Inspector General, Computer Crime Division and the Computer Crimes Squad of the Federal Bureau of Investigation, Los Angeles Field Office.

1. Discuss the Kantianism and Consequencetailism theory in the case. How the two theory apply to the case..

Creating A Simple Web Browser

First of all, start a new project in VB2008 and name it with any name you like. Here I am just using the name webbrowser. Change the name of Form1 to webbrowser and the text property to My First Web Browser and set its size property to 640,480. Next, you need to add an engine so that your web browser can connect to the Internet, and this very engine is the WebBrowser control, located on the Toolbox on the left side, set the size property to 600,400. Next, drag a text box and place it at the top of the WebBrowser control, this will be the address bar where the user can enter the URL. Lastly, place a command button beside the text box and label it as Go. The design interface is shown below: The code for the web browser is surprisingly simple, it is only a single line code! Double click on the Go button and key in the following code: Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click myWebBrowser.Navigate(TextBox1.Text) End Sub End Class 　 Now run the the program , type in any URL and click the Go button. You will be able to browse any web page you want.

Database- Exer1

•Open MS Access 2003
•Create New Database name: Students
•Create 2 tables (STUDENTS, SUBJECTS)

Review Program

#include
#include

int x,y,z,m;

int main()
{
printf("Enter Number: ");
scanf("%d",&y);
printf("Enter another Number: ");
scanf("%d",&z);

for(x = 1; x <= y; x++)
{
m = y * z;
printf("%d x %d = %d\n",y,z,m);

}
getch();
return 0;
}

/* Program to reverse the digits of a number */

#include

#include

int main()

{ int num, rightdigit;

printf("Enter a number \n");

scanf("%d", &num);

while (num != 0)

{

rightdigit = num % 10;

printf("%d", rightdigit);

num = num / 10;

} printf("\n");

getch();

return 0;

}

#include

#include

int choice,quantity,Bill,cash,ans;

char option;

int main()

{

printf("\nValue Meal");

printf("\n1.] Burger Fries w/ Drinks 59.00");

printf("\n1.] Hotdog w/ Drinks 59.00");

printf("\nEnter Choice: ");

scanf("%d",&choice);

switch (choice)

{

case 1:

printf("Enter Quantity: ");

scanf("%d",&quantity);

printf("\nUpgrade [Y/N]: ");

scanf("%s",&option);

if (option == 'y')

{

Bill = quantity * 59 + 15;

printf("\nYour total Bill is %d",Bill);

printf("\nEnter Cash: ");

scanf("%d",&cash);

ans = cash - Bill;

printf("Your change is %d",ans);

}

if (option == 'n')

{

Bill = quantity * 59;

printf("\nYour total Bill is %d :",Bill);

printf("\nEnter Cash: ");

scanf("%d",&cash);

ans = cash - Bill;

printf("Your change is %d", ans);

break;

case 2:

printf("Enter Quantity: ");

scanf("%d",&quantity);

printf("\nUpgrade [Y/N]: ");

scanf("%s",&option);

if (option == 'y')

{

Bill = quantity * 59 + 15;

printf("\nYour total Bill is %d",Bill);

printf("\nEnter Cash: ");

scanf("%d",&cash);

ans = cash - Bill;

printf("Your change is %d",ans);

}

if (option == 'n')

{

Bill = quantity * 59;

printf("\nYour total Bill is %d :",Bill);

printf("\nEnter Cash: ");

scanf("%d",&cash);

ans = cash - Bill;

printf("Your change is %d", ans);

break;

}

}

}

getch();

return 0;

}

Will display even numbers

#include
#include

int main()
{
int i,y;
printf("Enter Number: ");
scanf("%d",&y);
for (i=0; i<=y; i+=2)
{
printf ("%d\n",i);
}

getch();
return 0;
}

Pizza Order

Example 3-2: Pizza Order

1. Start a new project. We'll build a form where a pizza order can be entered by simply clicking on check boxes and option buttons.

2. Draw three frames. In the first, draw three option buttons, in the second, draw two option buttons, and in the third, draw six check boxes. Draw two option buttons on the form. Add two command buttons. Make things look something like this.

3. Set the properties of the form and each control.

Form1:	BorderStyle	1-Fixed Single
	Caption	Pizza Order
	Name	frmPizza
Frame1:	Caption	Size
Frame2:	Caption	Crust Type
Frame3:	Caption	Toppings
Option1:	Caption	Small
	Name	optSize
	Value	True
Option2:	Caption	Medium
	Name	optSize (yes, create a control array)
Option3:	Caption	Large
	Name	optSize
Option4:	Caption	Thin Crust
	Name	optCrust
	Value	True
Option5:	Caption	Thick Crust
	Name	optCrust (yes, create a control array)
Option6:	Caption	Eat In
	Name	optWhere
	Value	True
Option7:	Caption	Take Out
	Name	optWhere (yes, create a control array)
Check1:	Caption	Extra Cheese
	Name	chkTop
Check2:	Caption	Mushrooms
	Name	chkTop (yes, create a control array)
Check3:	Caption	Black Olives
	Name	chkTop
Check4:	Caption	Onions
	Name	chkTop
Check5:	Caption	Green Peppers
	Name	chkTop
Check6:	Caption	Tomatoes
	Name	chkTop
Command1:	Caption	&Build Pizza
	Name	cmdBuild
Command2:	Caption	E&xit
	Name	cmdExit

The form should look like this now:

4. Declare the following variables in the general declarations area:

Option Explicit
Dim PizzaSize As String
Dim PizzaCrust As String
Dim PizzaWhere As String

This makes the size, crust, and location variables global to the form.

5. Attach this code to the Form_Load procedure. This initializes the pizza size, crust, and eating location.

Private Sub Form_Activate()

PizzaSize = "Small"
PizzaCrust = "Thin Crust"
PizzaWhere = "Eat In"

End Sub

Here, the global variables are initialized to their default values, corresponding to the default option buttons.

6. Attach this code to the three option button array Click events. Note the use of the Index variable:

Private Sub optSize_Click(Index As Integer)

PizzaSize = optSize(Index).Caption

End Sub

Private Sub optCrust_Click(Index As Integer)

PizzaCrust = optCrust(Index).Caption

End Sub

Private Sub optWhere_Click(Index As Integer)

PizzaWhere = optWhere(Index).Caption

End Sub

In each of these routines, when an option button is clicked, the value of the corresponding buttons caption is loaded into the respective variable.

7. Attach this code to the cmdBuild_Click event.

Private Sub cmdBuild_Click()

'This procedure builds a message box that displays your pizza type
Dim Message As String
Dim I As Integer
Message = PizzaWhere + vbCr
Message = Message + PizzaSize + " Pizza" + vbCr
Message = Message + PizzaCrust + vbCr
For I = 0 To 5

If chkTop(I).Value = vbChecked Then Message = Message + chkTop(I).Caption + vbCr

Next I
MsgBox Message, vbOKOnly, "Your Pizza"

End Sub

This code forms the first part of a message for a message box by concatenating the pizza size, crust type, and eating location (vbCr is a symbolic constant representing a �carriage return� that puts each piece of ordering information on a separate line). Next, the code cycles through the six topping check boxes and adds any checked information to the message. The code then displays the pizza order in a message box.

8. Attach this code to the cmdExit_Click event.

Private Sub cmdExit_Click()

End

End Sub

9. Get the application working. Notice how the different selection buttons work in their individual groups. Save your project.

Source : Click Me