Flashcards
Database Design and Development Revision NAT5
Cards in this deck (25)
- 1THE PURPOSE FOR SEARCHING AND SORTING DATABASE RECORDS IS...TO ARRANGE INFORMATION IN DIFFERENT WAYS
- 2WHAT IS THE MAIN AND VISUAL DIFFERENCE BETWEEN SEARCH AND SORT PERFORMED ON A DATABASE?SORT WILL ALWAYS DISPLAY ALL RECORDS
SEARCH WILL USUALLY REDUCE THEM - 3IN WHAT WAYS SORT OPERATION ARRANGES DISPLAYED RECORDS?ALPHABETICAL
NUMERICAL
CHRONOLOGICAL
IN ASCENDING OR DESCENDING ORDER - 4WHAT RECORDS WILL BE DISPLAYED WITHIN DATABASE AS A RESULT OF SEARCH OPERATION?ONLY RECORDS THAT CONTAIN DATA FIELDS MATCHING THE CRITERIA.
THE CRITERIA SEARCH FOR DATA FIELD WITHIN RECORD MUST BE TRUE. - 5What two tables need to have to be linked?Common column where one of them is a primary key column for one table.
It forms Foreign Key column. - 6What is Foreign Key and its purpose?Primary Key column for one of the two linked tables and one of the column inside another which acts as a connector between them.
- 7ne to many relationship between table is when:Single record in the first table can be repeated within one or many records inside the second table
- 8Flat database file is:Database which stores data in one table only
- 9Major issues of flat database file are:Insertion errors - when data is inserted more often than necessary
Deletion errors - when important data held within record is deleted with entire record
Duplication errors - when data is duplicated within records - 10What is Database?Structured collection of information which contains records made up of fields
- 11What are four types of data validation used:Presence Check
Range Check
Restricted Check
Length Check - 12What is the purpose of the Length Check?To SET CERTAIN LIMIT FOR SIZE OF DATA
- 13What is the purpose of the Range Check?SET THE UPPER AND LOWER LIMITS FOR ACCEPTABLE DATA
- 14What is the purpose of the Restricted Check?TO INCLUDE ONLY CERTAIN OPTIONS TO CHOICE FROM EX. DROP DOWN LIST OF ACCEPTED DATA
- 15What is the purpose of the Presence Check?TO ENSURE DATA EXIST WITHIN FIELD –
NOT ALLOWING TO HAVE A FIELD WITHOUT VALUE - 16What is the Primary Key Column?A column with data fields that is unique for each record and allows to identify one amongst all.
- 17WHAT IS THE PURPOSE OF THIS FORMULA? DataColumn>=DD/MM/YYYY AND DataColumn<=DD/MM/YYYYTo search and display for records starting
with DATE VALUE AND ending on a date with DATE VALUE - 18What is the result of the following statement: DELETE ColumnName FROM TableName;All records within the database table are deleted.
- 19What is the result of following statement: UPDATE TableName SET ColumnName ="New Value" WHERE ColumnName="Old Value";Table is updated with new value of "New Value" for records where "Old Value" is held within ColumnName.
- 20What is the result of the following statement? UPDATE Students SET SubjectName = "Computing Science" WHERE SubjectName = "Computing & IT";SubjectName column values
of "Computing & IT"
has been changed to
"Computing Science" in Students Table - 21Insert new record for Students Table with following values: StudentID=10, FirstName=Joe SecondName=Blogg DOB=31/12/1999 Class=ArtINSERT INTO Students(StudentID, FirstName, SecondName, DOB, Class)
VALUES(10,"Joe", "Blogg", "31/12/1999", "Art"); - 22Write SQL statement to delete record with ID number 101 in Staff TableDELETE FROM Staff
WHERE ID=101; - 23In Animals table show records for Dogs only and sort the results in alphabetical order by their nameSELECT PetType, PetName
FROM Animals
WHERE PetType = "Dog"
ORDER BY PetName ASC; - 24Link two tables Owners and Pets using Foreign Key Column OwnerID and search for owners living in Dundee. Display First Name, Surname, Address, Town, Pet Type and Pet Name. Sort results in alphabetical order by PetNameSELECT FirstName, Surname, Address, Town, PetType, PetName
WHERE Owners.OwnerID=Pets.OwnerID
AND Town ="Dundee"
ORDER BY PetName ASC; - 25List principles of General Data Protection RegulationProcessed lawfully, fairly and in a transparent manner in relation to individuals
Used for the declared purpose only
Limited to the data needed for the declared purpose
Accurate
Not kept for longer than necessary
Held securely
Information
- Description
- A level Computing Flashcards on Database Design and Development Revision NAT5, created by ADRIANNA DAR on 14/12/2020.
- Created by
- ADRIANNA DAR
- Views
- 5
- Rating