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
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
