Computer and Information System

Computer and Information System
Coursework Assessment
202010
Course CIA 4203 Enterprise Database Applications
Assessment Method Group Project
Date of Assessment Week14 Duration /
Deadline(s)
4 (week 14)
Maximum Mark 100 Percentage of
Final Grade
25%
Instructions to Students
1. This assessment has __ pages including the cover page.
2. This is an open book assessment.
3. Answer ALL questions.
4. Each student is required to submit the project deliverables individually onto Blackboard.
Academic Honesty Statement
In accordance with HCT policy LP201- Academic Honesty
• Students are required to refrain from all forms of academic dishonesty as defined and explained in HCT
procedures and directions from HCT personnel.
• A student found guilty of having committed acts of academic dishonesty may be subject to one or more of the
disciplinary measures as outlined in Article 33 of the Student and Academic Regulations.
إفادة الأمانة الأكاديمية
الأمانة الأكاديمية – LP وفقًا لسياسة كليات التقنية العليا 201
•يُطلب من الطلبة الامتناع عن كافة أشكال سوء الأمانة الأكاديمية، كما هو مبيّن وموضح في السياسات والإجراءات الخاصة بكليات التقنية العليا، والتوجيهات
الصادرة من موظفي الكليات.
•في حالة ارتكاب الطالب أي شكل من أشكال سوء الأمانة الأكاديمية سوف يتعرض الى واحد أو أكثر من التدابير التأديبية على النحو المبين في المادة 33 من
الأنظمة الأكاديمية.
Student HCT ID Student Name
Deliverable No/Oral
defense 1 2 3 4 Oral
Defense Total %
Marks Allocated 50 100 25
C I S 2 0 2 0 1 0 C I A 4 2 0 3 G r o u p P r o j e c t V 1
P a g e 2 | 12
Project Objectives
The general objective of the project is to investigate the development of students’ ability in designing
and implementing a web‐based data driven database application for a real‐life case.
The main objective of the project is to provide a hands‐on experience in the design and development
of a database application. The project provides a realistic experience in which students exercise skills
learned in the classroom.
Project Description
In this project, you will build a web‐based data driven application using Oracle APEX technology. In
this project you will demonstrate mastery of all the course learning outcomes. You can pick one of the
following topic:
1. Shopping application
2. Banking Application
3. Library Application
4. Airline Booking Application
5. RTA traffic management application
6. Student Registration Application
7. Insurance policies management system
8. Real Estate Agency Application
9. Point of Sale Application
10. Any other application proposed by the student and approved by the teacher.
You should submit to your instructor a detailed description of the selected topic and get his/her
approval to complete the work on the selected topic.
Project Tasks
APPLICATION DEVELOPMENT
TASK 1: APPLICATION‐DATABASE DESIGN & IMPLEMENTATION 5 MARKS
In this task, you will be designing the database of your system, including the ERD diagram and mapping
to a Relational Schema.
Ensure that the business case meets the requirements of this course. You should send your ERD to the
teacher and use the feedback from the teacher to enhance the data model.
The task report must include the following items: [CLO 5][Deliverable 1]:
1. Data Model (ERD), Relational Model, Data Dictionary
2. Data Definition Language (DDL) Script
3. Test data
C I S 2 0 2 0 1 0 C I A 4 2 0 3 G r o u p P r o j e c t V 1
P a g e 3 | 12
TASK 2: APPLICATION‐ FRONTEND (FORMS) 6 MARKS
Application form is one of the main compoment to form the presentation layer of the database. You
need to do the following [CLO 1, 5][Deliverable 2]:
1. Your application should include as many forms as needed to meet the requirements of the
user.
1. Create a number of forms (at least 3) to insert and update the data in the database.
2. Make sure that you create at least one (1) Master Detail forms.
3. NAVIGATION: All forms should be connected to each other using GUI controls (such as
buttons, menus, links) to enable the users to go from a screen to the next screen.
4. THEME: Your application forms should follow a specific theme provided by the Oracle APEX
and include all GUI components necessary to collect data from the users and show information
to the users.
5. Your application screens should include a wide variety of GUI components that demonstrate
your understanding of these GUI components
6. Your application screens should at least include the following GUI components: TextBox,
Button, Label, Checkbox, List (both static and dynamic lists) etc.
7. You should control your form layout properly.
8. At least (2) calculated Page items
9. Forms elements designed for reusability, includes plugins, images
TASK 3: APPLICATION‐ BACKEND (PL/SQL) 10 MARKS
PL/SQL code is the back bone to a database and it is maily used to wrte the the business logic of the
database. You need to do the following [CLO 2][Deliverable 3]:
1. Include a range of data validation techniques using PL/SQL.
2. Add at least two (2) functions and two (2) stored procedures using PL/SQL.
3. The GUI components in your application screens should be used correctly and properly to
handle different events that happen in your application (examples: clicking buttons, ticking
checkboxes, selecting a list item, etc.).
TASK 4: APPLICATION‐ FRONTEND (REPORT) 6 MARKS
Report is one of the main compoment to form the presentation layer of the database. You need to
do the following [CLO 3, 5][Deliverable 4]:
1. Create a number of reports to display the information using
a. Individual tables
b. Multiple tables using queries (Master ‐Detail Report)
2. Create at least one interactive and one static report.
3. A summary report (for example a monthly sales report) – the user should be able to enter the
dates/month for which report would be generated
4. Apply Groups and Summaries to at least one report using controls breaks, and aggregates
functions.
C I S 2 0 2 0 1 0 C I A 4 2 0 3 G r o u p P r o j e c t V 1
P a g e 4 | 12
5. Include at least one (1) graph/chart (using aggregate function) and one calendar.
6. Master‐Detail Report
TASK 5: APPLICATION‐ BACKEND (SECURITY) 8 MARKS
Evidence of application security features must be provided. For instance, you need to implement
different levels of authorizations to each user to access the application. You need to do the following
[CLO 4][Deliverable 5]:
1. Menu System and page navigation
2. Custom Authentication
3. Suitable Authorization scheme using Access Control List
TASK 6: APPLICATION QUALITY 10 MARKS
The application quality will be judged on the following points [all CLO][Deliverable 6]:
1. Error free and reliable system
2. Project has evidence of creativity – adds value to the user. Uses advance features.
3. Project Documentation
TASK 7: PROJECT DOCUMENTATION 5 MARKS
Create a report that includes all the previous tasks (from 1 to 6) including ERD of database and submit
it on BBLearn. Pay attention for the quality. [all CLOs][Deliverable 7]
ORAL DEFENSE: 20 MARKS
[all CLOs]
An oral defense will be conducted by group members at a given time slot and will involve a
walkthrough and discussion of the application and its code.
FOLLOW‐UP QUESTIONS 30 MARKS
[All CLOs]
Stduents will be asked 3 Follow‐up questions individually.
C I S 2 0 2 0 1 0 C I A 4 2 0 3 G r o u p P r o j e c t V 1
P a g e 5 | 12
Project Deliverables and Grades Distribution
GROUP‐BASED ASSESSMENT[50%]
1. Deliverable 1: DATABASE DESIGN [5 Marks]
2. Deliverable 2: APPLICATION‐ FRONTEND (FORMS) [6 Marks]
3. Deliverable 3: APPLICATION‐ BACKEND (PL/SQL) [10 Marks]
4. Deliverable 4: APPLICATION‐ FRONTEND (REPORT) [6 Marks]
5. Deilverable 5: APPLICATION‐ BACKEND (SECURITY) [8 Marks]
6. Deliverable 6: PROJECT DOCUMENTATION [5 Marks]
INDIVIDUAL‐BASED ASSESSMENT[50%]
1. Oral Communication (Walkthrough the code) [all CLOs] [20 Marks]
2. Follow‐up Questions and Discussion [all CLOs] [30 Marks]
C I S 2 0 2 0 1 0 C I A 2 5 0 3 G r o u p P r o j e c t V 1 P age 6 | 12
Rubric
Absent
(F)
Insufficient (1‐59.49%)
(F)
Emerging (60‐69.49%)
(D/D+/C‐)
Satisfactory (70‐76.49%)
(C/C+)
Competent (77‐86.49%)
(B‐/B/B+)
Mastering (87‐100%)
(A‐/A)
Group Grading [50%]
[CLO 5] Deliverable 1: Database Design & Implementation
[5 marks]
None of the following:
 ERD + Relational Model
+ Data Dictionary:
Model is consistent
with and fully
represents the scenario
selected. All
assumptions made are
reasonable and clearly
reflected
 Alignement between
ERD and DDL script
 All objects to support
the database are
correctly created with a
clear demonstration of
constraints.
 Extensive test Data with
a variety of values
A few of the following:
 ERD + Relational
Model + Data
Dictionary: Model is
consistent with and
fully represents the
scenario selected.
All assumptions
made are
reasonable and
clearly reflected
 Alignement
between ERD and
DDL script
 All objects to
support the
database are
correctly created
with a clear
demonstration of
constraints.
 Extensive test Data
with a variety of
values
Some of the following:
 ERD + Relational
Model + Data
Dictionary: Model is
consistent with and
fully represents the
scenario selected.
All assumptions
made are
reasonable and
clearly reflected
 Alignement
between ERD and
DDL script
 All objects to
support the
database are
correctly created
with a clear
demonstration of
constraints.
 Extensive test Data
with a variety of
values
Most but not all of the
following:
A few of the following:
 ERD + Relational
Model + Data
Dictionary: Model is
consistent with and
fully represents the
scenario selected.
All assumptions
made are
reasonable and
clearly reflected
 Alignement
between ERD and
DDL script
 All objects to
support the
database are
correctly created
with a clear
demonstration of
constraints.
 Extensive test Data
with a variety of
values
All of the following:
A few of the following:
 ERD + Relational
Model + Data
Dictionary: Model is
consistent with and
fully represents the
scenario selected.
All assumptions
made are
reasonable and
clearly reflected
 Alignement
between ERD and
DDL script
 All objects to
support the
database are
correctly created
with a clear
demonstration of
constraints.
 Extensive test Data
with a variety of
values
C I S 2 0 2 0 1 0 C I A 2 5 0 3 G r o u p P r o j e c t V 1 P age 7 | 12
[CLO1] Deliverable 2: Front End Development (Forms) [6 Marks]
 Forms are not designed
with the purpose and
context of what the
business application is
to achieve
 No master‐detail form
 Does not meet the
requirements of the
 business application
 Poor UI elements
 Users are not able to
know what is expected
of them when filling out
the form; also no use of
proper input methods
to reduce data entry
errors
 No use of calculated
items
 One form is
designed to serve a
specific purpose
 No master‐detail
form
 A few of appropriate
user interfaces
(input methods) are
implemented to
reduce data entry
errors
 Design for reusability
is limited (1
shared component,
plugin and/or
image)
 One calculated
items to forms is
implemented.
Calculated page
items replicates the
work done in‐class
 Two forms are
designed to serve a
specific purpose ( a
master‐detail form
is also
implemented)
 Some of
appropriate user
interfaces (input
methods) are
implemented to
reduce data entry
errors
 Design for reusability
is limited
(2 shared
components,
plugins and/or
images)
 Two calculated
items to forms are
implemented.
Calculated page
items replicates the
work done in‐class
 Three forms are
designed to serve a
specific purpose ( a
master‐detail form
is also
implemented)
 Most of appropriate
user interfaces
(input methods) are
implemented to
reduce data entry
errors
 Design for reusability
is sufficient
(3 shared
components,
plugins and/or
images)
 Three calculated
items to forms are
implemented.
Calculated page
items not replicate
the work done inclass
 Four or more Forms
designed to serve a
specific purpose (a
master‐detail form
is also
implemented)
 Provides a good
number of
appropriate user
interfaces (input
methods) to reduce
data entry errors
 Design for reusability
is enough
(4 shared
components,
plugins and/or
images)
 Four calculated
items to forms are
implemented.
Calculated page
items not replicate
the work done inclass
C I S 2 0 2 0 1 0 C I A 2 5 0 3 G r o u p P r o j e c t V 1 P age 8 | 12
[CLO 2 Deliverable 3: Back‐end PL/SQL] [10 Marks]
 No data validation using
appropriate methods
and error messages
 No Userdefined
functions and
procedures
 No Dynamic actions
 One data validation
using appropriate
methods and error
messages (validation
should not be
replicating the work
done inclass)
 One Userdefined
Function or
procedure is
provided (unique to
the project and not
replicating the work
done inclass)
 One dynamic action
is implemented and
doesn’t replicate the
work done inclass.
 Two data
validations using
appropriate
methods and error
messages
(validation should
not be replicating
the work done
inclass)
 Two Userdefined
Functions or
procedures are
provided (unique to
the project and not
replicating the work
done inclass)
 Two dynamic
actions are
implemented and
doesn’t replicate
the work done in
class.
 Three data
validations using
appropriate
methods and error
messages
(validation should
not be replicating
the work done
inclass)
 Three Userdefined
Functions or
procedures are
provided (unique to
the project and not
replicating the work
done inclass)
 Three dynamic
actions are
implemented and
doesn’t replicate
the work done in
class.
 Four data
validations using
appropriate
methods and error
messages
(validation should
not be replicating
the work done
inclass)
 Four Userdefined
Functions or
procedures are
provided (unique to
the project and not
replicating the work
done inclass)
 Four dynamic
actions are
implemented and
doesn’t replicate
the work done in
class.
[CLO 3, 5] Deliverable 4:
Application Frontend (Report) [6
Marks]
None of the following:
 Reports designed to
service specific purpose
(a variety of reports –
interactive and static
reports; using multiple
tables
 Summary report (such
as monthly sales report)
 Calendar
 Chart (using aggregate
functions)
A few of the following:
 Reports designed to
service specific
purpose (a variety of
reports – interactive
and static reports;
using multiple tables
 Summary report
(such as monthly
sales report)
 Calendar
Some of the following:
 Reports designed to
service specific
purpose (a variety
of reports –
interactive and
static reports; using
multiple tables
 Summary report
(such as monthly
sales report)
 Calendar
Most but not all of the
following:
 Reports designed to
service specific
purpose (a variety
of reports –
interactive and
static reports; using
multiple tables
 Summary report
(such as monthly
sales report)
All of the following:
 Reports designed to
service specific
purpose (a variety
of reports –
interactive and
static reports; using
multiple tables
 Summary report
(such as monthly
sales report)
 Calendar
C I S 2 0 2 0 1 0 C I A 2 5 0 3 G r o u p P r o j e c t V 1 P age 9 | 12
 Master‐Detail Report  Chart (using
aggregate functions)
 Master‐Detail
Report
 Chart (using
aggregate
functions)
 Master‐Detail
Report
 Calendar
 Chart (using
aggregate
functions)
 Master‐Detail
Report
 Chart (using
aggregate functions)
 Master‐Detail
Report
[CLO 3, 5] Deliverable 5: Application
Backend (Security) [8 Marks]
None of the following:
 All pages are accessible
through menu
 Page navigation
 Application is secured
through Custom
Authentication
 Suitable Authorization
scheme using Access
Control List
A few of the following:
 All pages are
accessible through
menu
 Page navigation
 Application is
secured through
Custom
Authentication
 Suitable
Authorization
scheme using Access
Control List
Some of the following:
 All pages are
accessible through
menu
 Page navigation
 Application is
secured through
Custom
Authentication
 Suitable
Authorization
scheme using
Access Control List
Most but not all of the
following:
 All pages are
accessible through
menu
 Page navigation
 Application is
secured through
Custom
Authentication
 Suitable
Authorization
scheme using
Access Control List
All of the following:
 All pages are
accessible through
menu
 Page navigation
 Application is
secured through
Custom
Authentication
 Suitable
Authorization
scheme using
Access Control List
[CLO all] Deliverable 6: Application
Quality [10 Marks]
None of the following:
 Error free and
reliable application
 Components properly
integrated within
application
 Project has
evidence of
creativity – adds
value to the user.
Uses advance
features
A few of the following:
 Error free and
reliable application
 Components
properly integrated
within application
 Project has
evidence of
creativity – adds
value to the user.
Uses advance
features
Some of the following:
 Error free and
reliable application
 Components
properly integrated
within application
 Project has
evidence of
creativity – adds
value to the user.
Uses advance
features
Most but not all of the
following:
 Error free and
reliable application
 Components
properly integrated
within application
 Project has
evidence of
creativity – adds
value to the user.
Uses advance
All of the following:
 Error free and
reliable application
 Components
properly integrated
within application
 Project has
evidence of
creativity – adds
value to the user.
Uses advance
features.
C I S 2 0 2 0 1 0 C I A 2 5 0 3 G r o u p P r o j e c t V 1 P age 10 | 12
features
[CLO all] Deliverable 7: Documentation [5 Marks]
None of the following:
 Ideas and evidence are
logically sequenced to
show clear relationships
 Transitions are varied
and connect ideas,
showing clear
relationships
 Conclusion, when
appropriate, is logical
and raises important
implications
 Is free of distracting
errors in grammar,
usage, and mechanics
 A complete
walkthrough of the
application is provided
with comments
A few of the following:
 Ideas and evidence
are logically
sequenced to show
clear relationships
 Transitions are
varied and connect
ideas, showing clear
relationships
 Conclusion, when
appropriate, is
logical and raises
important
implications
 Is free of distracting
errors in grammar,
usage, and
mechanics
 A complete
walkthrough of the
application is
provided with
comments
Some of the following:
 Ideas and evidence
are logically
sequenced to show
clear relationships
 Transitions are
varied and connect
ideas, showing clear
relationships
 Conclusion, when
appropriate, is
logical and raises
important
implications
 Is free of distracting
errors in grammar,
usage, and
mechanics
 A complete
walkthrough of the
application is
provided with
comments
Most but not all of the
following:
 Ideas and evidence
are logically
sequenced to show
clear relationships
 Transitions are
varied and connect
ideas, showing clear
relationships
 Conclusion, when
appropriate, is
logical and raises
important
implications
 Is free of distracting
errors in grammar,
usage, and
mechanics
 A complete
walkthrough of the
application is
provided with
comments
All of the following:
 Ideas and evidence
are logically
sequenced to show
clear relationships
 Transitions are
varied and connect
ideas, showing clear
relationships
 Conclusion, when
appropriate, is
logical and raises
important
implications
 Is free of distracting
errors in grammar,
usage, and
mechanics
 A complete
walkthrough of the
application is
provided with
comments
C I S 2 0 2 0 1 0 C I A 2 5 0 3 G r o u p P r o j e c t V 1 P age 11 | 12
Individual Grading [50%]
[CLO all] Oral Communication (Walkthrough the code) [25Marks]
 Communicates with a
limited sense of
audience and purpose
(No eye contact, no
body language, and no
poise)
 Communicates
information and ideas
with limited clarity
 Uses language with
limited accuracy and
effectiveness
 Student cannot explain
correctly the elements
of the application
 Team work contribution
is indufficient
 Makes minor
mistakes, but
quickly recovers
from them
 Student cannot
explain correctly
some of the
elements of the
application
 Team work
contribution is
minor
Some of the following:
 Communicates with
a strong sense of
audience and
purpose (holds
attention with the
use if direct eye
contact, seldom
looking at notes)
 Communicates
information and
ideas with a high
degree of clarity
 Uses Language with
a high degree of
accuracy and
effectiveness
 Student has an
excellent
understanding of
the project and the
business
application.
 Contributed to
teamwork as
expected
Most but not all of the
following:
 Communicates with
a strong sense of
audience and
purpose (holds
attention with the
use if direct eye
contact, seldom
looking at notes)
 Communicates
information and
ideas with a high
degree of clarity
 Uses Language with
a high degree of
accuracy and
effectiveness
 Student has an
excellent
understanding of
the project and the
business
application.
 Contributed to
teamwork as
expected
All of the following:
 Communicates with
a strong sense of
audience and
purpose (holds
attention with the
use if direct eye
contact, seldom
looking at notes)
 Communicates
information and
ideas with a high
degree of clarity
 Uses Language with
a high degree of
accuracy and
effectiveness
 Student has an
excellent
understanding of
the project and the
business
application.
 Contributed to
teamwork as
expected
C I S 2 0 2 0 1 0 C I A 2 5 0 3 G r o u p P r o j e c t V 1 P age 12 | 12
[CLO all] Follow‐up Questions
[25Marks]
 Unable to answer
questions from the
examining board
 Able to answer
some
but not all questions
from the examining
board
 Able to answer
most but not all
questions from the
examining board
 Able to answer all
questions from the
examining board
 Able to answer all
questions and
demonstrate a
complete
understanding of
the study
Order Now

Calculate a fair price for your paper

Such a cheap price for your free time and healthy sleep

1650 words
-
-
Place an order within a couple of minutes.
Get guaranteed assistance and 100% confidentiality.
Total price: $78
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?