Module 1 - Introduction to Databases

Question 1

Simply describe the word DATA…

Answer 1

Numeric, textual, visual, or audio information that describes real world systems

Question 2

DATA can vary in several important ways, describe 3 of these ways…

Answer 2

1. Scope - the amount of data produced and collected can vary depending on the business
2. Format - data may be produced as numbers, text, video, or audio
3. Access - some data sources are private where others are publicly available

Question 3

A collection of data stored in a structured format is known as a?

Answer 3

Database

Question 4

A software that reads or writes data in a database is known as a?

Answer 4

Database management system or DBMS

Question 5

What is a query?

Answer 5

A request to retrieve or change data in a database.

Question 6

Who is responsible for ensuring security in the database against unauthorized users?

Answer 6

Database administrator

Question 7

Who determines the format of each data element and the overall database structure?

Answer 7

Database designer

Question 8

Who develops programs that utilize a database?

Answer 8

Database programmer

Question 9

What is a group of queries that must be either completed or rejected as a whole?

Answer 9

A transaction - execution of some but not all may result in incorrect or inconsistent data

Question 10

Most leading databases are relational, what does this mean?

Answer 10

This is a database that stores data in tables columns and rows, similar to a spreadsheet.

Question 11

SQL or structured query language, includes programming statements that do what?

Answer 11

1. Read and write data
2. Create and delete tables
3. Administer the database system

Question 12

What are the four common queries known as the CRUD operations…

Answer 12

1. CREATE
2. READ
3. UPDATE
4. DELETE

Question 13

What are other most common SQL commands?

Answer 13

1. INSERT
2. SELECT

Question 14

Write a basic insert statement into a table called “account”, with values of (290, ‘Ethan Carr’, 5000) …

Answer 14

INSERT INTO Account
VALUES (290, ‘Ethan Carr’, 5000);

Question 15

Write a basic select statement that selects the names from the account table where their balance is over 3000…

Answer 15

SELECT Name
FROM Account
WHERE Balance > 3000;

Question 16

Write a basic update statement that changes Raul’s balance from 3300 to 4500 …

Answer 16

UPDATE Account
SET Balance = 4500
WHERE ID = 831;

Question 17

Write a basic delete statement that deletes Raul from the database

Answer 17

DELETE FROM Account
WHERE ID = 831;

Question 18

Simply explain the create table statement with an example…

Answer 18

The create table statement creates a new table by specifying the table and column names. Each column is given a data type that indicates the format of the column values

Example:
CREATE TABLE Employee (
ID INT,
Name VARCHAR (60),
BirthDate DATE,
Salary Decimal(7,2)
);

Question 19

Database design typically has 3 phases of planning, name 3 in order …

Answer 19

1. Conceptual design
2. Logical design
3. Physical design

Question 19

Which design phase specifies database requirements without regard to a specific database system?

Answer 19

Conceptual design - requirements are represented as attributes, entities, and relationships

Question 20

Explain logical design

Answer 20

Logical design implements database requirements into a specific database system, in relational databases this is converting into tables, keys, and columns