0% Plagiarism Guaranteed & Custom Written

Plan, create and modify relational database tables to meet requirements

Post Date: 27 - Nov - 2019

Unit 21:

Database Software

Unit code: T/502/4556
QCF level: 3
Credit value: 6
Guided learning hours: 45

Unit aim

The aim of this unit is to enable learners to understand the features of relational databases and to develop the skills necessary to design, create and populate a relational database, as well as utilising software tools to manipulate data.

Unit introduction

Database software is one of the most commonly used application packages in business. Many jobs involve the use of databases and for this reason employees with database skills are valued. The advantages of using a relational database are extensive, including significantly reduced data storage requirements, improved record manipulation and faster access to records. As with spreadsheets, data mining software can make use of database files to interrogate records and look for trends or unusual events.

Most organisations use databases in some way to store records, for example customer information, supplier information, employee details and financial information. These records can be searched, sorted, ordered, and cross- referenced using relational databases. Using a simplified chart tool, graphs and charts can also be created and embedded in reports.

To ensure that relational databases have integrity, validity and efficiency, planning the database prior to implementation is important. Failure to do this may result in a poor product. Efficient relational database design is managed through the process of normalisation and it is important learners understand the importance this brings to developing efficient and effective databases.

In this unit learners will develop understanding of database software and principles, in order to set up an effective and efficient database. Furthermore, learners will be able to use features and functions to manipulate data to yield the desired result.

Learning outcomes and assessment criteria

In order to pass this unit, the evidence that the learner presents for assessment needs to demonstrate that they can meet all the learning outcomes for the unit. The assessment criteria determine the standard required to achieve the unit.

On completion of this unit a learner should:

Learning outcomes

Assessment criteria

1    Plan, create and modify relational database tables to meet requirements

1.1    Explain how a relational database design enables data to be organised and queried

1.2    Plan and create multiple tables for data entry with appropriate fields and properties

1.3    Set up and modify relationships between database tables

1.4    Explain why and how to maintain data integrity

1.5    Respond appropriately to problems with database tables

1.6    Use database tools and techniques to ensure data integrity is maintained

2    Enter, edit and organise structured information in a database

2.1    Design and create forms to access, enter, edit and organise data in a database

2.2    Select and use appropriate tools and techniques to format data entry forms

2.3    Check data entry meets needs, using IT tools and making corrections as necessary

2.4    Respond appropriately to data entry errors

3    Use database software tools to create, edit and run data queries and produce reports

3.1    Explain how to select, generate and output information from queries according to requirements

3.2    Create and run database queries to display, amend or calculate selected data

3.3    Plan and produce database reports from a multiple-table relational database

3.4    Select and use appropriate tools and techniques to format database reports


Learning outcomes

Assessment criteria

 

3.5  Check reports meet needs, using IT tools and making corrections as necessary


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