Unit 18 Database Design

For M1, learners should show evidence that they understand the concept of referential integrity and the mechanisms that exist to support the enforcement of referential integrity within a database package. They should also be able to explain the purpose of primary keys and how they are used to build the relationships between tables. Reference should also be made to foreign keys.

4.2

(5)

3 pages

Written in 2015/2016

Grade Merit

topqualityworka

For P3, learners will have implemented their design and populated the tables. Relationships should have been established and referential integrity enforced, this will allow cascaded updating and deletion of linked records. Evidence will come from annotated screen prints.

2.5

(4)

15 pages

Written in 2015/2016

Grade Pass

topqualityworka

P7 requires full testing of the database, including functionality and user testing. Learners should have a test plan and evidence will come from this and user feedback.

4.0

(2)

16 pages

Written in 2015/2016

Grade Pass

topqualityworka

For P6, learners should have included at least one of the advanced features from the unit content in their database design.

4.5

(2)

8 pages

Written in 2015/2016

Grade Pass

topqualityworka

For P1, they must explain the features of a relational database. Evidence for this could be, for example, a written report, a presentation or a written discussion. Note that the features include benefits and learners need to be able to quote aspects that relate to the efficiency of storage of information with a minimum of data redundancy and also the ease by which information can be extracted from the database as required.

4.3

(3)

7 pages

Written in 2015/2016

Grade Pass

topqualityworka

For P2, learners must design a relational database containing at least five tables for a specified user need. Learners must provide evidence of appropriate normalisation and database design. Documentation such as ERDs, data dictionaries, DFDs, structured English etc will provide the evidence.

4.0

(2)

1 pages

Written in 2015/2016

Grade Pass

topqualityworka

For P5, queries should be created using a minimum of two tables and a minimum of two criteria and be thoroughly tested.

4.5

(2)

8 pages

Written in 2015/2016

Grade Pass

topqualityworka