Scribd
Upload
146 views4 pages

Marking Scheme: Unit: Databases Assignment Title: Universal Conference Management December 2015 - Sample Assignment

Uploaded by

Bright Harrison Mwale
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
146 views4 pages

Marking Scheme: Unit: Databases Assignment Title: Universal Conference Management December 2015 - Sample Assignment

Uploaded by

Bright Harrison Mwale
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Unit:

Databases
Assignment title:
Universal Conference Management
December 2015 – Sample Assignment

Marking Scheme
Markers are advised that, unless a task specifies that an answer be provided in a
particular form, then an answer that is correct (factually or in practical terms) must be
given the available marks. If there is doubt as to the correctness of an answer, the relevant
NCC Education materials should be the first authority.

This marking scheme has been prepared as a guide only to markers and there will
frequently be many alternative responses which will provide a valid answer.

Each candidate’s script must be fully annotated with the marker’s comments (where
applicable) and the marks allocated for each part of the tasks.

Throughout the marking, please credit any valid alternative point.

Where markers award half marks in any part of a task, they should ensure that the
total mark recorded for the task is rounded up to a whole mark.
Task Guide Maximum
Marks
1 a) Entity model (30 marks)

1 to 9 marks:
There is little correct beyond a few of the entities.

10 to 15 marks:
If choice of entities is correct (alternative names are acceptable) but
most relationships are wrong then give 1 mark for each correct entity.
Give additional marks for any correct relationships.

16 to 24 marks:
If largely correct but still with some mistakes, give 1 mark for each
correct entity and attribute.

25 to 30 marks:
Excellent solution that is correct in all but a few details.

Guide: The core of the system is the Events, Customers and Items
(of equipment). It should be possible to set up Events and assign
them to Customers. Events should be easily associated with multiple
members of staff and multiple items of equipment.

b) Data dictionary (10 marks)


The data dictionary should match the ER. It should clearly indicate
Primary Keys and Foreign Keys.

1 mark for each correct entity with attributes, PKs and FKs defined
up to 9 marks. Plus 1 mark if all correct. 40

Page 2 of 4
Databases © NCC Education Limited 2015
Task Guide Maximum
Marks
2 a) Candidate has created all the tables using SQL. Candidate has
shown their ‘create table’ scripts and the finished tables. (10 marks)

b) Candidate has entered data on all the events shown in the


assignment. (3 marks)

c) Candidate has entered data for five customers and associated


them with events. Note that a customer might have more than one
event associated with him or her. (3 marks)

d) Candidate has entered data on staff and items taken from the
assignment. Candidate has given a listing of this (3 marks)

e) Candidate has written a query that selects all the events ordered
by a particular customer. (3 marks)

f) Candidate has written a query that selects the staff and items
assigned to an event. (3 marks)

g) Candidate has written a query that selects all the customers’


details for events that require a laptop. (4 marks)

h) Candidate has written a query that counts all the birthdays that
need equipment from Edison Sound and Light. (4 marks)

i) Candidate has written a query that shows all the events and their
customers that need a waiter. (4 marks)

j) Candidate has written an update statement for the item table so


that Item 2 is no longer a laptop but a ‘tablet’. (4 marks)

k) Candidate has written an update statement for the staff table so


that Tara Patel is now known as Tara Williams. (4 marks)
45
3 This discussion should show an understanding of what the original
requirements were (up to 5 marks), include a discussion of how the
initial design attempted to meet them; (up to 5 marks) and an overall
assessment of how well the requirements have been met (up to 5
marks).

Alternatively structured discussions should be credited.


15
Total: 100 Marks

Page 3 of 4
Databases © NCC Education Limited 2015
Learning Outcomes matrix

Task Learning Outcomes Marker can differentiate


assessed between varying levels of
achievement
1 3, 4 Yes
2 5 Yes
3 3 Yes

Grade descriptors

Learning Outcome Pass Merit Distinction


Understand the Demonstrate Demonstrate Demonstrate highly
concepts associated adequate level of robust level of comprehensive level of
with database understanding understanding understanding
systems
Understand the Demonstrate Demonstrate Demonstrate highly
concepts associated adequate level of robust level of comprehensive level of
with the relational understanding understanding understanding
model
Understand how to Demonstrate Demonstrate Demonstrate highly
design and develop adequate level of robust level of comprehensive level of
a database system understanding understanding understanding
Be able to develop a Show adequate Show sound and Show innovative and
logical database development appropriate highly appropriate
design development development
Be able to develop a Show adequate Show sound and Show innovative and
database system development appropriate highly appropriate
using SQL development development

Page 4 of 4
Databases © NCC Education Limited 2015

You might also like