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 (February 9, 2023) 4005CEM Database Systems Assignment. Retrieved from https://universalassignment.com/4005cem-database-systems-assignment/.
"4005CEM Database Systems Assignment." Universal Assignment - February 9, 2023, https://universalassignment.com/4005cem-database-systems-assignment/
Universal Assignment July 3, 2022 4005CEM Database Systems Assignment., viewed February 9, 2023,<https://universalassignment.com/4005cem-database-systems-assignment/>
Universal Assignment - 4005CEM Database Systems Assignment. [Internet]. [Accessed February 9, 2023]. Available from: https://universalassignment.com/4005cem-database-systems-assignment/
"4005CEM Database Systems Assignment." Universal Assignment - Accessed February 9, 2023. https://universalassignment.com/4005cem-database-systems-assignment/
"4005CEM Database Systems Assignment." Universal Assignment [Online]. Available: https://universalassignment.com/4005cem-database-systems-assignment/. [Accessed: February 9, 2023]

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.

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

BSBWOR502 – Lead and manage team effectiveness

BSBWOR502 – Lead and manage team effectiveness The BSBWOR502 – Lead and manage team effectiveness is a unit of the resource training. Also, it is competency training that helps aspiring team leaders build the necessary skills. Since team leadership in the workplace requires many abilities, this unit provides an approach

Read More »

BUSN 732 Writing Assignment 2

Description This assignment gives you an opportunity to read, summarize, and analyze material to be presented in a short report. Specifically, you are asked to read the five assigned articles on the Canadian Pension Plan (CPP) and make notes on the pros and cons of pension adoption discussed in each

Read More »

Assignment 2: Recorded Presentation

Weighting Percentage: 45% The purpose of this assessment task is to link an Aboriginal and / or Torres Strait Islander artwork with an issue that relates to health and wellbeing of Aboriginal and Torres Strait Islander people and explore the associated cultural and historical factors.  Each student is required to plan, create and submit

Read More »

Assignment 2 Research Proposal

ASSIGNMENT TWO GUIDE The Research Proposal This document contains everything you need to know for your second assignment. Please make sure to read this in full prior to asking any questions on Moodle. Below are the key things covered and the corresponding page numbers for easy access. Assignment 2 Research

Read More »

NUR133 ASSESSMENT 2 – Digital Presentation

NUR133 ASSESSMENT 2 – Digital Presentation (500 words + 10-minute presentation) TASK Select a service or program designed to improve the health outcomes of Aboriginal and/or Torres Strait Islander people and prepare a poster presentation that could be used to develop a brief, engaging education session for your peers. In

Read More »

MGMT2007 Organisational Behaviour

2021, MGMT2007 Organisational Behaviour 3,000-word Major Essay Pick ONE of these major essay questions to write an essay: Topic 1: Dealing with problems in an organisation under organisational change Example Scenario: Organisation X has implemented some drastic organisational changes recently. As a result, some of its employees have been laid

Read More »

NSB204 MENTAL HEALTH: Self and Others

Assessment Task 2 Assessment name: Case Study Task description: This assignment aims to help you to begin to use your professional and clinical judgement to think like nurses working in a mental health setting and/or in relation to the mental health needs of people regardless of the setting.   Choose

Read More »

MBA600 Business Report Individual written analysis

Assessment 2 Information Subject Code: MBA600 Subject Name: Capstone: Strategy Assessment Title: Assessment Type: Length: Business Report Individual written analysis 2000 words (+/- 10% allowable range) Weighting: 35% Total Marks: Submission: 100 Online Due Date: Week 10 Your task Using the same organisation from the first assessment, individually, you are

Read More »

HNN300 Child and Adolescent Health Assessment

Task 1: Written Assignment 1500 words (40%) Purpose of assessment task Childhood immunisation is a critical public health intervention that helps protect health and support normal development in infants, children, and young people. This assignment is designed to help you to analyse data, assess risk, and to develop skills to

Read More »

Importance of Aboriginal language

Due Date: 12 hrs   Format/Length: 800 words written Purpose: To explore, deconstruct and analyses the importance of Aboriginal language(s) in a contemporary context.  Task: You are to select an Aboriginal language initiative to research and develop your knowledge and understanding on the importance of keeping languages alive. This can

Read More »

Diverse Populations and Nursing Practice Reports

WORD LIMIT – 2500 – no introduction and conclusion required 7 headings required – headings, text-citations,                1200 words 1) Social determinants of health – 300 words 2) Health inequalities – 300 words 3) Health inequities – 300 words 4) Health outcomes – 300 words 1200 words 5) Application of

Read More »

Chronic Diseases

Introduction: The term “chronic disease” is increasingly often used by patients, healthcare professionals, researchers, etc. This term is defined differently by each person, and each definition encompasses a different set of medical disorders. Last but not least, the World Health Organization asserts that chronic illnesses are not contagious. They progress

Read More »

3. REPORT – Essay

STUDENT INSTRUCTIONS You are required to write a report as outlined in the assessment instruction and criteria listed below. It is important to ensure you read all aspects of the assessment topics and discuss any areas that require clarification with your assessor. Where there is a word limit it is

Read More »

Quality Areas 2 and 5 of the National Quality Standard

Access and review each of the Quality Areas in the ACECQA website, and for each of the given elements, provide one requirement that the element requires from an early years learning centre. You can access the page on the Quality Areas of the NQS using the link below: Quality Area

Read More »

National Health and Medical Research Council

Element Underpinning regulation from National Regulations Requirement of the regulation Underpinning section from the ECSNL Requirements of the section Element 2.1.1: Wellbeing and comfort         Element 2.2.1: Supervision         Element 5.1.1: Positive educator to child interactions         Element 5.2.2: Self-regulation  

Read More »

International Health and Development

Assessment Brief Module title: International Health and Development Assessment Point: First assessment point Assessment task: PART A: PowerPoint Presentation: 15 slides PART B: Word document: 1000-word count limit script for the slides Submission deadline: Please consult the VLE. Submission procedure: Please submit via the submission link on the VLE. Submission

Read More »

Outline the historical development of the policy

Outline the historical development of the policy including other linked policies highlighting key changes The Disability Support Pension is Australia’s universal health insurance scheme that guarantees all people who are unable to work due to a physical, mental, or intellectual disability financial help, which is a payment administered by Centrelink (Legal Services

Read More »

 SITHCCC027 – Prepare dishes using basic methods of cookery

Student Name  Student ID  Unit Name   SITHCCC027 – Prepare dishes using basic methods of cookery Practical Date  Submission Date  Student Declaration ☐ Student Plagiarism Declaration: By submitting this assessment to the college, I declare that this assessment task is original and has not been copied or taken from another source

Read More »

SITHCCC027 – Prepare dishes using basic methods of cookery

Student Name    Student ID   Blc01102 Unit Name   SITHCCC027 – Prepare dishes using basic methods of cookery Practical Date   07/02/2023 Submission Date    Student Declaration ☒ Student Plagiarism Declaration: By submitting this assessment to the college, I declare that this assessment task is original and has not been copied or

Read More »

Resource – Health promotion resource

ASSESSMENT:-             Resource – Health promotion resource Due date: – 10th August 2021   Length: – N/A Type of Collaboration:-                Individual Assessment Details It is the nurse’s role to provide information and education to enhance people’s control over their health (NMBA, 2016). The purpose of this assessment is to produce a

Read More »

The Aged Care Royal Commission Final Report

Discussion PAPER Assignment References 8 Australian Harvard 800 words  due 10th august The Aged Care Royal Commission Final Report titled Care, Dignity and Respect has now been released. The report calls for significant reforms to Australia’s aged care system. The final report also makes 148 recommendations for reform. In this

Read More »

HC3131 Business Research Project

Assessment Details and Submission Guidelines Trimester T2 2021 Unit Code HC3131 Unit Title Business Research Project Assessment Type 1, Topic Approval, Presentation Assessment Title Topic Approval Purpose of the assessment (with ULO Mapping) 1.Clearly identify your chosen topic, having carried out some basic review of available secondary data to secure

Read More »

Cases: Assessment Task 2

Case 1 Tina Tina is 18 years old and lives with her grandmother, older brother and two younger sisters. At present no one has a full-time job with both the grandmother and older brother currently on welfare. The two younger sisters currently enrolled in high school. Tina’s mother lives in

Read More »

NURBN3030 Supplementary Assessment

Written Case Study Report Application of health assessment, planning, implementation and evaluation of professional nursing care to a clinical deterioration patient scenario Due date:         As specified by the Course Coordinator Weighting:       Students must achieve a Pass grade (50%) for the Supplementary Assessment to achieve a Pass grade overall for the

Read More »

Competitive Advantage Video Project

Assessment 1 Information Subject Code: MBA600 Subject Name: Capstone: Strategy Assessment Title: Assessment Type: Length: Competitive Advantage Video Project Individual video recording 10 minutes (no more) Weighting: 25% Total Marks: Submission: 100 Online Due Date: Week 6 Your task Individually, you are required to record a 10-minute video, in which

Read More »

Analysis of Foundational Theory of Management

Class: Day and Time   Lecturer name   Student name / ID   ASSESSMENT 1 (30%) Written – Individual   Due:  Week 4 – Sunday, 15 August 2021 @ 23:59 Analysis of Foundational Study of Management – in the context of contemporary multidisciplinary business This assessment task is designed to address

Read More »

Relating the Class to World Events

Submit your assignment soon Even though your assignment is due on Aug 23, 4:59 PM AEST, try to submit it 1 or 2 days early if you can. Submitting early gives you a better chance of getting the peer reviews you need in time. Topic: Relating the Class to World

Read More »

Can't Find Your Assignment?

Open chat
1
Free Assistance
Universal Assignment
Hello 👋
How can we help you?