BTEC National ICT U2 - Database Theory Lesson 1-3

What is Open Source Software?

• Software that is owned by a commercial organisation which develops and sells a licence to the software.

• It is a special purpose programming language used for managing data in relation to databases

• Software that has its source code available for the general public to use and modify free of charge.

• It is used in database development as the definition for the type of data that is to be stored

What is Proprietary Software?

• Software that is owned by a commercial organisation which develops and sells a licence to the software.

• It is a special purpose programming language used for managing data in relation to databases

• Software that has its source code available for the general public to use and modify free of charge.

• It is used in database development as the definition for the type of data that is to be stored

What is meant by the term datatype?

• Software that is owned by a commercial organisation which develops and sells a licence to the software.

• It is a special purpose programming language used for managing data in relation to databases

• Software that has its source code available for the general public to use and modify free of charge.

• It is used in database development as the definition for the type of data that is to be stored in a field. The most common types are text and number.

What does SQL stand for

• Standard Qualitative Layout

• Secure Question Library

• Structured Query Language

• Specific Queue Latency

SQL can only be used on Microsoft Access

• True

• False

Which of the following are relational algebra operations that can be applied to tables? (Choose all that apply)

• Intersect

• Merge

• Union

• Select

What SQL operation does this symbol represent?

• Select

• Join

• Intersect

• Union

What SQL operation does this symbol represent?

• Select

• Join

• Intersect

• Union

What SQL operation does this symbol represent?

• Select

• Join

• Intersect

• Union

What SQL operation does this symbol represent?

• Select

• Join

• Intersect

• Union