4005CEM Database Systems Assignment

Faculty of Engineering, Environment and Computing 4005CEM Database Systems

4005CEM Database Systems

Assignment Brief

Module Title Database Systems
Individual
Cohort: Resit/DeferralModule Code 4005CEM
Coursework Title (e.g. CWK1) Individual ReportHand out date: 20.05.2022
Lecturer Dr. Diana HinteaDue date and time: 04.07.2022 Online: 18:00:00
Estimated Time (hrs):
Word Limit*: 1000
Coursework type:
Individual Written Report
% of Module Mark
100%
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.
  1. 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.
  2. 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.
  3. 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 facultyregistry.eec@coventry.ac.uk.

4005CEM Coursework Marking Scheme

I N D I V I D U A L R E P O R T

Content85%

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%

Format 15%

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%

Order Now

Get the complete solution for 4005CEM Database Systems Assignment from the best industry experts. Plag free, 100% safe. Order Online Now!

No Fields Found.
Universal Assignment (July 20, 2025) 4005CEM Database Systems Assignment. Retrieved from https://universalassignment.com/4005cem-database-systems-assignment/.
"4005CEM Database Systems Assignment." Universal Assignment - July 20, 2025, https://universalassignment.com/4005cem-database-systems-assignment/
Universal Assignment July 3, 2022 4005CEM Database Systems Assignment., viewed July 20, 2025,<https://universalassignment.com/4005cem-database-systems-assignment/>
Universal Assignment - 4005CEM Database Systems Assignment. [Internet]. [Accessed July 20, 2025]. Available from: https://universalassignment.com/4005cem-database-systems-assignment/
"4005CEM Database Systems Assignment." Universal Assignment - Accessed July 20, 2025. https://universalassignment.com/4005cem-database-systems-assignment/
"4005CEM Database Systems Assignment." Universal Assignment [Online]. Available: https://universalassignment.com/4005cem-database-systems-assignment/. [Accessed: July 20, 2025]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Categories

Get 90%* Discount on Assignment Help

Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to info@universalassignment.com . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as $10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

Popular Assignments

Assignment Help in Rajkot – Expert Writing, AI‑Checked & 100% Original

Studying in Rajkot and tight on time with assignments, reports, or final year projects? Whether you’re a student at Saurashtra University, RK University, Government Engineering College (GEC), or Shantilal Shah Engineering College, UniversalAssignment.com offers specialized assignment help in Rajkot that’s crafted by expert writers and polished using AI tools for

Read More »

Assignment Help in Surat – Expert, AI‑Refined & Plagiarism‑Free Academic Support

Are you a student in Surat struggling with tight deadlines, subject-specific assignments, or research projects? Whether you’re enrolled at Sardar Vallabhbhai National Institute of Technology (SVNIT), Gujarat University – Surat Campus, Uka Tarsadia University, or Amity University, Surat, UniversalAssignment.com provides high-quality, AI-enhanced, and 100% plagiarism‑free assignment help in Surat—delivered by

Read More »

Assignment Help in Ludhiana – AI-Powered, Plagiarism-Free Academic Solutions

Are you a student in Ludhiana grappling with assignment deadlines, complex coursework, or research projects? Whether you’re enrolled at Guru Nanak Dev Engineering College (GNDEC), Punjab Agricultural University (PAU), Christian Medical College (CMC), or PCTE Group of Institutes, UniversalAssignment.com offers reliable assignment help in Ludhiana—expert-written, AI-enhanced, and 100% plagiarism-free. 🎯

Read More »

Assignment Help in Amritsar – AI-Powered, Plagiarism-Free Academic Solutions

Are you a student in Amritsar facing academic pressure, tight deadlines, or challenging course projects? Whether you’re enrolled at Guru Nanak Dev University (GNDU), Government Medical College Amritsar, Khalsa College, or Lovely Professional University (Amritsar campus), UniversalAssignment.com delivers reliable assignment help in Amritsar—expert-written, AI-enhanced, and 100% plagiarism-free. 📈 Why Students

Read More »

Assignment Help in Dehradun – AI‑Powered, Plagiarism‑Free Academic Support

Are you a student in Dehradun, managing multiple assignments, tight deadlines, or research projects? Whether you’re studying at Graphic Era University, Doon University, Uttarakhand Technical University (UTU), or Indian Institute of Management (IIM) Working), Universal Assignment provides reliable assignment help in Dehradun, powered by expert subject specialists and enhanced using

Read More »

Assignment Help in Raipur – AI‑Powered, Plagiarism‑Free Academic Support

Are you a student in Raipur dealing with tight deadlines, complex coursework, or final-year projects? Whether you’re at Chhattisgarh Swami Vivekanand Technical University (CSVTU), Pt. Ravishankar Shukla University (PRSU), NIT Raipur, or any private institute—Universal Assignment offers reliable assignment help in Raipur, backed by AI-powered proofreading and expert subject specialists

Read More »

Assignment Help in Bhubaneswar – AI‑Powered Expert Writing & 100% Original Content

Are you a student in Bhubaneswar, juggling deadlines for assignments, projects, or dissertations? Whether you’re attending Utkal University, KIIT University, XIM University, or Siksha ‘O’ Anusandhan (SOA), UniversalAssignment.com offers premier assignment help in Bhubaneswar, combining subject-matter expertise with advanced AI tools for plagiarism-free, university-aligned submissions. ✅ Why Students in Bhubaneswar

Read More »

Assignment Help in Ranchi – AI‑Powered, Plagiarism‑Free Academic Assistance

Are you a student in Ranchi, struggling with tight assignment deadlines, research write-ups, or subject-specific projects? Whether you’re enrolled at IIT Ranchi, Xavier University, Ranchi University, or another nearby institute, UniversalAssignment.com offers high‑quality, 100% plagiarism‑free assignment help in Ranchi, powered by AI tools and expert subject specialists. ✨ Why Choose

Read More »

Assignment Help in Bhopal – Plagiarism-Free, AI-Based Academic Support

Need expert help with your assignments in Bhopal? Whether you’re studying at Barkatullah University, MANIT, or any private institute, UniversalAssignment.com brings you fast, reliable, and 100% original academic solutions, powered by advanced AI tools and experienced human writers. We ensure every assignment is Turnitin-safe, thoroughly researched, and tailored to your

Read More »

Assignment Help in Lucknow – AI-Enhanced, Plagiarism-Free Academic Support

Are you a student in Lucknow struggling with complex assignments and tight deadlines? Whether you study at University of Lucknow, Amity University Lucknow, Integral University, or Dr. A.P.J. Abdul Kalam Technical University (AKTU), UniversalAssignment.com offers you reliable and high-quality assignment help in Lucknow with zero plagiarism and 100% confidentiality. We

Read More »

Assignment Help in Jaipur – AI-Powered, Plagiarism-Free Academic Assistance

Are you a student in Jaipur looking for high-quality, plagiarism-free academic support? Whether you’re pursuing engineering at MNIT, management at Jaipuria Institute, or law at Amity University Jaipur, UniversalAssignment.com is your one-stop solution for top-rated assignment help in Jaipur. We deliver AI-enhanced assignments with Turnitin-style plagiarism reports, expert-level research, and

Read More »

Assignment Help in Pune – AI-Based, Plagiarism-Free Academic Solutions

Are you a student in Pune struggling to complete assignments on time? Whether you’re from Savitribai Phule Pune University, Symbiosis International University, MIT-WPU, or Bharati Vidyapeeth, UniversalAssignment.com offers the most reliable and affordable assignment help in Pune — with zero plagiarism and AI-enhanced quality checks. We specialize in delivering university-specific,

Read More »

Assignment Help in Kolkata – AI-Enhanced, Plagiarism-Free Academic Support

Are you a student in Kolkata struggling with tough assignments, research papers, or academic deadlines? Whether you are studying at University of Calcutta, Jadavpur University, or Presidency University, UniversalAssignment.com is your trusted platform for reliable, plagiarism-free and AI-powered assignment help in Kolkata. We provide high-quality academic writing support to students

Read More »

Assignment Help in Mumbai – Trusted, AI-Powered & 100% Plagiarism-Free

Are you a student in Mumbai struggling with tight deadlines, complex assignments, or back-to-back submissions? Don’t worry — Universal Assignment offers the most trusted and professional assignment help in Mumbai, blending AI-powered tools with human expertise to deliver original, high-quality content every time. Whether you’re enrolled in Mumbai University, IIT

Read More »

Can't Find Your Assignment?