Alex Baine
Mind Map by , 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

36
0
0
Alex Baine
Created by Alex Baine almost 10 years ago
Rate this resource by clicking on the stars below:
1 2 3 4 5 (0)
Ratings (0)
0
0
0
0
0

0 comments

There are no comments, be the first and leave one below:

Close
DatabasesTestDatabasesSQLValidation, Verification and Data IntegrityWhat is meant by the term 'database'A structured set of storage to hold dataDifference between flat-file and relationalFlat FIleRelationalContains multiple tables connecting via foreign keys and primary keysContains a single set of data, a tableAdvantagesMore organised, neaterLess physical storage neededDBMSDescribe what is meant by a DBMSA database management system provides an interface for the userA 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 dataTablesExplain the relationship between entities and tablesAn entity is a single person, place or thing where data can be storedExplain the difference between a primary key and a foreign keyA primary key keeps the value unique while a foreign key connects 2 tablesAdvantages of electronic databaseYou can search for a specific itemTakes up less physical roomDescribe what is meant by SQL in regards to databasesStructured Query Language is a language used to query your databases. You canadd items, delete items and also search for items.QueriesTable name: Members | 14343 | Fiona | Gibson | GF6 3KL | 07722 235678Write an SQL statement to add this record to the databaseThere 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 fieldsINSERT 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 validationData IntegrityValidationVerificationCheck if answer is reasonableCheck if data is trueThe answer that is expectedPresence checkRange checkFormat checkCheck if all information has been includedCheck if answer exceeds maximumCheck if answer matches the data typeQueriesSELECT * 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 nodeto edit the textClick and drag this buttonto create a new node