GHANA COMMUNICATION TECHNOLOGY UNIVERSITY
END OF FIRST SEMESTER EXAMINATIONS - 2020/2021 ACADEMIC YEAR
FACULTY OF COMPUTING AND INFORMATION SYSTEMS
DEPARTMENT OF INFORMATION SYSTEMS
END OF SEMESTER TAKE HOME EXAMINATION
CIIS 371 – INTERNET TECHNOLOGIES AND WEB DESIGN
LEVEL 300
BIT Start Date: 22ND APRIL 2020; 6:00 AM End Date: 26TH APRIL 2020; 23:59 PM
Examiner’s Name: Nuku Atta Kordzo ABIEW
Answer all questions
QUESTION ONE
LOGO
NUKSOFT LIMITED
HOME
SERVICES
PRODUCT
CONTACT US
Helping business grow
The above wireframe is the home page of Nuksoft Limited. The company through its Software Development Department is outsourcing the development of their web application to a potential GCTU Student of which you have won the contract. You are expected to create an HTML file with name index.php and a Cascading Style sheet with name, nuksoft_styles.css. Make use of only HTML tags. All styles should be control by the css file. Save all files in a folder and save all files related to this question in it. The name of the folder should be Nuksoft followed by your index number (e.g. Nuksoft-1081015001).
a. Nuksoft provides the following services.
i. Application Development
ii. Installation of CCTV
iii. Hardware and Networking
iv. IT Consultancy
Create a drop-down menu using an internal css style and javascript displaying the services as a sub menu. Link each of the sub menu to a unique page.
b. Create a similar menu for products. Nuksoft provides three main products to her customers. Each of these product categories have its related product as shown below.
 Desktop Application
i. School Management System
ii. Sales Management System
 Web Application
i. Hospital Management System
ii. Pharmacy Management System
iii. Asset Management System
 Mobile Application
i. GC-Chat
ii. Grademate
Create a link for each of the products to a general page for all products known as product-page.php.
c. Create a simple contact us page using your own design (contact-page.php) for getting contact details of potential customers. Customer information needed are names, digital-address, email, telephone number and message. All fields must be validated using JavaScript only.
d. Create a simple database with name nuksoftdb, create a table contactstb to store the contact details. Write appropriate php codes to connect to the database and insert records from the contact page into the database table.
Note: Export the database script and name it with your index number(108015001.sql). Where 108015001 is your index number. Remember to include the .sql file into the folder for this solution.
QUESTION TWO
FastLink Limited is a microfinance company that gives out loans to deserving customers. Customers pay simple interests on the loan given (Principal) per annum. FastLink urgently needs a system that will help them keep proper records on their customers as well as loan records.
1. Create a simple admin login interface.
2. Create a customer registration interface for registering customers. Customer information needed are names, marital status, employment status, name of employer, date of birth, ID Card type (Passport, NHIA, NIA, Voters’ ID, or driver’s license), address, email, and phone number.
Note: All fields must be validated using JavaScript.
3. Customers are charged a simple interest per annum on any approved loan. Assuming every loan applied for is approved, develop an interface that will help the company to keep records of their loan applicants in a database. Remember, only registered customers of the company can access loans.
Simple Interest (SI) = (Principal (P) * Rate(R) * Time (T)) / 100.
The Principal, Rate and Time should be entered.
4. Create an interface for retrieving the loan records of a client showing the basic records of the client as well as the loan records of the client.
QUESTION THREE
Write an HTML codes that can be used to generate the page shown below.
QUESTION FOUR
As part of the anniversary celebration of Ghana Communication Technology University-GCTU, you are required as a webmaster to write an online multiple-choice question to be administered to selected Senior High Schools in the country. Write an HTML code that can be used to achieve the above web page. Marks will be awarded on the appropriate usage of the relevant, required, and appropriate tags.