null
US
Sign In
Sign Up for Free
Sign Up
Remove ads
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Info
Ratings
Comments
Mind Map
by
Alex Baine
, created
more than 1 year ago
This is a small mind map showing different queries and a bunch of questions i've encountered in tests
Pinned to
36
0
0
No tags specified
database
computer science
sql
mysql
ict
gcse
Created by
Alex Baine
almost 10 years ago
Rate this resource by clicking on the stars below:
(0)
Ratings (0)
0
0
0
0
0
0 comments
There are no comments, be the first and leave one below:
To join the discussion, please
sign up for a new account
or
log in with your existing account
.
Close
3597322
mind_map
2016-06-11T00:31:37Z
Databases
Test
Databases
SQL
Validation, Verification and Data Integrity
What is meant by the term 'database'
A structured set of storage to hold data
Difference between flat-file and relational
Flat FIle
Relational
Contains multiple tables connecting via foreign keys and primary keys
Contains a single set of data, a table
Advantages
More organised, neater
Less physical storage needed
DBMS
Describe what is meant by a DBMS
A database management system provides an interface for the user
A DBMS allows the separation of applications from the data. Why is this important?
If you want to change the structure it won't affect the data
Tables
Explain the relationship between entities and tables
An entity is a single person, place or thing where data can be stored
Explain the difference between a primary key and a foreign key
A primary key keeps the value unique while a foreign key connects 2 tables
Advantages of electronic database
You can search for a specific item
Takes up less physical room
Describe what is meant by SQL in regards to databases
Structured Query Language is a language used to query your databases. You can
add items, delete items and also search for items.
Queries
Table name: Members | 14343 | Fiona | Gibson | GF6 3KL | 07722 235678
Write an SQL statement to add this record to the database
There has been a mistake in one of the data items in the table.
Change the postcode to 'HF5 3SF'
Extract all information in the FirstName and LastName fields
INSERT INTO 'Members' WHERE('ID','FirstName','LastName','PostCode','PhoneNo') VALUES
(14343, 'Fiona', 'Gibson','GF63KL',07722235678);
UPDATE 'Members' SET PostCode = 'HF5 3SF' WHERE PostCode
= 'GF63KL';
SELECT * FROM 'Members' (FirstName, LastName);
State what is meant by the following terms.
Describe the following methods of data validation
Data Integrity
Validation
Verification
Check if answer is reasonable
Check if data is true
The answer that is expected
Presence check
Range check
Format check
Check if all information has been included
Check if answer exceeds maximum
Check if answer matches the data type
Queries
SELECT * FROM table_name;
Selects all data from 'table_name'
INSERT INTO table_name VALUES (val1, val2);
Inserts values into 'table_name'
UPDATE 'table_name' SET column1 = "value" WHERE column1 != "value";
Update 'table_name' where column1 doesn't equal 'value' and set it to 'value'
DELETE FROM table_name WHERE column1 = "Delete me!";
Delete where column1 is equal to "Delete me!"
Double click this node
to edit the text
Click and drag this button
to create a new node
New
0
of
0
Go to link
Track All
Untrack All
You need to log in to complete this action!
Register for Free