Java and Web Project (CSCT5101)
DIPET 2 in Fundamental Computer Science - FCST
Semester: First Semester
Level:
Year: 2019
REPUBLIC OF CAMEROON THE UNIVERSITY OF BAMENDA
Peace – Work – Fatherland P.O. BOX 39 BAMBILI
FIRST SEMESTER EXAMINATION
SCHOOL: HTTTC DEPARTMENT:CSC OPTION: FCS
COURSE CODE:CSCT5101 COURSE TITLE: Java and Web Project
LECTURER: Dr LIENOU CREDIT VALUE: 3
DATE: 16/03/2019 TIME: X START…..12:30PM END……2:00PM
Instructions: Documents are forbidden
Exercise 1 (4x5 + 10 + 5 + 5 = 40
mks)
Figure 1 represents an E/R model of a
database. You are therefore ask to:
a) Give the hibernate annotations
of all the entities knowing that all the
relationships are bidirectional
b) Write a JSF code representing
the form to capture data from an end user
for the DivisionalOfficers table.
c) Write an SQL query to compute
the area of region by adding all the areas
of Departments of the region
d) Write a JPQL code to compute the
population of a region by adding all the
populations of corresponding Department
Exercise 2 (10 + 10 + 10 = 30 mks)
a) Give 2 advantages of using connexion pools in JavaEE application
b) Draw the lifecycle of a HTTPServlet and annotate it
c) What do the following abreviation stand for?
JPA, JTA, JMX, JSTL, JDBC
Figure 1 E/R model of a database
www.schoolfaqs.net
