Demonstrate a knowledge and understanding of databases and data management systems.

0% Plagiarism Guaranteed & Custom Written

COM4008 Introduction to Databases Database Design and 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)

Assignment Brief

As part of the formal assessment for the programme you are required to submit a database design and development 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:

  1. Demonstrate a knowledge and understanding of databases and data management systems.
  2. Understand key principles of relational database design techniques.
  3. Apply knowledge and understanding of database design and development to design, implement, and test a relational database solution for a given scenario.

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. Demonstrate a knowledge and understanding of databases and data management systems.

Maximum word count: 3000 words

Please refer to the full word count policy which can be found in the Student Policies section here: Arden University | Regulatory Framework

Please note the following:

Students are required to indicate the exact word count on the title page of the assessment.

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.

Please note that exceeding the word count by over 10% will result in a 10-percentage point deductionExplain, in your own words, what is meant by the term “relational database management system (RDBMS)”. Detail the characteristics of such a system and give two examples of RDBMSs in use today.

Assignment Task

Task 1

a) Explain, in your own words, what is meant by the term “relational database management system (RDBMS)”. Detail the characteristics of such a system and give two examples of RDBMSs in use today.

b)  Explain the 3-tier client-server application architecture, detailing the role of a DBMS in this architecture.

You MUST write your own answers and be sure to properly cite any sources used to inform your responses.

Any material copied directly from a third party with minimal or no paraphrasing (occasional synonym substitution, adding or removing adjectives and conjunctions) will not count as your own contribution. (500 words) (10 marks) (LOs: 1)

Task 2

a) A nursing home wants to create a small database driven application to advise staff on the resident patient’s medication types, doses, and times for administering said medication.

A current paper record looks like this:

Reflecting on the fields in this paperwork, normalise the data and present it as a series of tables. Explain each step taken to normalise to first normal form (1NF), second normal form (2NF) and third normal form (3NF) in turn

b) You have been supplied the following conceptual model, in a Chen diagrammatic style, and asked to transform it into a physical model fit for implementation in a MySQL RDBMS.

Translate this diagram into a physical model in a tabular form with crow’s foot notation, making sure to include all appropriate information (Data types, keys, constraints, etc.)

Accompany your diagram with explanations of all assumptions made about data formats and any decomposition decisions. (1000 words) (40 marks) (LOs: 2)

TASK 3

Scenario:

You have bought on as a database developer at a small web development company.

They have a new client, a local football club, who have engaged the company to build a website to help run their tournaments.

The company has a well-established front end development team, but unfortunately their sole database expert was poached by a larger company recently with little warning. As such they have had no time for a handover of knowledge on this project and have discovered that the back-end development was not documented at all! Demonstrate a knowledge and understanding of databases and data management systems.

The database is mostly complete, but there appear to be a few errors and missing functions. They will need fixing before the service can go into an open beta.

Provide solutions for the following problems in the form of SQL code and a brief explanation of your reasoning (approx. 300 words each). Also, apply your code to a copy of the sample database and include screenshots evidencing this in each case:

a) The front-end developers need some sample content entering into the fixtures table, so that they can run some tests. Provide SQL code that will add 5 suitable dummy records into the table for testing. Explain your choices.

b) Provide SQL statements that will return the sample fixtures data you have created:

-  In running order, from earliest to latest

-  In alphabetical order by home team name, then away team name

Explain, in your own words, what is meant by the term “relational database management system (RDBMS)”. Detail the characteristics of such a system and give two examples of RDBMSs in use today.

c)  The players table is currently accepting new entries with no date of birth. Unfortunately, the club insurance policy requires them to have this information, otherwise the players are not covered for any injuries sustained during a match.

 

How might the structure of the players table be changed to prevent entries with no date of birth?

d)  The front-end developers want to include a search function that lists players by searching for a club name. The search needs to support partial matches. This has not yet been developed. Suggest an SQL statement that could be used to make this work.

e)  The fixtures table is currently quite inefficient and prone to errors, altering a record to change the name of the tournament is causing problems. Suggest why this might be the case and provide a solution. (1500 words) (50 marks) (LOs: 3)

 

End of Questions


Diagrams.net (Free) https://app.diagrams.net/Suggested software for creating diagrams:

Lucidchart (3 diagrams free) https://www.lucidchart.com/

Sample sports database available at:

[TBC]

As technology and platforms may change, your module tutor will provide you with up-to-date details.

Formative Feedback

You have the opportunity to submit a draft 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 should be submitted as a single Word (MS Word) or PDF file. For more information please see the “Submitting an Assignment - Guide” document available on the A-Z key information on iLearn.

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. Demonstrate a knowledge and understanding of databases and data management systems.

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 excellent 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 very good 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 good level of competence in managing sources and materials and some initiative. Academic writing skills are good and expression remains accurate overall. Good professional skills (where appropriate). The work shows some original thought.

Lower second (2:2)

50-

59%

A satisfactory to 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 satisfactory and expression remains accurate overall although the piece may lack structure. Satisfactory professional skills (where appropriate). The work lacks some original thought.

Third (3)

40-

49%

Basic level of performance in which there are some omissions in understanding the subject, its underpinning theory and ethical considerations. The work shows a basic 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. Explain, in your own words, what is meant by the term “relational database management system (RDBMS)”. Detail the characteristics of such a system and give two examples of RDBMSs in use today.

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.

 

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.

Assessment specific grading criteria:

 

Task

< 30%

31-40%

41-50%

51-60%

61-70%

71-80%

> 80%

 

1

Measures: “Demonstrate a knowledge and understanding of databases and data management systems.”

 

Graded out of 100% then multiplied by

0.1 to give mark out of 10.

 

 

     x 0.1 =/10

Little to no evidence of understanding is demonstrated.

 

The student has merely cited other sources with little to no effort made to express ideas in their own words.

Some small evidence of understanding, though terms may be confused or padded with irrelevant information.

 

The student has weakly paraphrased other sources with little effort made to express concepts in their own words.

A basic level of understanding has been demonstrated through mostly descriptive content.

 

Cited sources sources are somewhat relevant or reasonably well paraphrased.

 

Terminology is mostly used correctly, though inconsistently.

Some understanding has been demonstrated through explanation. Demonstrate a knowledge and understanding of databases and data management systems.

Cited sources are mostly relevant and explained or well paraphrased.

 

Terminology is mostly used correctly and consistently.

A clear demonstration of understanding through explanation.

 

Cited sources are all relevant and explained or well paraphrased.

 

Terminology is used correctly and consistently.

Explanations and examples are given, which are clear, well illustrated and expressed in the students own words.

Cited sources are relevant and well used to support the student’s own words.

Terminology is used correctly and consistently.

Explanations and examples are given, which are clear, well illustrated and expressed in the students own words.

Knowledge of the subject matter demonstrates further reading and a comprehension of broader principles.

Cited sources are relevant and well used to support the student’s own words.

                             

2

Measures: “Understand key principles of relational database design techniques.”

Graded out of 100% then multiplied by

0.1 to give mark out of 10.

 

 

     x 0.4 =/40

Little to no evidence of an understanding of key principles.

 

Key principles include, but are not limited to: Identifying entities and attributes, entity relationship diagrams and symbols, naming conventions, normalisation and decomposition, cardinalities, keys, data types and constraints.

Some evidence of key principles 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, 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 clearly attempted to apply it in general.

 

Cardinalities may be incorrect demonstrating a consistent misunderstanding of the concept.

Good evidence of key principles, though a few aspects are sometimes misapplied.

 

Decisions are accompanied by basic explanations.

 

e.g. Cardinailities may be incorrect in a few instances.

 

A few data types or keys not optimally identified.

 

Appropriate constraints may be missing in

some cases.

Clear evidence of key principles, though a few aspects are sometimes misapplied.

 

Decisions are well explained with occassional citation.

 

e.g. Cardinailities may be incorrect in a few instances.

 

A few data types or keys not optimally identified.

Very clear evidence of key principles, though one or two aspects are misapplied.

 

Decisions are justified with some citation.

 

e.g. Cardinailities may be incorrect or not optimal in one or two instances.

 

One or two data types or keys not optimally identified.

Extremely clear evidence of key principles, 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.

 

Data types and constraints are comprehensively appropriate and applied.

 

3

Measures: “Apply knowledge and understanding of database design and development to design, implement, and test a relational

database solution for a given scenario.”

Graded out of 100% then multiplied by

0.1 to give mark out of 10.

 

 

     x 0.5 =/50

Little or no attempt has been made to appropriately respond to the scenario or problems presented.

Attempts to respond to the presented scenario and problems are non-functional, incomplete or wholly inconsistent.

 

Little or no explanation of decisions made.

Attempts to respond to the presented scenario and problems are mostly- functional, though they may not present a complete solution.

 

Information about decisions made is descriptive, not explanatory.

Attempts to respond to the presented scenario and problems are mostly- functional, though they may not present a complete solution.

 

Some explanations include valid justification.

Attempts to respond to the presented scenario and problems are functional, and present a complete solution in most cases.

 

Solutions are reasonably well justified with a few references to appropriate literature.

Attempts to respond to the presented scenario and problems are functional, and present a near complete solution in each case.

 

Justifications are included for nearly all aspects of the solutions with some references to appropriate literature.

Attempts to respond to the presented scenario and problems are functional, and present a complete solution in each case.

 

Justifications are included for all aspects of the solutions with references to appropriate literature.

(      / 10) + (     / 40) + (     / 50) 

Total:          / 100

Note: All sub-tasks are considered to be equally weighted. Where grades are awarded across mutiple sub-tasks, the marker will allocate grades appropriately.

e.g. If the task contains a part a) and b) they are considered together (as each relates to different aspects of the learning outcomes) and, a poor response to the second part would reduce the overall grade awarded, even if the reponse to the first part is of a high standard. Demonstrate a knowledge and understanding of databases and data management systems.


100% Plagiarism Free & Custom Written,
Tailored to your instructions
paypal checkout

Our Giveaways

Plagiarism Report

for £20 Free

Formatting

for £12 Free

Title page

for £10 Free

Bibliography

for £18 Free

Outline

for £9 Free

Limitless Amendments

for £14 Free

Get all these features for
£83.00 FREE

ORDER NOW
Still Not Convinced?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples
FLAT 50% OFF ON EVERY ORDER.Use "FLAT50" as your promo code during checkout