Scribd
Upload
87 views3 pages

Software Programming Practical

This document provides instructions for a software programming practical exam involving two questions. [1] The first question asks students to create a BMI calculator application in C# or Java that calculates BMI based on a given formula and user input for weight and height. [2] The second question involves creating an application to facilitate student record keeping for a school. Students must write code to [a] connect the user interface to a MySQL or SQL database, [b] save user input to the database, [c] clear user input fields, and [d] populate fields with student details based on an ID search. The document provides details on database structure and folder organization requirements.

Uploaded by

Ernest
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
87 views3 pages

Software Programming Practical

This document provides instructions for a software programming practical exam involving two questions. [1] The first question asks students to create a BMI calculator application in C# or Java that calculates BMI based on a given formula and user input for weight and height. [2] The second question involves creating an application to facilitate student record keeping for a school. Students must write code to [a] connect the user interface to a MySQL or SQL database, [b] save user input to the database, [c] clear user input fields, and [d] populate fields with student details based on an ID search. The document provides details on database structure and folder organization requirements.

Uploaded by

Ernest
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

TERTIARY AND VOCATIONAL EDUCATION COMMISSION

COMMON WRITTEN EXAMINATION

All rights reserved


NVQ Level 05 - Semester I
Information and Communication Technology

SOFTWARE PROGRAMMING (PRACTICAL) K72C001M04 Three Hours

* Answer all questions

Please carefully read following information before develop following


applications.

Important:-

 Write all code segments in C#.Net or Java.


 Use MySQL or SQL Database as back end of the system for Question (2).
 Use following details to create database and table for Question (2).
 Database Name:- ABC_Student_System
 Table Name:- Student
 Table field names and data types

Field Name Data type

sid int

name varchar(100)

address varchar(150)

gender varchar(6)
(Male or Female)

qualification varchar(5)
(O/L or A/L or NVQ-4)

course varchar(20)

dob date
 Create main folder with your index number and two sub folders as “Question
1”and “Question 2”.
 Source folders (source files) and database files (Script file and backup file)
copy into sub folders according to question number.
 All jar files (Java) or DLL files (C#.Net) copy into folder according to question
number if you have use to develop these application.

Question ( 1 )
Create Java or C#.Net application(BMI calculator) given below considering the
following formula and runtime interface. (30 marks)
BMI=weight (Kg) / height * height (m2)

155 cm
cm

62 kg

25.8

Question ( 2 )

The following interface use to facilitate student record of ABC Institute. The back
end for the system can be MySQL or SQL Database.

a) Write the code segment for connecting above interface with the MySQL or
MSSQL Database. (15 marks)

b) Write the code segment to save the information displayed on the form into the
database. (Save Button) (20marks)

Page2 | 3
Assume that database contains a table with the following structure:
Student (sid, name, address, gender, qualification, course, dob)

c) Write the code segment to clear the information displayed in the input fields
(Reset Button) (15 marks)

d) Write the code segment to fill the student details corresponding fields while
you type the student_ID in the Search text field (key released event) (20marks)

Page3 | 3

You might also like