Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

D276 Web dev foundations > D426 > Flashcards

D426 Flashcards

(101 cards)

Start Studying
1
Q

Database Application

A

Software that helps business users interact with database systems.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Database Administrator

A

Secures the database and gives users access.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Query Processor

A

Interprets queries, creates a plan to modify the database or retrieve data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Storage Manager

A

Translates the query processor instructions into system commands that modify or retrieve data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Transaction Manager

A

Ensures transactions are properly executed. Prevents conflicts between transaction. Restores the database after a system failure.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Analysis Phase

A

Specifies database requirement. Creating entities, relationships and attributes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Relationship

A

A link between entities.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Entity

A

Person, place, activity or thing.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Attribute

A

Describes an entity.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Logical design

A

Implements database requirements. Converts entities, relationships and attributes into tables, keys and columns.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Physical design

A

Adds indexes and specifies how tables are organized.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

API

A

Application programming interface. Used to simplify the use of SQL with a general-purpose language.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

MySQL Command-Line Client

A

A text interface used to return errors when SQL code is syntactically incorrect.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Tuple

A

A collection of elements enclosed in parentheses.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Table

A

Has a name, fixed tuple of columns and a varying set of rows.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Column

A

Has a name and a data type

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Row

A

An unnamed tuple of values. Each value corresponds to a column and belongs to that columns data type.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Synonym for: Table

A

File, Relation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Synonym for: Row

A

Record, Tuple

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Synonym for: Column

A

Field, Attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Business rule

A

Rules based on business policy and specific to a particular database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Literals

A

Explicit values surrounded by quotation marks.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Keywords

A

Words with special meaning. ex SELECT, FROM, WHERE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Identifiers

A

Objects from the database like tables and columns.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Data Definition Language(DDL)
Defines the database schema. (CREATE, DROP, ALTER, TRUNCATE)
25
Data Manipulation Language(DML)
Commands that manipulate the data ( INSERT, UPDATE, DELETE, LOCK)
26
Data Query Language
Retrieves Data from the database (SELECT)
27
Data Control Language
Controls database user access.
28
Data Transaction Language
Manages database transactions
29
Table
Fixed sequence of columns and a set of rows
30
Column
Has a name and a data type
31
Row
An unnamed sequence of values
32
Cell
A single column of a single row
33
Data independence
Also called rule 7: Allows database admins to improve query performance or organizing the data without affecting query results.
34
DROP TABLE
Deletes all the tables rows from the database
35
Data type
A named set of values from which a column is drawn
36
TINYINT
1 byte -128 to 127
37
SMALLINT
2 bytes +- 32768
38
MEDIUMINT
3 bytes +-8388608
39
INT
4 bytes +-2147483647
40
BIGINT
8 bytes
41
UPDATE
Uses the SET statement to specify the new column values. WHERE is optional
42
DELETE
The FROM keyword is followed by the table name whose rows are deleted.
43
TRUNCATE
Deletes all rows from a table
44
MERGE
state selects data from one table and inserts the data to another table called the target
45
Primary Key
a column used to identify a row. Usually the tables first column
46
Simple primary key
Consists of a single column.
47
Composite primary key
consists of multiple columns
48
Foreign key
A column that refer to the primary key
49
Constraint
A rule that governs allowable values in a database.
50
BETWEEN
Provides an alternative way to determine if a value is between two other values.
51
LIKE
when used in a WHERE clause matches text against a pattern using the two wildcard characters % and .
52
ORDER BY
Orders rows in ascending order
53
TRIM
Removes white space.
54
Aggregate function
COUNT, MIN, MAX, SUM, AVG
55
HAVING
Used with the GROUP BY clause to filter group results.
56
JOIN
A SELECT statement that combines data from two tables.
57
ALIAS
follows the column name separates by an optional AS keyword.
58
INNER JOIN
Only matching left and right table rows
59
FULL JOIN
Selects all left and right table rows
60
LEFT JOIN
Selects all left table rows
61
RIGHT JOIN
Selects all right table rows.
62
OUTER JOIN
Only unmatched rows
63
UNION
Combines two results into one table
64
EQUIJOIN
Compares tables with the = operator
65
SELF JOIN
Joins a table to itself
66
Cross-join
Combines two tables without comparing columns. No ON clause
67
Subquery
A query within another query also called a nested or inner query
68
Materialized view
A view for which data is stored at all times.
69
WITH CHECK
The database rejects inserts and updates that do not satisfy the view query.
70
ER model
A high level representation of data requirements
71
Entity
A person, place, product, concept or activity
72
Relationship
A statement about two entities.
73
Attribute
A descriptive property of an entity
74
Entity type
A set of things. ex: All employees in a company
75
Relationship type
A set of related things Ex Employee-manages-department is a set
76
Attribute type
A set of values Ex All employee salaries.
77
Entity instance
An individual thing Ex The employee Sam Snead
78
Relationship Instance
A statement about entity instances Ex Maria Rodriguez manages Sales
79
Attribute instance
An individual value Ex The salary $35,000.
80
Analysis
Develops an ER model, capturing data requirements while ignoring implementation details.
81
Logical design
Converts the ER model into tables columns and keys
82
Physical design
Adds indexes and specifies how tables are organized on storage media.
83
IsA relationship
An identifying relationship
84
Partitions
supertype entity is a group of mutually exclusive subtypes
85
Crows foot notation
depicts cardinality as a circle(zero) a short line(one) or three short lines(many)
86
Intangible entity
A documented in the data model, but not tracked
87
PRIMARY KEYS
Simple. Primary key values should be easy to type and store.
88
Artificial key
A single-column primary key created by the database designer when no suitable single-column or composite primary key exists.
89
Functional dependence
Dependence of one column on another
90
Redundancy
is the repetition of related values in a table
91
Normal forms
Rules for designing tables with less redundancy
92
Boyce-Codd normal form
Idea for tables with frequent inserts, updates and deletes
93
Trivial dependencies
When the columns of A are a subset of the columns of B,
94
Normalization
Eliminates redundancy by decomposing a table into two or more tables.
95
Denormalization
Means intentionally introducing redundancy by merging tables.
96
Heap Table
no order is imposed on rows
97
Hash table
rows are assigned to buckets
98
Table scan
A database operation that reads table blocks directly
99
Index scan
Database operation that reads index blocks sequentially
100
Hit ratio
Filter factor or selectivity is the percentage of table rows selected by a query

D276 Web dev foundations (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions