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