Unit 3 Design

AS Applied ICT

Unit 3

Use of Software The software I will be using in relationship to the end users requirements is Microsoft Office Access. I will use this software because the end user would like their information in different tables in an organised list. The software can also be used to create queries and reports for ease of use and simplicity. I will create these myself instead of the end user so it will be easier for them to use. Input Requirements Input of the cadet information • Cadet ID • Cadet Forename • Cadet Surname • Cadet Rank • Cadets Flight • Staff ID Input of the staff information • Staff ID • Staff Surname • Staff Rank • Staffs Flight Input of the project information • Project ID • Project Group • Requirements • Staff ID Input of the cadet/project information • Cadet ID • Project ID • Achieved Y/N

Centre Number: 62441 The Henley College Date:

Page 1 of 4

Leanne Brown Candidate Number: 9804

AS Applied ICT

Unit 3

This is a print screen of the entity relationship diagram in the database. This is the self drawn draft table of the entity relationship diagram. Cadet Table Cadet ID Cadet Forename Cadet Surname Cadet Rank Cadets Flight Staff ID

Cadet/Project Table Cadet ID Project ID Achieved Y/N

Staff ID Staff Surname Staff Rank Staffs Flight

Centre Number: 62441 The Henley College Date:

Project Table Project ID Project Group Requirements Staff ID

Page 2 of 4

Leanne Brown Candidate Number: 9804

AS Applied ICT

Unit 3

Data Dictionary for Cadet Table Attribute Name Cadet ID

Data Type Number

Formatting/ Size Long Integer

Reason For Choice

Keys/ Indexing

I wanted the Cadet ID to be a number There is no one in cadets with a forename longer than twenty characters so I made it twenty characters There is no one with a surname longer than twenty characters so I made it twenty characters In short hand there is nothing longer than seven characters so I made the field size seven characters

Primary Key

Cadet Forename

Text

Field Size 20

Cadet Surname

Text

Field Size 20

Rank

Text

Field Size7

Cadets Flight

Text

Field Size 6

There are only two flights and the longest name is six letters so I made the field size six characters

Use a Look Up Table to find the rank as there are only two selections, is easier to type in the flight

Staff ID

Number

Long Integer

I wanted the Staff ID to be a number

Use a Look Up Table to find the rank needed, as there are only four ranks needed it is easier to type in rank names

Data Dictionary for Staff Table Attribute Name Staff ID

Data Type Number

Formatting/ Size Long Integer

Staff Surname

Text

Field Size 11

Staff Rank

Text

Field Size 7

Staffs Flight

Text

Field Size 6

Reason For Choice

Keys/ Indexing

I wanted Staff ID to be a number There is no one with a surname longer than twenty characters so I made it twenty characters There is no rank longer than 7seven characters so I made it seven characters

Primary Key

There is no flight longer than six letters so I made the field size six

Use a Look Up Table to find the rank as there are only eight selections, it is easier to type in the rank name Use a Look Up Table to find the flight name as there are only two selections it is easier to type in the flight name

Data Dictionary for Project Table Centre Number: 62441 The Henley College Date:

Page 3 of 4

Leanne Brown Candidate Number: 9804

AS Applied ICT

Unit 3

Attribute Name Project ID

Data Type Number

Formatting/ Size Long Integer

Project Group

Text

Field Size 20

Requirements

Text

Field Size 100

Staff ID

Number

Long Integer

Reason For Choice

Keys/ Indexing

I wanted the Project ID to be a number There is no project group larger than twenty characters so I made the field size twenty The requirements had to be an explanation of what the group was doing so it needed to be long to fit the explanation in I wanted the Staff ID to be a number

Primary Key

Data Dictionary for Cadet/ Project Table Attribute Name Cadet ID

Data Type Number

Formatting/ Size Long Integer

Project ID

Number

Long Integer

Achieved Y/N Text

Field Size 1

Centre Number: 62441 The Henley College Date:

Reason For Choice

Keys/ Indexing

I wanted the Cadet ID to be a number I wanted the Staff ID to be a number I wanted the table where you look up either a yes or a no so I made it a Look Up Table.

Primary Key

Page 4 of 4

Primary Key Use a Look Up Table to find either a Y or an N. As there are only two selections it can be easier to type in the selection

Leanne Brown Candidate Number: 9804