COMP23111 University Of Manchester Notes | Assignment Help | Syllabus

Country: United Kingdom

University: University Of Manchester

Link to course

In both commercial and scientific settings, databases are critical, though generally unseen, components of contemporary computer systems. Data management has progressed from application-specific file management to enterprise-wide methods that see data as one of contemporary organizations’ most valuable assets and, as such, a major element in their capacity to compete and flourish. Database management systems (DBMSs) are the critical piece of software infrastructure required at this organizational level to deliver the desired outcomes with consistent quality and robust efficiency. A contemporary DBMS is a marvel, including numerous advancements in algorithms and data structures, programming language theory, conceptual modeling, concurrency theory, and distributed computing in its internal design and broad usage. As a result, database research is a data-centric exploration of many of today’s most fascinating subjects.


This training unit’s purpose is to expose students to the basic ideas and methods that underpin contemporary database management systems (DBMSs).

The training section looks at why people want to manage data as an asset and presents the fundamental architectural concepts that underpin contemporary database management systems. Different architectures and the application environments they provide are examined.

The relational model of data, relational database languages, and SQL, including views, triggers, embedded SQL, and procedural methods (e.g., PL/SQL), are then described and motivated in the course unit.

Students will learn how to create a conceptual data model (using the Extended Entity Relationship paradigm), map that model to a target implementation model (using the relational model), evaluate the latter’s quality using normalization, and write SQL queries against the improved implementation model to validate the resulting design against the data requirements. The Oracle DBMS is utilized for practical work.

The basics of transaction management, such as concurrency (e.g., locking, 2-phase locking, serialisability) and recovery (rollback and commit, 2-phase commit), as well as file organization (e.g., clustering) and the use of indexes for performance, are also covered in this training unit.

Finally, the course unit looks into database security by looking at the risks and solutions that are accessible. These include possible theft and fraud, as well as a loss of confidentiality, privacy, integrity, and availability in the event of the former. These mainly comprise methods for authorisation and access control, including the use of views for this purpose in the case of the latter. By presenting exemplars such as the 1995 EU Directive on Data Protection and the 1998 UK Data Protection Act, the course unit also tackles the subject of legal frameworks that give rise to responsibilities on the part of database professionals.


Data Management is a new concept.

Database Management as a Service, Data as an Asset, Records and Files, The Need for Models, The Need for Independence [Includes 1 lecture and background reading]

Database Architectures: An Overview

The ANSI/SPARC Approach, Schemas vs. Instances, Describing vs. Querying vs. Changing, DBMS Components and Architectures, Levels of Abstraction in Data Management, The ANSI/SPARC Approach, Schemas vs. Instances, Describing vs. Querying vs. Changing, DBMS Components and Architectures [Includes 1 lecture and background reading]

The Relational Paradigm: What It Is and What It Isn’t

The Relational Languages, The Relational Model [There will be two lectures plus background reading] [1 clinic example, 1 lab exercise]

Creating Databases

Building a Conceptual Data Model, Mapping a Conceptual Data Model to a Target, Identifying Functional Dependencies, and Normalizing the Schema are all steps in the process of creating a conceptual data model. [5 lectures with further reading] [3 clinic instances, 2 lab activities]

Interfacing with Software

Using Embedded Queries, Procedural Access, and Triggers, as well as Defining Views [Includes 1 lecture and background reading] [1 clinic example, 1 lab exercise]

Understanding Issues at the System Level

File Organizations and Indexes, Concurrency, Transactions, and Recovery [There will be two lectures plus background reading]

Taking Security and Privacy into Account

Legal Frameworks, Threats and Countermeasures [reading material]


The University of Manchester
Based on 1003 reviews
powered by Google
Ayda Matthews
Ayda Matthews
10:47 26 Sep 21
A top-class institution for only the highest achieving students! There is lots of support here from academics.... Furthermore, management listen to and accommodate students’ needs and concerns. Overall, a lovely community that I am pleased to be a part more
Perihan Abdelghaly
Perihan Abdelghaly
21:25 22 Aug 21
One of the universities in the UK to study. The staff is nice, food variety and facilities are great. The teaching... staff is very nice as well and the administration is fast and efficient. I love it and would love to go back read more
Alistair Chin
Alistair Chin
06:26 21 Aug 21
A beautiful and vibrant city. It is a shame that this university seem to be more profit-driven than most others with... huge compromise on education quality as well as student support. I would recommend this university as a first choice!read more
Barney Senrab
Barney Senrab
16:46 28 Jul 21
Great halls, super staff, so clean. We'll decorated and carpeted. Only down side is no parking.
Kevin Samuels
Kevin Samuels
14:21 21 Jul 21
A world-renowned university! Outstanding academic performance and groundbreaking research. Fantastic student community,... staff and managementread more
Andrew Bamford
Andrew Bamford
22:38 15 Jul 21
A world-class university, attracting only the highest-achieving students. Lots of support available here from academics... and support staff. Management are fantastic at listening to and accommodating the needs of more
Next Reviews


Writing an essay is no simple feat. Every year, students spend hours upon hours poring over books, compiling annotations and looking for pieces of information that can be put in order to create a coherent argument. Essay writing is a long and lengthy
process and not everyone picks it up as easily as others. That’s why many students choose to buy essays online that they can use as study material to help them plan their own university essays. However, not every essay writing service is capable of writing essays to the standard you need.


While there are many different services that allow you to buy an essay, you’re not always guaranteed to get what you expect. Getting cheap UK essays is never going to benefit your grade and you
never know who is writing them or whether or not they are capable of responding to your assignment. Some of the poorer quality essay writing services employ writers that don’t speak English, don’t understand the subject they are writing about
or, worst of all, choose to plagiarise other people’s essays. However, when you buy an essay from us, we guarantee that the work that you will receive is of great quality and worthy of a high grade.


At The Uni Tutor, you can buy an essay from an expert with experience in your field of study and capable of fully researching, sourcing and writing your essay to an exceptionally high standard.



Get an Instant Price. No Signup Required
The Uni Tutor Clients
















We respect your privacy and confidentiality!

We’ve been featured in…

Meanwhile, These Are

You don’t get plagiarism here. If you want a cheap & dirty essay, ripped from somewhere else, then go somewhere else to get it

Only English speakers will work on your essay – not some guy who learned English only 10 years ago. When we hire writers, they OWN the English language

With The Uni Tutor,
you don’t get your essay written by some undergrad halfway across the world – all our writers are academics. They KNOW science

Ivy League and Oxbridge academics write for us. No exceptions

100% No-Plagiarism guarantee: we use several specialised scanner
programs to make sure everything is original, every time

Buy Essays Online


We built The Uni Tutor to be the Rolls Royce of custom essay writing services and provide only genuine essays that are top quality and 100% free of plagiarism. We are one of
the top 3 essay writing services that allow you to buy essays online, with a team of talented essay writers, researchers and essay writing tools at our disposal to help you achieve the grade you want. We guarantee that when you buy an essay from
us, it will be correct and delivered on time, with a seven day grace period to make any changes should you need them.


We make it easy and affordable to buy essays online without negating any of the quality. When you buy an essay from us we can have it written and delivered to you in as little time as 24 hours, and you will have full ownership over the work you purchase.
Your essay will never be passed onto anyone else, making it completely original and one of a kind for you to use as a study resource. While it can feel risky to buy essays online, you can rest assured that with our essay writing services, none
of your information will be passed on to any other party, so you can put your trust in us.


So, buy an essay from the Uni Tutor if you’re looking for reliable, high quality work delivered fast.

Essays, Dissertations and Assignments

At The Uni Tutor, you buy essay and assignment help at a
very fair price. You’ll see that in a minute, with the instant quote calculator at the bottom of this page.

Basically, there are four factors that determine the cost when you buy an essay:

  • The desired academic grade you want from your assignment or thesis
  • The length of the essay
  • Delivery date: Rush jobs can often be done, but come at an extra fee
  • The subject matter: some subjects are more esoteric than others, meaning we sometimes need to hire a specialist writer for specific topics

The Order Now page tells you instantly how it will turn out for you, and you’ll see it’s not all that expensive to enlist the help of a custom essay writing

Once all your requirements are filled in, check the quote and hit start to buy your essay. That simple.

Please note that in some cases, the writer we assign to your project will offer an all-inclusive fee for your project, irrespective of the result from the calculator. He or she is, however, not allowed to quote more than our systems calculate.

Why not check our rates right now? You might be surprised how affordable it is to get your coursework or essay help from a proper researcher.

  • Completely original, custom written essays, dissertations and assignments, free of plagiarism
  • Correctly annotated and referenced
  • Can be delivered as fast as 24 hours after receipt of payment
  • Thoroughly researched academic work
  • Written to your exact requirements
  • Whatever subject you need written
Original Essays Icon

Completely original, custom written essays, dissertations and assignments, free
of plagiarism

Annotated and referenced essays

Correctly annotated and referenced

Essays met to your specific needs

Written to your exact requirements

Essays delivered in under 24 hours

Can be delivered as fast as 24 hours
after receipt of payment


Want to buy an essay? Here is our prices:

Undergraduate Essays

Our team of writers is thoroughly experienced in researching and writing for all levels of academic essays, coursework and dissertations.

Whatever the subject that you need researched, our academic writers are up to the task to write your undergraduate essay and help you get terrific grades. In 24 hours, or in two or four weeks, entirely up to you, and with guaranteed on-time
delivery, or your money back.

You tell us the precise level of research and the word count you require, and we give you the best essay writing services and employ the best academic writing experts that will definitely get you the grades you deserve.

That’s how simple. And don’t forget: Our 7-day grace period allows you to request any changes you would like to see.

Masters Essays

If you’re studying for your Masters degree and you need help writing an essay or dissertation, you’ll be happy to know that all of our writers are experts in writing essays for
MA, MBA, LLM, MSC essays and coursework.

If you get one of our writers to work for you, your coursework and essays will be completed to a Pass, Merit, or Distinction standard.

Your writer himself will be a Distinction Grade degree holder – what more could you want?

You tell us the precise level of research and the word count you require, and we get you essay help and academic writing that will definitely get excellent grades. That’s how simple. And don’t forget: Our 7-day grace period allows you to request
any changes you would like to see.

When You Need to Buy Essays
  • No Plagiarism: we use several programs to scan for plagiarism and we include a report when we approve and deliver your essay or assignment
  • 7 Days of unlimited alterations grace period for any changes to your coursework
  • Full ownership and intellectual property rights transferred to you when payment is completed: You will own all copyrights to the work once payment is complete. Nobody will ever be allowed to share, publish or distribute this work
    unless you give personal permission
  • Fully referenced and with correct and checked bibliography
  • Guaranteed to never be resold or published anywhere else
  • Top quality: We’re confident we are the best essay writing service and we will deliver a top quality essay to you. If your custom essay is not of the standard you ordered, your next essay comes free of charge. (One-time only for
    each purchased work)
  • Privacy and Confidentiality: We promise that neither your contact details nor your work will be passed to any other party whatsoever. We respect your privacy under all UK and US laws
  • On Time Delivery: We promise that you will receive your assignment, essay, dissertation or other coursework on time. If you do not receive your ordered works on the day we promise, you will receive your money back

For more information please see our Terms of Use and Privacy Policy.

With The Uni Tutor, you can’t go wrong. Check your quote, and get the best possible academic essay writing you could wish for.

Why choose us
IncludedStandard Service Elite Service
Your original and fully referenced workicon-blue-checkmarkicon-blue-checkmark
Standard 7 day period to request your researcher make changes to your work.icon-blue-checkmarkicon-blue-checkmark
Extended 90 day period to request your researcher make changes to your work.icon-red-xicon-blue-checkmark
Researcher fully qualified in your subject area and to your level of study.icon-blue-checkmarkicon-blue-checkmark
One of the top 5 researchers fully qualified in your subject area and to your level of study.icon-red-xicon-blue-checkmark
Personal account manager as your main point of contact.icon-red-xicon-blue-checkmark
Quality report that details all of the quality checks carried out on your work.icon-red-xicon-blue-checkmark
Plagiarism report that highlights any instances of plagiarism within your work.icon-blue-checkmarkicon-blue-checkmark
Don’t believe us?
Still Have Questions?

Our order process

Buying an essay couldn't be simpler

Order your dissertation with our three step order form. Once your form is complete you’ll be on the way to getting where you want to be. When we receive your order it is
matched to a writer with a minimum 2.1 degree in your subject, has English as a native language, and has experience in writing professionally. This writer will then start writing your dissertation to your specific instructions. Once your order
is complete our team will check that it meets all of our guarantees, including being plagiarism-free and to the grade that you ordered, before delivering it to you on time.

There are multiple ways to pay for your order, they are listed below.

Pay by Card

We use a secure payment system, and we never store any of your card details. We accept many payment cards inclusing; Visa, Mastercard and Delta

Paypal icon

Pay by PayPal

We take online card payments via PayPal, but you do not require an account with PayPal in order to pay with your credit or debit card.

Bank Building Icon

Pay by Bank Transfer

Please note that, in using this option, we will only start your order when payment has cleared which can take 3 – 5 days.

Video Guide

How the order process works