College of Engineering

Course Work

Name of the programme BEngg (Honors) in Computer Engineering(NU)

Name of Module with Code Web Programming - EEC20314

Level/Semester & AY Level -4 (Sem – B/ Spring )

Name of the Module Dr. Ramakrishna Kumar
Leader/Tutor Ms. Nasreya Nasser Sali Al Hinai
Coursework Type Final Report, Application and Presentation
Assessment weightage 50 % of CA
Type and date of Implementation of Dynamic Website + Report (Softcopy )
th
submission 17 May 2023 (Wednesday)

Aim To Design and Develop a dynamic website for the Real Estate
Agency
Learning Outcomes 1. Outline the importance of web as a medium of
communication
2. Formulate queries for an e-Business application.
3. Critically evaluate industry standard tools and techniques
which support e-Business activities.
4. Design, develop and test an interface for a database
driven website.
5. Deploy and maintain a database driven website.

Task(s)

This is an individual coursework.

Your task is to design and develop a dynamic website for the Real Estate Agency. The name
of the real estate agency is “Sindbad Homes”.

The dynamic website, which will interact with the SidbadHomes.mdb database, is to be used
to promote a subset of the properties and areas covered by the Governorate of Muscat based
Estate Agency

Web Programming (EEC20314) Rev:00. 20th Feb 2023 1

This initial database driven website will comprise THREE wilayats namely: Muttrah, Bowshar,
A'Seeb. There will be THREE property types in each area: Villas, Semi-Detached and Flats.
Each property type will have TWO properties promoted online.

Later enhancements to the website will expand the range of areas, property types and
properties promoted online; it will also include the ability to register an interest in viewing a
property!

In addition, the dynamic website will include the ability to

• Insert client information into the SindbadHomes.mdb database

• Query the SindbadHomes.mdb database

It is the responsibility of the student to ensure that the database, SindbadHomes.mdb, is

kept up-to-date.

Additional database information e.g. Area, Property type, Property

Features like bedrooms, view, solicitor etc should be sourced by the
student and added to the SindbadHomes.mdb database.

The Data Source name (DSN) for your version of SindbadHomes.mdb will follow the
established syntax

e.g. if you are a student with the first name Ahmed and student number 140469 then the DSN
is Ahmed140469

The structure of this database and the data definitions of each table and their relationships are
as follows:

Wilayats (Wilayat_ID, Wilayat_Title, Wilayet_Info)

Property (Property_ID, Property_Title, Wilalyat_ID)

Prop_Info (PropInfo_ID, Price, Construction_Date, No_of_Bedrooms, Colour, Address

Property_ID, Wilayat_ID)

Client (Client_ID, Client_Forename, Client_Surname, Client_Address_Line1,

Client_Address_Line2, Town, Postcode, Email_Address, Phone_No, Mobile_No)

BigImages (PropInfo_ID, AltAttribute, TitleAttribute, WidthAttribute, HeightAttribute, URL)

Thumbnails (PropInfo_ID, AltAttribute, TitleAttribute, WidthAttribute, HeightAttribute, URL)

Purchase (PropInfo_ID, Client_ID , Payment_Type, Payment_Mode, No_Installments,

Final_Price)

Note: Primary key fields are in bold; Foreign key fields are in bold-italics

Web Programming (EEC20314) Rev:00. 20th Feb 2023 2

All web pages must be capable of being presented in a consistent manner in all of the web
browsers identified in the user demographics.

In order to enhance the ‘user experience’ all web pages must ensure that:
• The textual content of all web pages must make use of properly structured XHTML
ensuring that all pages are implemented the assistive technology;
• Visual cues are consistent for mouse and keyboard users;
• ‘Skip navigation’ functionality is provided for keyboard and assistive technology users.

The company has specified a list of requirements that must be provided by the dynamic
website viz.

1. The home web page of your dynamic website must be named index.cfm.

2. The look & feel of the website on the screen is left up to you but it must be controlled from a
house style CSS file named screenStyle.css. Similarly, the format of the web page content
when printed out must be controlled a house style CSS file named printStyle.css.

3. The home web page, index.cfm, must contain:

• An appropriate title.
• An Estate Agency logo that you will create.
• Primary navigation for the areas.
• An appropriate heading;
• An appropriate promotional statement – which you will provide.

4. The dynamically generated area web page, area.cfm, must contain:

• An appropriate area title.

• An appropriate area heading.
• An appropriate primary navigation system (with the current area dealt with in the
conventional manner).
• A secondary navigation system that enables the user to navigate to a property type web
page for each of the property types which are currently on offer within that area.
• A graphical hyperlink back to the home web page that is based on the Estate Agency
logo (that you have to create).
• A breadcrumb trail.
• Promotional information, which you will provide, including
• Community facilities e.g. Leisure.
• Educational provision including nurseries, primary schools etc.
• Medical provision.

Web Programming (EEC20314) Rev:00. 20th Feb 2023 3

5. The dynamically generated Propperty Type web page, PropType.cfm, must contain:

• An appropriate property type title.

• An appropriate property type heading.
• An appropriate primary navigation system (with the current area dealt with in the
conventional manner).
• An appropriate secondary navigation system (with the current property type
dealt with in the conventional manner).
• A tertiary navigation system that enables the user to navigate to a property web
page for each of the properties which are currently on display in the current
property type.
• An advert for each of the properties which are presently on display in the
current property type – which you will provide, including
• Address of the property.
• Asking price.
• Brief description of the property.
• A thumbnail image (which is itself a hyperlink to the property web page!) for each
of the properties which are presently on display in the current property type –
which you will provide.
• A hyperlink to each of the other property type web pages within the current area;
• A graphical hyperlink back to the home web page that is based on the Estate
Agency logo (that you have to create);
• A breadcrumb trail.

6. The dynamically generated Property Info Web page, PropInfo.cfm, must contain:

• An appropriate property title;

• An appropriate property heading;
• An appropriate primary navigation system (with the current area dealt with in the
conventional manner);
• An appropriate secondary navigation system (with the current property type dealt with in
the conventional manner);
• An appropriate tertiary navigation system (with the current property dealt with in the
conventional manner);
• A graphical hyperlink back to the home web page that is based on the Estate Agency
logo (that you have to create);
• A breadcrumb trail;
• A property description - which you will provide, including
• Address of the property.
• An image of the property.
• Asking price of the property.
• Details of the property, including
o Features.
o Rooms.
o Location.
o Solicitor.
o Viewing arrangements.

• Link for purchasing vehicle (ie., Purchase.cfm page)

Web Programming (EEC20314) Rev:00. 20th Feb 2023 4

7. The Purchase Web page, Purchase.cfm, must contain:

• An appropriate Property Info title;

• An appropriate Property heading;
• An appropriate primary navigation system (with the current area dealt with in the
conventional manner);
• An appropriate secondary navigation system (with the current property type dealt
with in the conventional manner);
• An appropriate tertiary navigation system (with the current property dealt with in the
conventional manner);
• A graphical hyperlink back to the home web page that is based on the Estate Agency
logo (that you have to create);
• A breadcrumb trail;
• Provide a form which displays selected PropInfo_ID and price. Form should accept
payment_type (Credit Card/Cash), if customer selects Credit Card payment_type
then it should accept Credit Card number and card verification value (ie., 4 digit
numeric code). Customer should select the payment_mode (single
payment/Instalments), if customer selects Instalment mode then it should accept the
number of months for which EMI has to be paid. After EMI calculations display the
final price and append the data to Purchase table.

[Note: Maximum number of months for paying EMI is 24. Intrest Rate for first 12
months is 2.5% on total price of the property; if it is exceeding more than 12 months
then Intrest Rate is 3.9% on total price of property].

8. Each web page, dynamic or static, must also:

a) Be able to be printed out, containing only relevant content, in a format

appropriate for printed media.

b) Contain a footer area comprising

1. Estate Agency contact information:
• Phone number;
• Fax number;
• Address;
• e-Mail address.
2. Date of last update.

c) A textual hyperlink to a street map of Glasgow that shows the location of the
Estate Agency.

Web Programming (EEC20314) Rev:00. 20th Feb 2023 5

9. The home Web page, index.cfm, must also incorporate a utility (a textual hyperlink using
the text “Queries”) which is located in the top right hand portion of the Web page and takes
the user to the queries.htm Web page. The purpose of this queries Web page is to enable
users to:

• Register their details with the Sindbad Homes.

• Search the Sindbad Homes database.

10. The queries web page, query.htm, will provide the following functionality via an appropriate
user interface:

i. Client registration:
This will entail the provision of a form which will enable a user to register as a Renault
client. The registration web page must be named register.htm and the form must be
based on the data definition of the Client table in SindbadHomes.mdb database.
It will be assumed that a user will have only ONE email address, thus this unique
form data value can be used to prevent a user registering as a client for a second
time.

ii. Client list:

This list should include each client’s full name, town, email address, phone number and
mobile number. If there are no clients currently registered then an appropriate message
should be generated!

iii. Dynamic form:

Create a dynamically populated form which will enable the client to select a
wilayats and Property types from those Wilayats and Property Info currently held
in the database.
The users will be presented with a list of all property info satisfying the selected criteria.

iv. Price range:

Provide a form that enables the client to list Property Info within a user specified price
range.

11. You have the database freedom to extend the number of fields used by any table, but
not to delete any fields.

12. Students are expected to write a short report covering the following sections

• Introduction (Overview of the company, benefits after getting involved in e-commerce,

overview of technologies/tools involved)
• Current status of e-business in similar field (e-business model(s) adopted or
proposed.
• Developing ( Critical success factors for this website to work in practice, define
marketing strategies)
• Conclusions ( compatibility of site with different browsers, Review of steps taken to
meet accessibility requirements, evaluation of your website, areas for improvement in the
sector you investigated ) (clarity/Presentation of Report)

Web Programming (EEC20314) Rev:00. 20th Feb 2023 6

Instructions

1. Plagiarism is a serious offence. In case of any plagiarism detected, penalty will be

imposed leading to zero mark. Policy and guidelines for dealing with plagiarism and
malpractice in examination can be found in the student handbook or college portal.

2. The course work shall be subject to plagiarism software check through Black Board safe
assign.

3. Course work should be submitted on time. College guidelines on late submission of

coursework can be found in the student handbook or college portal.

4. Course work should be submitted with an appropriate cover page, which can be obtained
from the course in the blackboard.

5. For online submission of course work, pdf file with appropriate cover page mentioning
name of student, student number and title of the course work should be uploaded using
the submission link created and made available by the course leader in the black board.

Referencing

Harvard Referencing (CCE Style) First Edition 2013 should be followed for both in-text and
listing references. This downloadable document can be found in our CCE portal at:
http://portal.cce.edu.om/member/contentdetails.aspx?cid=628

Name and Signature of Module leader

---Ramakrishna Kumar-------------------------------- Date: 20-02-2023

Web Programming (EEC20314) Rev:00. 20th Feb 2023 7

 FINAL WEBSITE MARKING SCHEME
Student Name :
Student Number :
Program : BEng. Computer Engineering
Date :

S.No Assessment Criteria Total Mark

Mark Awarded
1 Depth of Understanding , Creativity, Innovation, Regularity, Behavior in
class & Lab, seriousness towards the subject, (Viva Voce) 10

2 Compliance with specification

Note: each omission of a distinct specification element will incur a deduction 10
of 1 mark, up to a maximum of 10 marks!
3 Dynamic Implementation
XHTML validation, CSS validation, Relevant content, Accessibility, Site
Navigation (Does all the links working properly, How many clicks to find
an information, etc.,), Additional enhancements/Additional addendum 20
and Visual Layout (Look of all the pages in a site , color schemes,
Graphics used, Topical Grouping , Search functionality, etc.,)

Database interaction
Client registration (5), List clients (5), Purchase form (5), Dynamic form
4 (10), Price range(5) (appropriate fields, proper validations , use of 40
appropriate data Input, ease of navigation in forms, use of various form
elements) (10).
Report

• Introduction (Overview of the company, benefits after getting

involved in e-commerce, overview of technologies/tools involved)
[5 mark]
• Current status of e-business in similar field (e-business model(s)
5 adopted or proposed [5 mark] 20
• Developing ( Critical success factors for this website to work in
practice, define marketing strategies) [5 mark]
• Conclusions ( compatibility of site with different browsers, Review
of steps taken to meet accessibility requirements, evaluation of
your website, areas for improvement in the sector you investigated
) (clarity/Presentation of Report) [5 mark]

TOTAL 100

Name of the Examiner:

Signature of the Examiner

Web Programming (EEC20314) Rev:00. 20th Feb 2023 8