Faculty of Engineering, Environment and Computing 4005CEM Database Systems
4005CEM Database Systems
|Module Title Database Systems|
|Cohort: Resit/Deferral||Module Code 4005CEM|
|Coursework Title (e.g. CWK1) Individual Report||Hand out date: 20.05.2022|
|Lecturer Dr. Diana Hintea||Due date and time: 04.07.2022 Online: 18:00:00|
|Estimated Time (hrs):|
Word Limit*: 1000
Individual Written Report
|% of Module Mark|
|Submission arrangement online via Aula: File types and method of recording: Word or PDF Mark and Feedback date (DD/MM/YY): 25.07.2022 Mark and Feedback method (e.g. in lecture, electronic via Aula): Aula rubric|
|Module Learning Outcomes Assessed:|
Understand the sources of data in society, how to collect such data, the problems that might occur in collecting and storing such data and the basic statistics that are routinely performed on it. Model databases using techniques such as normalisation, entity relationship diagrams and a document-based approach. Create, populate and perform basic access approaches on a database using SQL Database Management System (DBMS). Analyse different types of data using tools such as R or Python.
|Task and Mark distribution:|
Write a 1000 words report on database design and its implementation based on the scenario below(100marks)
Currently there is no database being used for managing the information in the Car Rental Report Excel spreadsheet. The report should include the following:
An answer to the following question, together with a justification for the decision: In its current form, it is a traditional database. Should you keep it that way?
The detailed process of implementing the database using SQL, including the normalisation of the table (should that be required), the identification of the attributes, the Entity-
|Relationship Diagram, and the use of SQL commands in order to create and populate the tables with data.|
The SQL code for the following queries together with an explanation of the code: Find the supervisors of the branches which rented out SUVs – output the supervisor’s ID and name. Find the supervisors of the branches which had bills higher than 500 – output the supervisor’s ID and name. Find the supervisors of the branches which rented out cars in May 2021 – output the supervisor’s ID and name. Find the supervisors of the branches which handed out penalties – output the supervisor’s ID and name. Find the type of car that was rented the highest number of times – output the car type and the number of times.
A choice of 4 types of graphs suitable for analysing the information in the database, their implementation in Python (both the code and the output graph itself should be included in the report) and an explanation of what the graphs illustrate in your own words.
|Notes: You are expected to use the Coventry University APA. For support and advice on this students can contact CentreforAcademic Writing(CAW). Please notify your registry course support team and module leader for disability support. Any student requiring an extension or deferral should follow the university process as outlined here. The University cannot take responsibility for any coursework lost or corrupted on disks, laptops or personal computer. Students should therefore regularly back-up any work and are advised to save it on the University system. If there are technical or performance issues that prevent students submitting coursework through the online coursework submission system on the day of a coursework deadline, an appropriate extension to the coursework submission deadline will be agreed. This extension will normally be 24 hours or the next working day if the deadline falls on a Friday or over the weekend period. This will be communicated via your Module Leader. Assignments that are more than 10% over the word limit will result in a deduction of 10% of the mark i.e. a mark of 60% will lead to a reduction of 6% to 54%. The word limit includes quotations, but excludes the bibliography, reference list and tables. You are encouraged to check the originality of your work by using the draft Turnitin links on your Moodle Web. Collusion between students (where sections of your work are similar to the work submitted by other students in this or previous module cohorts) is taken extremely seriously and will be reported to the academic conduct panel. This applies to both courseworks and exam answers.|
- A marked difference between your writing style, knowledge and skill level demonstrated in class discussion, any test conditions and that demonstrated in a coursework assignment may result in you having to undertake a Viva Voce in order to prove the coursework assignment is entirely your own work.
- If you make use of the services of a proof reader in your work you must keep your original version and make it available as a demonstration of your written efforts.
- You must not submit work for assessment that you have already submitted (partially or in full), either for your current course or for another qualification of this university, unless this is specifically provided for in your assignment brief or specific course or module information. Where earlier work by you is citable, ie. it has already been published/submitted, you must reference it clearly. Identical pieces of work submitted concurrently will also be considered to be self- plagiarism.
This document is for Coventry University students for their own use in completing their assessed work for this module and should not be passed to third parties or posted on any website. Any infringements of this rule should be reported to email@example.com.
4005CEM Coursework Marking Scheme
I N D I V I D U A L R E P O R T
An answer to the following question, together with a justification for the decision: In its current form, it is a traditional database. Should you keep it that way? 5%
A main body detailing the process of implementing the database using SQL, including:
- normalisation of the table (should that be required) 10%
- the Entity-Relationship Diagram 10%
- use of SQL commands in order to create and populate the tables with data 5%
- SQL queries (15% in total – 3% each – 1.5% for the correct code and 1.5% for the code explanation)
- data analysis graphs (20% in total – 5% each – 3% for the correct code + output and 2% for the explanation)
Reflection and justification of the process for deriving above:
- justification of the database design steps (normalisation and ER diagram) 10%
- reflection on the coursework as a whole 5%
References and correct in text citation – at least 3 references, including books, journals or conference papers 5%
Spelling, grammar, scientific writing 6%
Consistent formatting (font size, colour, type, alignment) 3% Graphics, tables, visual aids, etc. 3%
Adopting an appropriate template (title page, table of contents, acronyms, table of figures, introduction, main body, reflection, conclusion, references) 3%
Get the complete solution for 4005CEM Database Systems Assignment from the best industry experts. Plag free, 100% safe. Order Online Now!No Fields Found.