Unit 18 - Database Design

BTEC IT Level 3 - Unit 18 - Database Design

4.0

(1)

7 pages

Written in 2017/2018

Grade D

akj

BTEC IT Level 3 - Unit 18 - Database Design

4.0

(1)

22 pages

Written in 2017/2018

Grade D

akj

BTEC IT Level 3 - Unit 18 - Database Design

4.0

(1)

13 pages

Written in 2017/2018

Grade D

akj

BTEC IT Level 3 - Unit 18 - Database Design

4.0

(1)

25 pages

Written in 2017/2018

Grade D

akj

Unit 18 Database Design. Designing a relational database. All criteria achieved, P2, P4.

4.0

(1)

5 pages

Written in 2016/2017

leoJBlack

Unit 18 Database Design. Introduction to relational Databases. All criteria achieved, P1, M1 and D1.

-

7 pages

Written in 2016/2017

leoJBlack

Full written Unit 18 Database Design Assignment 3 Report (all criteria achieved)

-

39 pages

Written in 2017/2018

drj44

Full written Unit 18 Database Design Assignment 2 Report (all criteria achieved)

-

8 pages

Written in 2017/2018

drj44

Full written Unit 18 Database Design Assignment 1 Report (all criteria achieved)

-

9 pages

Written in 2017/2018

drj44

P1,P2,P3,P4,P5,P6,M1,M2,M3,D1,D2 Includes over 6,000 words in assignment.

3.9

(8)

55 pages

Written in 2015/2016

xeon

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.

3.8

(4)

7 pages

Written in 2015/2016

Grade Pass

topqualityworka

D2 requires learners to evaluate their databases’ success in meeting user need. Learners should not only discuss strengths and weaknesses, but justify the features and functions they have used and make suggestions for improvements.

3.3

(3)

7 pages

Written in 2015/2016

Grade Distinction

topqualityworka

D1 is an opportunity for users to identify and explain a range of common errors in database design and construction, explaining how these types of errors can be avoided. As an example, learners could discuss the impact of errors such as the accidental deletion of a field in a query or report, the renaming of a field, changing data types etc.

4.0

(5)

10 pages

Written in 2015/2016

Grade Distinction

topqualityworka

For M4, learners are required to implement one of the automated functions suggested in the unit content.

4.3

(3)

32 pages

Written in 2015/2016

Grade Merit

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.

2.5

(2)

5 pages

Written in 2015/2016

Grade Pass

topqualityworka

M3 requires learners to export the results of either a query or report to another application. To evidence this, learners could provide a screen print of a directory containing the exported data in a suitable file format or a print of the data in its new format. Alternatively, for M2 and M3, an appropriately documented demonstration of learners exporting and importing data would be appropriate. The tutor could ask for a particular set of data to be exported to a particular application.

4.5

(2)

5 pages

Written in 2015/2016

Grade Merit

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

(1)

2 pages

Written in 2015/2016

Grade Pass

topqualityworka

M2 requires learners to import data from an external source (this could be from a text file, spreadsheet, word-processed table or another database package). The data could, for example, be used to form one of the tables required in the database.

4.0

(1)

15 pages

Written in 2015/2016

Grade Merit

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.

3.7

(6)

3 pages

Written in 2015/2016

Grade Pass

topqualityworka

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