Font size
WorksheetsDatabases
Total questions: 81
Worksheet time: 4hrs 35mins
Describe What A Flat File Is
What Is The Entity And Attributes Of The Words Below
Teacher Name Subject House Group Room Number
Describe What An Entity And Attribute Are
What Are Relational Databases Made Up Of
Is Flat File The Preferred Database Format?
Name Disadvantages About Using Flat File Databases
Name And Describe Each Data Type
What Data Type Would A Telephone Number Be Stored As
What Is A Primary Key (PK)
What Is A Foreign Key
What Is The Cardinality
What's The One Relationship At N5
Check In Jotter
What Do Entities Get Written In ER Diagram
(a)
What Are Attributes Written In ER Diagrams
(a)
What Symbol Represents The Many Side
(a)
What Is Done To PK And FK
(a)
What Is A Data Dictionary
(a)
What Do Data Dictionaries Contain
(a)
Each Entity In A Data Dictionary Gets Its Own
House
Attribute Name
Meta Data
Table
What Is
Attribute Name
(a)
Remember Columns
What Is
Size
(a)
Type Of Key
(a)
What Is
Sample Data
(a)
What Is
Validation
(a)
What Is
Type
(a)
What Are The 4 Types Of Validation
Revisit How To Add Relationships And Validations To A Database
Describe The Analysis Stage
What Are The Databases Functions Known As
(a)
What Are The Two Requirement Categories
Describe End User Requirements
Describe What Functional Requirements Are
Answer
Describe What A Query Is
Write What Ascending And Descending Are
What Are The 4 Parts Of A Table Template
Describe What Field(s) Are In The Table Template
Describe What Table(s) Are In Table Template
Describe What Search Criteria Is In Table Template
Describe What Sort Order Is In Table Template
Answer
Answer
Answer
What Does SQL Stand For
What Is It Used For
What Are The 4 SQL Queries
What Are The 4 SELECT Statements
What Is The Minimum Information A Query Can Run On
How Do You SELECT All Fields In A Table
Answer
On Access How Do You Create A Query
Describe The 3 Steps For The Update Query
Answer
For Updating A Single Record What Should You Use For The WHERE Statement
Answer
Describe The Insert Query
Answer
Answer
How Do You Complete A Partial Insert Query
Explain The DELETE Query
What Do You Use To Delete One Récord
What Would Happen If You Ran
DELETE FROM Table
Answer
What Is Dot Notation
What Is Dot Notation
Provide The Formula For Dot Notation
What Is Equi Join
What Happens If You Don’t Link The Tables With Foreign Key
What Does A Equi Join SELECT Query Look Like
Answer
What Is Good Practice For Dot Notation And Equi Join
During The Testing Phase What Could Be Included In The Test Table
In What Form
Support What Other Phase
What Are The Two Ways A Database Can Be Evaluated By
What Phase Is Normally Completed Along Side The Testing Phase
How Can A Database Be Fit For Purpose
When Asked If This Database Is Fit For Purpose What Is Format Of Answer
What Is The GDPR
Rules For How Data Must Be Held As Part Of GDPR Legislation
Name The Rights Of An Individual As Part Of The GDPR Legislation
What Are The Exceptions To The Right Of Access
Answer
