SD2-UNIT 15

​Structured Query Language (SQL)

By Carmen Retief-Alharbi

A programming language used for managing and manipulating relational databases, allowing operations like querying, updating, and deleting data.

​Order by SQL

By Carmen Retief-Alharbi

An SQL clause included to sort query results by one or more columns, either in ascending or descending order.

​SQL Boolean Operaters

By Carmen Retief-Alharbi

Operaters used in SQL queries to combine or modify conditions in the query, such as AND, OR, NOT.

​SQL Query

By Carmen Retief-Alharbi

A request written in SQL to perform a speefic task in the database, such as retrieving or manipulating data.

Database

By Carmen Retief-Alharbi

An organized collection of data that can easily be accessed, managed, and updated. It is typically used in software applications to store data.

Database Structure

By Carmen Retief-Alharbi

The organization of a database, including its tables, relationships, and data types, which defined how data is stored and accessed.

Database Management System

By Carmen Retief-Alharbi

​Software used to create, manage, and maintain databases, providing functions like querying, data, retrieval, security, and database administration.

​Relational Database Management System (RDBMS)

By Carmen Retief-Alharbi

A type of DBMS that stores data in relational tables and uses structured query language for managing and querying the database.

Database Testing

By Carmen Retief-Alharbi

The process of verifying that a database functions as intended, ensuring that it meets the specified requirements and can handle various use cases.

Data Manipulation

By Carmen Retief-Alharbi

​The process of inserting, updating, deleting, or retrieving data from a database using SQL's or other database tools.

Database Table

By Carmen Retief-Alharbi

The organization of a database, including its tables, relationships, and data types which defines how the data is stored and accessed.

Database Model

By Carmen Retief-Alharbi

A conceptual framework used to define the structure of a database, including the relationships and the data types.

Data Definition

By Carmen Retief-Alharbi

The process of defining the structure and types of data to be stored in a database such as creating tables, fields, and constraints.

Database Security

By Carmen Retief-Alharbi

The practices and technologies used used to protect a database from unauthorized access, modification, or corruption, ensuring data integrity and confidentiality.

Database Administration

By Carmen Retief-Alharbi

​The tasks involved in maintaining and managing a database , including performance tuning, backup, recovery, and user permissions.

Database Querying

By Carmen Retief-Alharbi

The process of retrieving specific data from a database by using SQL queries or other database tools.

Database Update

By Carmen Retief-Alharbi

​The process of modifying or adding new data in an existing database, typically using SQL queries like INSERT, UPDATE, DELETE.

Database Documentation

By Carmen Retief-Alharbi

Written information about the design, structure, and functionality of the database, including requirements, tables, and relationships.

Data Dictionary

By Carmen Retief-Alharbi

A repository of metadata that describes the structure of the database, including tables, fields, and relationships between them.

Debugging a Database

By Carmen Retief-Alharbi

The process of identifying and fixing errors or issues in a database, such as incorrect data representation or query failures.

Requirements Analysis for a Database

By Carmen Retief-Alharbi

The process of determining the information a database needs to store and how it functions to meet specific business or project needs.

Entity

By Carmen Retief-Alharbi

An object or concept in a database that is represented by a table, such as a person, product or event.

Attribute

By Carmen Retief-Alharbi

A property or characteristic of an entity in a databse, typically represented by a column in a table.

Relationships

By Carmen Retief-Alharbi

The connections between different entities or tables in a database, such as one to many, many to many, or one to one relationships.

Flat-File Structure

By Carmen Retief-Alharbi

A simple database structure where all data is stored in a single table files without relationships between tables.

Hierarchical Structure

By Carmen Retief-Alharbi

A database structure that organizes data in a tree-like format where each record has a single parent and potentially many child records.

Relational Structure

By Carmen Retief-Alharbi

A database structure where data is stored in tables and relationships are defined between them using keys.

Network Structure

By Carmen Retief-Alharbi

​A database structure that uses a graph or network format to represent entities and their relationships where each entity has multiple parents.

Object-oriented Structure

By Carmen Retief-Alharbi

A database structure where data is represented as objects, similar to object-oriented programming concepts, enabling more complex data models.

Unified Modeling Language

By Carmen Retief-Alharbi

A standardized modeling language used to specify, visualize, and document the design of database systems, often used in data modeling.

Multiple Choice

What is a database?

• a type of programming language

• a hardware device

• an organized collection of data

• a data encryption tool

Multiple Choice

What is the purpose of requirements analysis for a database?

• to secure the database

• to determine the storage space

• to identify should what data is needed and how it should function

• to convert files into a flat-file structure

Multiple Choice

What is database documentation used for?

• speeding up data retrieval

• describing the design and functionality of a database

• encrypting database files

• creating user interfaces

Multiple Choice

In a database, what is an entity?

• A column in a table

• A type of SQL query

• an object or concept represented by a table

• a type of relationship

Multiple Choice

What does a data dictionary contain?

• user passwords

• sample data entries

• metadata describing the database structure

• programming code

Multiple Choice

What do relationships in a database define?

• data formats

• column types

• links between entities or tables

• server connections

Multiple Choice

Which structure stores all data in a single file or table?

• Hierarchical structure

• Flat-File structure

• Network structure

• Relational structure

Multiple Choice

What is unique about a Hierarchial structure of a database?

• no relationships

• data stored randomly

• data organized in a tree format

• each record has multiple parents

Multiple Choice

In a Relational structure, data is stored in:

• flat files

• trees

• tables with relationships

• objects

Multiple Choice

What is UML used for in database design?

• encrypting data

• modeling and visualizing database structure

• backing up databases

• writing SQL queries