DATABASES IN PRACTICE

Question 1

What do businesses use databses for?

Answer 1

• store huge quantities of data which can be inputted, searched and outputted on screen or printed

Question 2

A local database?

Answer 2

• Stored and accessed on its own network
• This means the data is more protected as data is not moving across the internet
• It is only good for business that is small and willing to pay for networking

Question 3

Online databases?

Answer 3

• Uses the internet to share access to it from locations all around the world
• It can be accessed “on the move” through wireless internet where there is an internet connection

Question 4

What social media is run on databases?

Answer 4

• Facebook, retail sites such as Amazon, and search engines, such as google, are all run on databases

Question 5

What does (DBMS) stand for?

Answer 5

• Database management systems

Question 6

Database management systems?

Answer 6

• A software that allows you to create and use your own databases
• It creates tables, and fields, and can sort and search for data
• It can also allow for different levels of access by different users

Question 7

What does SQL stand for?

Answer 7

• Structured query language

Question 8

Structured query language?

Answer 8

• Language that can be used to create databases
• ** Data definition language** (DDL) defines the structure of the database
• Data manipulation language (DML) can make changes such as add, delete and change - also creates queries