COM4008 Introduction to Databases
rden 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
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 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.
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 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 代写COM4008 Introduction to Databasesplease 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 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.
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 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.
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
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
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.
B0207
10.30 AM
2
12.30
PM
RB2
£25
£50.00
Ms.Venus, Leeds,
LS11LZ
0741585709
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 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
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 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.
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.
- 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.
- Make 2 pre-bookings dated on 25th December 2024. Update the respective
tables to include the required pre-booking database records.
- 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.
- Find rental records based on a customer contact number.
- Find rental records based on a boat name.
- 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.
- Calculate the total number of boats booked and the actual income from the
available bookings for a day.
- 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.
- Two more Large Rowing boats are bought by the company. Update the
database records to include these new boats’ details.
- Due to the increase in the fuel charge, the rental amount for the Motorboats
has increased to £45, Update the respective database records.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.
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 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.
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 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.
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 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.
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
