databases T7

Question 1

uses of databases

Answer 1

used in business situations and back-end of many cloud services

Question 2

examples of uses of databases

Answer 2

management information systems
customer and retail
websites
games
social media

Question 3

define database

Answer 3

a structured way to store data so that it can be retrieved using queries

Question 4

define a field

Answer 4

a single item of data in a column within a database

Question 5

define a record

Answer 5

a collection of fields, a basic data structure

Question 6

varchar

Answer 6

a variable length string

Question 6

varchar

Answer 6

a variable length string

Question 7

flat file database

Answer 7

a database with one table

Question 8

primary key

Answer 8

a field that is unique for every record

Question 9

relational database

Answer 9

database with multiple tables which are linked through their key fields

Question 10

foreign key

Answer 10

a field in one table that is a primary key in another

Question 11

why use relational databases

Answer 11

flat file databases can have a lot of redundant data so relational databases reduce inconsistencies and redundant data

Question 12

redundant data

Answer 12

repetitions of the same data

Question 13

inconsistent data

Answer 13

writing data in different formats

Question 14

sql

Answer 14

structured query language

Question 15

define query

Answer 15

a question asked about a database

Question 16

SELECT (field) query

Answer 16

this retrieves data from the database (used for searching)

Question 17

FROM (table)

Answer 17

stating which table you are retrieving data from

Question 18

WHERE (condition)

Answer 18

stating what condition you want the data to meet/how it is filtered

Question 19

ORDER BY (field) ASC/DESC

Answer 19

stating how you want the field ordered

Question 20

how to join data from two related tables

Answer 20

you need to match the foreign key to the primary key using WHERE

Question 21

INSERT INTO (table(fields)
VALUE (values)

Answer 21

adds a record to the table