Unit 18 Database Design

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)

7 pages

Written in 2017/2018

Grade D

akj

Achieved a D*D*D* grade overall, this bundle includes 17 units of my course (out of 18), it is by Pearson. Units included are: Unit 1, 2, 3, 5, 12, 14, 18, 19, 20, 22, 25, 26, 28, 30, 31, 32. This includes most assignments of these, but not all of them. (over 90% guaranteed).

3.0

(1)

76 items

aesthetic

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 Assignments, All Assignments (three in total), All Criteria Attempted and Achieved

-

3 items

drj44

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

Units from BTEC ICT LEVEL 3 (2010 QCF): 103,105,28,25,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2, and 1 Using word count from Microsoft word: over 133,000 words written for these units combined.

5.0

(2)

23 items

xeon

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