Essay

BTEC Level 2 Information Technology Unit 16 Database System distinction example

1 purchase

Module
BTEC IT

Institution
BTEC IT

This piece of coursework for BTEC level 2 achieved a distinction. It covers every assessment and grading criteria for a distinction Please use this work as a guide only

[Show more]

Preview 4 out of 41 pages

View example

Uploaded on March 29, 2023
Number of pages 41
Written in 2022/2023
Type Essay
Professor(s) Unknown
Grade A+

Institution BTEC IT
Education BTEC IT
Module BTEC IT

£7.49

Add to cart

Add to wishlist

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached

Unit 16
Database Systems

BTEC LEVEL 2
INFORMATION TECHNOLOGY

Ann Other
JONES & SMITH LTD

,Contents
How businesses managed data before computers......................................................................2
What is a database...................................................................................................................... 3
What sort of business uses databases?.......................................................................................5
How can this business use a database?......................................................................................7
Explain 2 advantages and 2 disadvantages using the scenario of how the company can use a
database...................................................................................................................................... 8
What is data integrity?.................................................................................................................9
Why Data integrity will be important to Jones & Smith Ltd?.......................................................10
Explain why Jones & Smith should use reports..........................................................................11
Design the table structure for the database...............................................................................12
Design the structure of a data entry form for the database........................................................13
Design a query which will be useful for Jones & Smith Ltd........................................................17
Design a report based on the query...........................................................................................21
Explain your choice of fields, data types, and primary key.........................................................22
Explain why it will be necessary to calculate the data storage requirements of the database....23
Set up the table you designed....................................................................................................24
Test a non-relational database system to meet a given design..................................................30
Produce user documentation for a non-relational database system...........................................34
Justify improvements that could be made to a database system...............................................40

,How businesses managed data before computers

A company like Jones & Smith Ltd. probably used physical files and documents to
manage its data before computers and digital databases became widely available.

For instance, they might have kept a file with information about each property on their
books, including the address, number of bedrooms, asking price, and any other pertinent
information. They would either move a property to a separate archive section or update
the file when it was sold or removed from sale.

They would have had to manually compile and analyze the data from these files in order
to generate reports or keep track of sales data, which could take a long time and be
error-prone.

They would have needed to take actual photographs of each property and print them
out along with the relevant property information in order to create property sheets using
photos. After that, these sheets would be printed, given to customers, and displayed in
the agency window.

Compared to using a computerized database system, managing data manually would
have been a more labor-intensive and error-prone process overall.

, What is a database

A digital tool for storing, organizing, and managing large amounts of structured data is
called a database. It is a system that makes it simple for users or other software
programs to access, search, and update data.

A database, at its most fundamental level, is made up of tables with rows and columns.
A table has one row for each instance of data and one column for each attribute or
piece of information about that data. A customer database, for instance, might have
rows that each represent a single customer and columns that contain attributes like the
customer's name, email address, and order history.

Depending on the particular requirements of the company or organization utilizing the
database, it can be organized in a number of different ways. All data is stored in a single
table in some databases, which are organized as flat files. Some are set up in a
relational way, with data spread out across multiple tables that are linked by attributes.

The speed with which data can be searched and retrieved is one of the primary benefits
of using a database. Users can quickly locate specific pieces of information within a
database using search queries rather than manually sifting through paper records or
electronic files.

The ability to enforce data consistency and integrity is yet another advantage of using a
database. A database can assist in ensuring that all data entered into the system is
accurate and adheres to specified standards by defining data types and relationships
between tables.

Additionally, there are numerous ways to generate reports and visualize data using
databases. A sales data database could be used to make a report or a chart that shows
which products are selling the most or trends in revenue over time.

Databases can be found in a wide variety of forms, ranging from small desktop
applications to massive enterprise systems. Relational databases like MySQL or Oracle,
NoSQL databases like MongoDB or Cassandra, and graph databases like Neo4j or
OrientDB are among the most prevalent types of databases.

In conclusion, a database is a digital tool for managing, storing, and organizing a lot of
structured data. It can be used to generate reports and visualize data in a variety of
ways, ensures data consistency and integrity, and facilitates quick information searches

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

You can quickly pay through credit card for the summaries. There is no membership needed.

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller mrtracey. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for £7.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69411 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy revision notes and other study material for 15 years now

Start selling