Department of Computing
FINAL ASSIGNMENT
The distribution of marks among the parts of the question is indicated.
INSTRUCTIONS TO CANDIDATE
Please upload your answers to the provided “Final Exam /Assignment” space on Moodle. You
may either type your answers in Word or handwrite and scan / photograph them.
It is essential that you write your student number at the top of your answers and, if handwriting,
on every sheet you use.
If you have written or drawn anything on paper, please keep your copy so further photographs
can be sent if needed during marking.
THIS IS AN OPEN-BOOK EXAM / ASSIGNMENT AND YOU MAY CONSULT YOUR
NOTES, BUT YOU MAY NOT CONSULT ANY ONLINE RESOURCE.
YOU MUST COMPLETE THE EXAM / ASSIGNMENT UNDER EXAM CONDITIONS. YOU
MUST TALK TO NO ONE AND MUST WORK ALONE.
INCLUDE THE FOLLOWING DECLARATION AT THE END OF YOUR SUBMISSION:
“I DECLARE THAT THIS IS MY OWN WORK”
DO NOT SIGN THIS DECLARATION.
This assignment paper consists of THREE (3) printed pages including the front page.
COURSE : DATABASE SYSTEMS
COURSE CODE : BCI2023
LECTURER : Gamal Mohamed
DATE : 11/06/2020
TIME : 11:59 PM
TOTAL MARKS : 100
SEMESTER /SESSION : Semester 2 / 2019-2020
PROGRAMME : BCN/BCS/BCG
Final Assignment: [Open Book]
BCN2023 Page 2
QUESTION 1 [50 Marks]
Read the below case study very well , understand, anlaysis and extract the useful
information from it that can help you in answering the two questions related to it shown
below it.
Muscat College is well known for the quality of its academic programs which aim at
providing students with a true college education. Established in 1996 the College started its
first academic year in 1997. Since then, the College has produced thousands of
undergraduate students. In its academic programs the college serves more than thousand
students in its various foundation, diploma, bachelor with honors and master degrees
programs.
The registration department in the college has appointed you as a member in a team to
develop its registration system database which can cover the information in the areas of:
Student, Result, Modules, Lecturer, Subjects, Programs, Semester, Library,
Accountant, Labs, Class Rooms, Activities…etc. for each area mentioned earlier there
could be many properties for example properties such as Module Name, Module Code,
Number of Assessments could be related to Module and the same case could be done for
other functioning areas. You have been asked to produce a final report that can help in either
establishing a new registration database management system or developing the existing one.
With this background you are asked to perform the below shown tasks:
a) With a bit of analysis to the current scenario of the college strength and various programs,
identify and propose at least SIX (6) main entities with their corresponding attributes.
(12 Marks)
b) With respect to the attributes you have identified for all entities show and explain with real
examples the types of the attributes. (8 Marks)
c) Show these entities with their attributes in an ER model following both Gen Model and Crow’s
Foot Model. (15 Marks)
d) Relationships is very important in database management, with relation to your identified entities
and attributes show with a real examples and drawings how the FOUR(4) types of relationship
could be established. (15 Marks)
QUESTION 2 [50 MARKS]
The college has employed a new employers Majid and Noor to assist you in producing a testing
portfolio for the system been designed initially for the sake of testing its efficiency and
reliability. For that a real output for converting the entities and its corresponding attributes
suggested by you earlier to a real computerized data in a form of tables, queries and reports.
With this background perform the below tasks and show their outputs in your final report:
a) Show the implementation for the command for creating all the above tables with their
corresponding fields suggested by your team from the already identified entities and
attributes. (10 Marks)
b) Show the insertion of the records in all of the above tables with their fields that you have
created using step above in (a). One record for each table. (10 Marks)
c) Your manager would like to make sure that your proposed software for registration
management system has more facilities show this practically in some of selected fields of
some of your tables like how to alter field information, updating of record information
deletion of some records. (15 Marks)
d) As a test for the students’ ability and possibility of applying quires you have been asked
to write TWO (2) quires one of them using only one table in the query and the other
using multiple tables in the same query. Those queries could be implemented to show the
workability of the system in this area. (5 Marks)
e) The new created system needs to be checked whether it can support full report generation
or not for that you have been asked to generate ONE report in any of the student’s areas
i.e. registration of subjects, payment of fees or results generation. (10 Marks)
**END OF ASSIGNMENT PAPER**
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
Like this:
Like Loading...