L3-U2_PartA

Unit 2: Creating Systems to manage Information

Poll

How many parts are there to the controlled assessment?

• One

• Two

• Three

• Four

Multiple Choice

How many marks can you achieve in Part A?

• 30

• 40

• 56

• 66

Multiple Choice

How many marks can you achieve in Part B?

• 22

• 24

• 26

• 28

Poll

How long do you have to complete Part A

• 3 hrs

• 4 hrs

• 5 hrs

• 6 hrs

Poll

What format should the work be submitted?

• .docx

• .pdf

• .rtf

• .accx

Open Ended

What are you allowed to bring in to the examination environment?

​Normalisation

Poll

How many primary keys fields are in the table for normalisation of the table?

• ArtistID

  GalleryID

  GalleryTypeID

• ExhibitionID

  ArtistID

  GalleryID

  GalleryTypeID

• ExhibitionID

  ArtistID

  GalleryTypeID

• ExhibitionID

  ArtistID

  ArtististNameiD

  GalleryID

  GalleryTypeID

Poll

Create an efficient database structure that minimises data duplication is evidenced by ...

• Normalisation

• Queries

• Tables

• Duplication

Multiple Choice

Note: In this form of normalisation, we ensure that each column in a table contains only atomic values (i.e., no repeating groups or arrays).

So, if we have a table of customers, we would split out the address into separate columns (e.g., street, town, county, postcode). This uses ...

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

Multiple Choice

Note: In this aspect of normalisation, we ensure that each non-key attribute in a table is fully dependent on the primary key

So, if we have a table of orders, we would split out the line items into a separate table with its own primary key, linked back to the order table via a foreign key. This uses ...

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

Multiple Choice

If we have a table of employees, we would split out the department into a separate table, with its own primary key and a foreign key linking it back to the employee table. This is ...

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

Poll

Which of these table names will gain the most marks ...

• tblCustomer

• TBLCustomer

• tbl_Customer

• Customer Table

Poll

The image identifies …

• An E-R Diagram

• One-to-Many Relationships

• Primary Keys

• Foreign Keys

Open Ended

What would be the required Presence Check for a field, so that it is not left blank when creating e.g. Surname field data type?

Multiple Choice

A foreign key is a primary key field in another connected table and uses AutoNumber for the field type

• Yes

• No

Poll

In Activity 2: What two parts does your Design View screenshot need to show

• Primary Key Field & Data Duplication

• Foreign Key & Data Types

• Primary Keys & Validation Text

• Primary Key & Data Types

Poll

Activty 2: The screenshots in the table structures must be put into the template in ...

• Form view

• Table View

• Design View

• Run View

Multiple Choice

Activity 2: the ideal naming convention for a table is ...

• Table

• tbl

• Name_tbl

• tble

Poll

Activity 2: Field names should ALL have ...

• In lowercase

• In uppercase

• Start with a capital letter

• End with a capital letter

Poll

Activity 2: Apart from making sure you have a Primary key you will also need to show ...

• Foreign Keys

• Alien Keys

• Alan Keys

• Robert Keys

Poll

Activity 2: Which of these could be a Presence Check in the table?

• is Not Null

• Between 1 and 3

• >L<??????????

• Integer

• Allow Duplicates

Poll

Activity 2: Which of these could be an example of a Length Check in the table?

• Date

• 255

• 25

• 35

Poll

Activity 2: Which of these could be an example of a Range Check in the table?

• between 16 & 80

• between 16 and 80

• between 1 to 3

• between 1 - 3

Poll

Activity 2: Which of these could be an example of a Value Lookup check in the table?

Multiple Choice

Activity 2: In a Table Lookup you are looking at information linked from a different table in the database

• True

• False

• Not sure

Multiple Choice

Activity 2: In a Table Lookup you can check to see if the table design shows a combo box on the lookup tab

• True

• False

• Not sure

Poll

Activity 2: Which of these is an example of a Format Check?

• Telephone Number Input Mask

• Postcode Input Mask

• Surname Input Mask

• Title Input Mask

• Field2

Poll

Activity 3: Requires you to create two different ...

• Forms

• Reports

• Tables

• Queries

Poll

Activity 3: What is a consistent convention for naming a query?

• Query1

• qry

• QRy

• qry_Maesteg

Poll

Activity 3: Why would you lose marks on this query

• Not in Design View

• Query Criteria is too narrow

• Query Criteria is too Wide

• Not in Datasheet View

Multiple Choice

Activity 3: What will be the result of this query?

• It will find all the customers type with a regular customer type

• It will find all the customers type with a regular type

• It will find all the customers type with a Regular OR New customer type

• It will find all the customers type with a new customer type

Poll

Activity 3: which of these buttosn will run a query

Fill in the Blank

Activity 3: The screenshot shows the result of the query in _________ view