COM4008 Introduction to Databases
Database Design & Development
Date for Submission: Please refer to the timetable on ilearn
(The submission portal on ilearn will close at 14:00 UK time on the date of submission)
Page 1 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning
materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials please see the Arden Student Terms and Conditions.
Template: V5
Assignment Brief
As part of the formal assessment for the programme you are required to submit a Introduction to Databases assignment. Please refer to your Student Handbook for full details of the programme assessment scheme and general information on preparing and submitting assignments.
Learning Outcomes:
After completing the module, you should be able to:
a) Demonstrate a knowledge and understanding of databases and data
management systems.
b) Understand key principles of relational database design techniques.
c) Apply knowledge and understanding of database design and development to
design, implement, and test a relational database solution for a given scenario.
Graduate Attribute
d) Discipline Expertise: Knowledge and understanding of chosen field.
Possess a range of skills to operate within this sector, have a keen awareness of current developments in working practice being well positioned to respond to change.
All learning outcomes must be met to pass the module.
Page 2 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning
materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials please see the Arden Student Terms and Conditions.
Guidance
Your assignment should include: a title page containing your student number, the module name, the submission deadline and the exact word count of your submitted document; the appendices if relevant; and a reference list in AU Harvard system(s). You should address all the elements of the assignment task listed below. Please note that tutors will use the assessment criteria set out below in assessing your work.
You must not include your name in your submission because Arden University operates anonymous marking, which means that markers should not be aware of the identity of the student. However, please do not forget to include your STU number. Maximum word count: 3000 words (equivalent)
Please refer to the full word count policy which can be found in the Student Policies section here: Arden University | Regulatory Framework
The word count includes everything in the main body of the assessment (including in text citations and references). The word count excludes numerical data in tables, figures, diagrams, footnotes, reference list and appendices. All other printed words ARE included in the word count.
Students who exceed the wordcount up to a 10% margin will not be penalised. Students should note that no marks will be assigned to work exceeding the specified limit once the maximum assessment size limit has been reached.
Page 3 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning
materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials please see the Arden Student Terms and Conditions.
Assignment Task
Scenario:
You have been assigned as a database developer to create a database for a small boat rental company in the Lake district, UK.
The “Lakes Boat Rentals” is a small company, renting boats for the tourists at reasonable rental rates. The company owns 57 boats of five different categories and the details are shown in Table 1. Rental rates differ for every boat type, and it is given in hourly basis. That company will take a security deposit of £50 for every booking and it will be returned to the customer, when they return the boats. The rental records will be stored in a daily basis; sample bookings of the company for a day are provided in Table 2.
Until now, all data relating to their rentals has been stored and managed manually using a paper-based ledger. However, due to this manual way of processing, there have been times when data has been lost or incorrect and there are also concerns around data redundancy and security.
Now the company plan to store and manage all the bookings properly for better data organisation and taxation purposes. To improve the boat rentals data management and operations efficiency, it has been recommended to develop a database to manage the available boats, their rental records, and customers’ details.
Currently the ledger contains available boats, which is given below in Table 1 and sample bookings, which is given in Table 2. The boat rentals owner would like you to rationalise this into a relational database design and then develop and test it.
Page 4 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning
materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials please see the Arden Student Terms and Conditions.
Task 1
For this task tables and diagrams will be considered equivalent to word count contributions
The Lakes Boat Rentals company’s available boats and their details are given in the Table 1 and can also be found as a spreadsheet in the Assessment tab within the ilearn module:
Table 1: Boats’ Inventory Details
Boat Name /Type of boat
Boat Number
Rental rate per hour
Quantity
Available
Booked
Motorboats
Rowing boats
Canoes
MB1 - MB5
RB1 - RB8
Small (up to 4 ppl)
RBL1-RBL4
Large (up to 6 ppl)
CA1-CA5
£40 5 4 1 £25 8 5 3
£32 4 3 1
£25 5 4 1
Kayaks
KS01-KS10 Single kayak (1 person)
£20
10
6
4
KD01-KD10 Double kayak (2 people)
£25
10
10
0
Stand up paddle boards
SUP01-SUP15
£20
15
11
4
Page 5 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning
materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials please see the Arden Student Terms and Conditions.
The sample boat booking records for a day in July 2023 can be seen in the following Table 2 and can also be found as a spreadsheet in the Assessment tab within the ilearn module:
Table 2: Sample Booking Records
Boat Booking Records Date: 12/07/2023
Rental Reference Number
Start Time
Number of hours Booked
End Time
Booked Boat
Rental rate per hour
Rental Amount =Booked number of hours* rental rate per hour*number of boats
Customer Name & Address
Customer Mobile Number
B0201
9.00 AM
2
11.00 AM
RB1
£25
£50.00
Ms.Amy, Blackpool, FY11DH
0757772227
B0202
9.30 AM
1
10.30 AM
KS01, KS04
£20
£40.00
Mr.Mathew, London, HA90GG
0740498733
B0203
9.30 AM
1
10.30 AM
SUP01
£20
£20.00
Mr.Patrick, Leeds, LS257DF
0748779889
B0204
10.00 AM
1
11.00 AM
KS02, KS03
£20
£40.00
Ms.Susan, Sheffield, S11AD
0756789654
B0205
10.00 AM
1
11.00 AM
CA1
£25
£25.00
Mr.Gonzalez, Hyde, Manchester, M126JS
0744197402
B0206
10.30 AM
2
1.00 PM
RBL1
£32
£64.00
Ms.Rosy, Birmingham, B440AX
0747696561
Page 6 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials
please see the Arden Student Terms and Conditions. Template: V5
B0207 10.30 AM 2 12.30 RB2 £25 £50.00 Ms.Venus, Leeds, 0741585709 PM LS11LZ
B0208
10.30 AM
2
12.30 PM
MB1
£40
£80.00
Mr.Judah, Bristol, BS345BA
0747969755
B0209
11.30 AM
1
12.30 PM
SUP02,SUP03, SUP04
£20
£60.00
Mr.Kemiln, Rochdale, Manchester, BL96TP
0749562842
B0210
11.30 AM
2
1.30 PM
RB3
£25
£50.00
Mr.Hogan, Warrington, WA11DG
0749461765
Please make sure to use your Arden university allocated relational database account to answer the questions. Provide screenshots in the report evidencing each step of your work, as well as text-based copies of any SQL.
Page 7 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials
please see the Arden Student Terms and Conditions.
Logical Model
Based on the scenario and the data provided, create a logical model for the Lake boat rentals company’s database using a crow’s foot style Entity-Relationship diagram (e.g. Barker/UML, do NOT use the Chen diagramming style).
Make sure to normalise the data to 3NF, adding keys and identifier columns as appropriate and support with annotations. Make sure to note any assumptions made.
Physical Model
Using your logical model as a basis, create a physical model Entity-Relationship diagram using crow’s foot notation for a relational database provided by the Arden University. Make sure to use appropriate naming conventions and to identify data types, keys, and constraints. Note any assumptions made or further changes to the structure beyond those in the logical model.
Implementation
From the ERD constructed above, create the database using appropriate SQL in the relational database provided by the Arden University. Add the data from the provided information. Provide proper evidence of the database creation and data insertion with your database schema to verify that it is your code. Please ensure to use the relational database allocated to you by the Arden University for your database implementation otherwise, your assignment work will not receive any marks for the database implementation and further tasks.
Sample SQL Queries
Design and run 3 SQL test queries of your choice (simple to complex queries) to verify that your database functions and meets the needs of the scenario.
(2100 words equivalent) (70 marks) (LOs: 2, 3)
Page 8 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning
materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials please see the Arden Student Terms and Conditions.
Template: V5
Task 2
Provide solutions for the following problems in the form of SQL code and a brief explanation of your reasoning (approx. 200-300 words) for the Task 2. Apply your code to a copy of the database and include screenshots of SQL queries execution, its results along with your schema, evidencing this in each of the cases mentioned below. Ensure your schema or username is included in every screenshot to verify it is your code. Please ensure to use the relational database allocated to you by the Arden University for your task 2 otherwise, your assignment work will not receive any marks for it.
Case 1: Pre-Bookings
The company owner wants to improve the business by including pre-bookings for the boats.
a. Modify the database design for the required attributes regarding the pre- bookings like pre-booking date, time, required boat types, quantity, and customer details. During the pre-bookings, it is required to check always the quantity need to be at least one.
b. Make 2 pre-bookings dated on 25th December 2024. Update the respective tables to include the required pre-booking database records.
c. One pre-booking has been cancelled. Delete a pre-booking that has been created in the ‘Case 1b’.
Case 2: Search
To demonstrate the efficiency of searching to the boat rentals company owner, create searches based on the below mentioned criteria.
a. Find rental records based on a customer contact number.
b. Find rental records based on a boat name.
c. Find rental records booked based on booked time.
Case 3: Statistics
The owner would like to view income statistics, therefore, create the below calculations and show the results.
a. Calculate the total number of boats booked and the actual income from the available bookings for a day.
b. Calculate the expected income for an hour based on the total number of boats stored in the database.
Case 4: Data Manipulation
The company owner wants to test the inventory database based on various data manipulations. Write queries to perform the following operations.
a. Two more Large Rowing boats are bought by the company. Update the database records to include these new boats’ details.
b. Due to the increase in the fuel charge, the rental amount for the Motorboats has increased to £45, Update the respective database records.
Page 9 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning
materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials please see the Arden Student Terms and Conditions.
Case 5: Late Return Penalty
In the previous summer, the company owner found that there were many late returns of the boats. To discourage this, the owner is planning to charge a 25% increase in the rental amount for every 30 minutes of late return.
Inadvertently, Ms.Rosy returned her boat 30 minutes later than the actual booked hours. Update Ms.Rosy’s rental amount to reflect the extra time.
(900 words equivalent) (30 marks) (LOs: 1)
Page 10 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning
materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials please see the Arden Student Terms and Conditions.
Formative Feedback
You have the opportunity to submit a report to receive formative feedback.
The feedback is designed to help you develop areas of your work and it helps you develop your skills as an independent learner.
If you are a distance learning student, you should submit your work, by email, to your tutor, no later than 2 weeks before the actual submission deadline. If you are a blended learning student, your tutor will give you a deadline for formative feedback and further details.
Formative feedback will not be given to work submitted after the above date or the date specified by your tutor - if a blended learning student.
Referencing Guidance
You MUST underpin your analysis and evaluation of the key issues with appropriate and wide ranging academic research and ensure this is referenced using the AU Harvard system(s).
Follow this link to find the referencing guides for your subject: Arden Library
Submission Guidance
Assignments submitted late will not be accepted and will be marked as a 0% fail.
Your assessment can be submitted as a single Word (MS Word) or PDF file.
You must name the document with your student number ie Q1 STUXXXX. If you wish to overwrite your submission, you must ensure that your new submission is named exactly the same as the previous in order for the system to overwrite it. Please ensure to use the relational database allocated to you by the Arden University for your database implementation and further tasks. Also, ensure your username is included in all the screenshots of the database execution evidences to verify it is your work.
You must ensure that the submitted assignment is all your own work and that all sources used are correctly attributed. Penalties apply to assignments which show evidence of academic unfair practice. (See the Student Handbook which is available on the A-Z key information on iLearn.)
Page 11 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning
materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials please see the Arden Student Terms and Conditions.
Assessment Criteria (Learning objectives covered - all)
Level 4 is the first stage on the student journey into undergraduate study. At Level 4 students will be developing their knowledge
and understanding of the discipline and will be expected to demonstrate some of those skills and competences. Student are expected to express their ideas clearly and to structure and develop academic arguments in their work.
Students will begin to apply the theory which underpins the subject and will start to explore how this relates to other areas of their learning and any ethical considerations as appropriate. Students will begin to develop self-awareness of their own academic and professional development.
Grade
Mark Bands
Generic Assessment Criteria
First (1)
80%+
Outstanding performance which demonstrates the ability to analyse the subject area and to confidently apply theory whilst showing awareness of any relevant ethical considerations. The work shows an outstanding level of competence and confidence in managing appropriate sources and materials, initiative and excellent academic writing skills and professional skills (where appropriate). The work shows originality of thought.
70-79%
Excellent performance which demonstrates the ability to analyse the subject and apply theory whilst showing some awareness of any relevant ethical considerations. The work shows a high level of competence in managing sources and materials, initiative and excellent academic writing skills and professional skills (where appropriate).
The work shows originality of thought.
Upper second (2:1)
60-69%
Very good performance which demonstrates the ability to analyse the subject and apply some theory. The work shows a very good level of competence in managing sources and materials and some initiative. Academic writing skills are very good, and expression remains accurate overall.
Very good professional skills (where appropriate). The work shows some original thought.
Lower second (2:2)
50-59%
A good performance which begins to analyse the subject and apply some underpinning theory.
The work shows a sound level of competence in managing basic sources and materials. Academic writing skills are good, and expression remains accurate overall although the piece may lack structure. Good professional skills (where appropriate).
The work lacks some original thought.
Third (3)
40-49%
Satisfactory level of performance in which there are some omissions in understanding the subject, its underpinning theory, and ethical considerations. The work shows a satisfactory use of sources and materials.
Academic writing skills are limited and there are some errors in expression and the work may lack structure overall.
There are some difficulties in developing professional skills (where appropriate).
The work lacks original thought and is largely imitative.
Page 12 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials
please see the Arden Student Terms and Conditions.
Marginal Fail
30-39%
Limited performance in which there are omissions in understanding the subject, its underpinning theory, and ethical considerations. The work shows a limited use of sources and materials. Academic writing skills are weak and there are errors
in expression and the work may lack structure overall. There are difficulties in developing professional skills (where appropriate). The work lacks original thought and is largely imitative.
Clear fail
29% and Below
A poor performance in which there are substantial gaps in knowledge and understanding, underpinning theory and ethical considerations. The work shows little evidence in the use of appropriate sources and materials. Academic writing skills are very weak and there are numerous errors in expression. The work lacks structure overall.
Professional skills (where appropriate) are not developed. The work is imitative.
Page 13 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials
please see the Arden Student Terms and Conditions.
Assessment specific grading criteria:
Task 1
Measures:
“Understand key principles of relational database design techniques.”
“Apply knowledge and understanding of database design and development to design, implement, and test a relational database solution for a given scenario.”
29% and below 30-39% 40-49% 50-59% 60-69% 70-79% 80% and above
Logical Model (25%)
Little to no evidence of an understanding of key principles of ER diagram and normalisation upto 3NF.
Key principles included but are not limited to:
Identifying entities and attributes, entity relationship diagrams and symbols, normalisation and decomposition, cardinalities, and keys.
Some evidence of key principles of ER diagram and normalisation upto 3NF on a basic level, though many aspects are missing or misapplied.
Evidence is provided in an inconsistent manner that indicates some guesswork rather than the consistent misapplication of a principle.
Some evidence of key principles of ER diagram and normalisation upto 3NF, though some aspects are missing or regularly misapplied. Decisions are described rather than explained.
e.g. The student may have missed some core aspect of normalisation, though they have attempted to apply it in general. Cardinalities may be incorrect demonstrating a consistent misunderstanding of the concept.
Good evidence of key principles of ER diagram and normalisation upto 3NF supported with annotations, though a few aspects are sometimes misapplied. Decisions are accompanied by basic explanations.
e.g. Cardinalities may be incorrect in a few instances.
A few keys not optimally identified.
Very good evidence of key principles of ER diagram and normalisation upto 3NF supported with annotations, though a few aspects are sometimes misapplied. Decisions are well explained with occasional citation. e.g. Cardinalities may be incorrect in one or two instances.
One or two keys not optimally identified.
Excellent clear evidence of key principles of ER diagram and normalisation upto 3NF supported with annotations, though one or two aspects are misapplied.
Decisions are justified with some citation.
e.g. Cardinalities are consistent and appropriate. Normalisation is comprehensive and accompanied with reasoned explanations.
Exceptionally clear evidence of key principle of ER diagram and normalisation upto 3NF supported with detailed annotations, with consistent application. Decisions are well justified with appropriate citations. e.g. Consistent application of cardinalities, insight into decomposition demonstrated with references to appropriate literature.
29% and below 30-39% 40-49% 50-59% 60-69% 70-79% 80% and above
Page 14 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials
please see the Arden Student Terms and Conditions.
Physical Model (15%)
Inaccurately represents the logical model.
Lacks appropriate naming conventions, data types and constraints.
Some minor alignment with the proposed logical model.
Lacks multiple appropriate naming conventions, data types and constraints.
Mostly aligns with the proposed logical model, though explanations of differences may be missing.
Completely lacks any one of appropriate naming conventions, data types or constraints.
Aligns with the proposed logical model, though any reference to differences are descriptive rather than explanatory.
Some attempt to apply appropriate naming conventions, data types and constraints.
Aligns with the proposed logical model, with at least some differences sufficiently explained and some assumptions noted.
A somewhat consistent attempt to apply appropriate naming conventions, data types and constraints.
Aligns with the proposed logical model, with all differences sufficiently explained and any assumptions noted.
A consistent application of appropriate naming conventions, data types and constraints.
Aligns with the proposed logical model, with any differences or assumptions well justified.
A comprehensive, justified application of appropriate naming conventions, data types and constraints.
29% and below
30-39% 40-49% 50-59%
60-69% 70-79%
80% and above
Implementation (18%)
Database Implementation is missing, barely attempted or otherwise wholly deficient.
e.g. Does not relate to the proposed model. There are grievous errors in syntax which would make the code non-functional. The code is provided but the results are not evidenced or vice- versa.
Database Implementation is partially representative of the proposed model or there are large deficiencies in the execution with limited constraints.
e.g. Datatypes are wholly inappropriate. Primary and/or foreign keys constraints are not properly identified.
Database Implementation is mostly representative of the proposed model, though there may be some deficiencies in execution along with few of the constraints. e.g. Null constraints are not wholly consistently applied. One or two data types are inappropriate.
Database Implementation is nearly completely representative of the proposed model with most of the constraints, though simple and little consideration has been given to aspects like appropriate allocation of string size limits.
e.g., VARCHAR2(10) for a first name field.
Database Implementation is wholly representative of the proposed model, including some moderate complexities, with the required constraints.
e.g. appropriate string size limits and foreign key constraints consistently applied.
Database Implementation is wholly representative of the proposed model, including multiple complex considerations along with all the constraints. e.g. Composite key / foreign key constraints applied correctly to junction tables
.
Database Implementation is wholly representative of the proposed model and the execution demonstrates near professional level skills along with all the constraints.
e.g. The use of SQL scripting or columns defined/ populated by use of aggregate functions.
29% and below
30-39% 40-49% 50-59%
60-69% 70-79%
80% and above
Sample SQL queries (12%)
Queries are not provided, do not function, or do not address the any of the requirements of the scenario.
Queries are not provided, are partially functional or do not address the any of the requirements of the scenario.
Queries are provided, mostly functional but may only be tangentially connected to the scenario or demonstrate a surface level understanding.
Queries are provided, functional and address the requirements of the scenario, but demonstrate a surface level understanding.
Queries are provided, functional, address the requirements of, and demonstrates some critical consideration of the scenario.
Queries are provided, functional, address the requirements of, and demonstrates a comprehensive critical consideration of the scenario.
Queries are provided, functional, address the requirements of, and demonstrates both a critical and creative consideration of the scenario.
Task 2
Measures:
Page 15 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials
please see the Arden Student Terms and Conditions.
“Demonstrate a knowledge and understanding of databases and data management systems.”
29% and below 30-39% 40-49% 50-59% 60-69% 70-79% 80% and above
For each case:
Case 1: (5+4+2 = 11%)
Case 2: (2+2+2 = 6%)
Case 3: (2+2 = 4% )
Case 4: (3+3 = 6% )
Case 5: (3% )
Little to no evidence of understanding is demonstrated. Problem is not solved, or the SQL is non- functional.
Insufficient evidence of understanding SQL, terms may be confused or padded with irrelevant information. Incomplete solution is presented, or solution demonstrates a slight misunderstanding of the problem.
A basic level of understanding of SQL has been demonstrated. Terminology is mostly used correctly, though inconsistently.
Solution to the problem is mostly complete, though basic in approach.
Good evidence and understanding of SQL have been demonstrated. Terminology is mostly used correctly and consistently.
Solution to the problem is complete, though it may be inelegant in approach.
Very good demonstration and understanding of SQL Terminology is used correctly and consistently.
Solution is complete and demonstrates a well-considered approach to the problem.
Excellent demonstration and understanding of SQL; explanations are given, which are clear, well- illustrated and expressed in the students’ own words.
Terminology is used correctly and consistently.
Solution is complete, demonstrates a considered approach, with sound justifications supplied in each case.
Outstanding demonstration and understanding of SQL; explanations are given, which are clear, well- illustrated and expressed in the students’ own words.
Terminology is used correctly and consistently. Solution is complete and demonstrates a well- considered approach, with sound, well referenced, justifications.
Page 16 of 16
[2592]
Arden University © reserves all rights of copyright and all other intellectual property rights in the learning materials and this publication. No part of any of the learning materials or this publication may be reproduced, shared (including in private social media groups), stored in a retrieval system or transmitted in any form or means, including without limitation electronic, mechanical, photocopying, recording or otherwise, without the prior written consent of Arden University. To find out more about the use and distribution of programme materials
please see the Arden Student Terms and Conditions.
請加QQ：99515681 郵箱：99515681@qq.com WX：codinghelp
