WEEK 7

Question 1

What is a structured collection of organized data that is managed in a way that allows efficient retrieval , modification and analysis information

Answer 1

Database

Question 2

A data base is like a what

Answer 2

Paper filler cabinet
(Can choose what and where info is stored)

Question 3

How do you get data records on database

Answer 3

Input them yourself
Import them from somewhere else

(It’s like Placing documents in filling cabinet)

Question 4

What is a question on request for info from a database and is the way to retrieve data in the database

Answer 4

Query
(Can ask it any question)

(Example.
Who has the most money according to the files in the cabinet?)

Question 5

What is a summary of queried data that is designed to provide a clear, concise, and structured view of data

Answer 5

Report
(Presentation of your data)

Question 6

Flat File vs Database
What’s the difference

Answer 6

Flat File is when a small group of people manage data in text files and spread sheets

Database is when you are dealing with complex data and lots of it which require advance data relationships and query capabilities

Question 7

Database benefits

Answer 7

Multiple Concurrent Users

Scalability
(Increase data and traffic)

Increased speed
(Indexing, caching, query optimization etc..)

Can handle a variety of data

Question 8

What is a collection of related data fields that represent a single unit of info
It’s often used to store and retrieve specific info
(COLLECTION OF DATA FIELDS)

Answer 8

Database Records

Question 9

Long term retention of data within a database even when system is not being used or is off

Answer 9

Data Persistence

Question 10

Name the 3 Database Structure Types

Answer 10

Structured (well organized)

Unstructured (includes text, vids, audio)

Semi-Structured (use meta tags to organize)

Question 11

Structured data pros and cons

Answer 11

Fast data retrieval

Low data flexibility

Question 12

Unstructured data pros and cons

Answer 12

Low data retrieval

High data flexibility

Question 13

Semi-structured data pros and cons

Answer 13

Medium data retrieval

Medium data flexibility

Question 14

What is a structured data system that stored structured data in tables
(Links multiple tables together)
(Organizes tables that relate to eachother)

Answer 14

Relational Database

Question 15

How does Relational Database connect other tables together and create table relationships

Answer 15

Keys
(Primary key and Foreign key link together)

Question 16

What is an outline or a blueprint for a database that describes its component and how they work

Answer 16

Schema

(Table name
Fields in table
Data type required for table
Primary key, Foreign key, and other attributes)

Question 17

What is a constraint in a database

Answer 17

Rules and conditions we set for the data in the database

Question 18

What are Non-Relational Databases

Answer 18

Uses storage model to optimize for the specific requirements for data being stored
(NON sql database)
(does NOT use Tables)

Question 19

Explain Key/Value database

Answer 19

Its a Non-Relational Databases that uses keys and assigns values to that key
(used for caching
session management
user profile)

Question 20

What is a Document Database

Answer 20

Its a Non-Relational Database
Works just like the file system on your computer

(stores stuff that cant be fit into a table or row sheet)

(stores files
music
photos
video)

Question 21

What is SQL

Answer 21

is a specialized computer language used to communicate and manipulate databases

(sends request for actions it wants to be preformed)

Question 22

In SQL what are DDL Commands

Answer 22

Commands that manage the STRUCTURE of your database

Question 23

In SQL what are DML Commands

Answer 23

Commands that manage the DATA of your database

Question 24

What does the CREATE command do in SQL

Answer 24

can create the tables and the names of the tables ect…

Question 25

What does the ALTER command do in SQL Example

Answer 25

It allows you to add delete and modify a column You can also change a columns data type Example ALTER TABLE employees REMANE COLUMN emp_id to emp_number;

Question 26

In SQL what does the DROP command do

Answer 26

It is used to delete database data like tables Example DROP TABLE employees;

Question 27

What are some commands that DDL uses

Answer 27

CREATE ALTER DROP

Question 28

What are some commands that DML uses

Answer 28

INSERT UPDATE DELETE

Question 29

In SQL what does the INSERT command do

Answer 29

Used to add new records in a table Example INSERT INTO employees VALUES (4233, 'John Smith', 65000.00);

Question 30

In SQL what does the UPDATE command do

Answer 30

Allows to modify existing records in a table Example UPDATE employees SET emp_salary = 67000.00 WHERE emp_id = 4233;

Question 31

In SQL what does the DELETE command do

Answer 31

Used to delete records in a table Example DELETE FROM employees WHERE emp_id = 4693;

Question 32

In SQL What does the SELECT command do

Answer 32

It is used to query/retreat specific data from a database table Example SELECT column1, column2 FROM table_name WHERE condition; Example 2 SELECT * FROM Student Table WHERE Age >=20;

Question 33

What are Database Permissions

Answer 33

Can grant certain users the ability to preform specific actions like reading and editing data

Question 34

What commands are used for Database Permissions

Answer 34

GRANT COMMAND gives permissions (GRANT SELECT ON Customers TO UserA; ) DENY COMMAND denies permissions (DENY DELETE ON Customers TO UserA; )

Question 35

When wanting to get data into a database its what

Answer 35

Import

Question 36

When wanting to get data out of a database its

Answer 36

Export

Question 37

What are some ways to import data into a database

Answer 37

Using CSV files (uses commas to separate files) (included headers)

Question 38

What is Database Access Methods

Answer 38

Are the processes by which a user might run SQL commands in order to update or extract info from a database

Question 39

Name some Database Access Methods

Answer 39

Direct/Manual Access Query/Report Builders Programmatic Access User Interface/Utility Access

Question 40

What is Direct/Manual Access

Answer 40

Logging into the database directly and running the SQL code within the database management system

Question 41

What is Query/Report Builders

Answer 41

The user uses a Graphical User Interface where actions are selected and then converted into SQL commands

Question 42

What is Programmatic Access

Answer 42

Use programing language to connect with the database and execute Querys

Question 43

What is User Interface/Utility Access

Answer 43

User Friendly Interface (without the user being aware of its presence ) Data Driven Dashboard