Flashcards
About Databases
Flashcards do conjunto (16)
- 1Program used to store dataDatabase program
- 2SQLstructured query language, the language used to search databases
- 3Make one of these if you need to find information from a databaseQuery
- 4Make one of these if you need to present information from a databaseReport
- 5What does this mean when used in a query >greater than
- 6What is the correct name for a row in a databaseRecord
- 7What is the correct name for a column in a databaseField
- 8The correct name for the unique field in a databaseKey field
- 9A step by step guide to help you use a programwizard
- 10Name a massive databaseGovernment data base eg DVLA
Google search database - 11Why cant you just look through the records to find information when using a databaseUsually there are too any records
- 12What shoe sizes would this find... shoe size >5 and <9sizes 6 7 and 8
- 13What months of the year would this find *aryJanuary and February
- 14How many students would this quesry find... housepoints > 100 AND detentions > 10very few...because they would need to have got lots of housepoints and also had more than 10 detentions
- 15What query could be used to find all the best behaved students housepoints..... AND detentions......eg
housepoints >20 AND detentions = 0 - 16Are these different.. between 10 AND 20 >9 AND <21 >=10 AND <=20They are all the same...
Informações
- Descrição
- FlashCards sobre About Databases, criado por mdavies5797 em 23-10-2013.
- Criado por
- mdavies5797
- Visualizações
- 23
- Avaliação