Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DB sys IA > Mid Term > Flashcards

Mid Term Flashcards

1
Q

What does DML stand for?

A

Data Manipulation Language

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

What is the purpose of DML operations?

A

To manipulate the table.

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

3 types of DML operations?

A
  1. Insert
  2. delete
  3. Update
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

A notation for describing data or information

A

A data model

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

What are 3 ways a data model can describe data?

A
  1. Structure of the data
  2. Operations on the data
  3. Constraints on the data
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Represents data in 2-D table (rows and columns)

A

Relations

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

True me false: Table, entity, and relation are the same?

A

True

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

The columns of a relation are called?

A

Attributes

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

What do attributes describe?

A

The meaning of entries in the column

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

What is a logical structure for data?

A

Schema

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

The set of schemas for the relations in a relational database are called?

A

Relational Database Schema

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

The name of a relation and the set of attributes for a relation?

A

Schema (for relation)

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

What is ‘a set’?

A

The attributes in a relation schema

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

True or False: Rows and Tuples are the same thing?

A

True

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

What are tuples?

A

The rows of a relation, minus the header.

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

What is the relationship between an attribute and a domain?

A

Each attribute of a relation is a domain

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

What are the two parts of a relation?

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

Formal term for ‘Table’

A

Relation

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

Formal term for ‘Column’

A

Attribute

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

Formal term for ‘Row’

A

Tuple

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

Formal term for values in a Column

A

Domain

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

Formal term for Table Definition

A

Relation Schema

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

Formal term for populated Table

A

Relation Instance/Extension

24
Q

Properties of relations

A
  1. No duplicate tuples
  2. Tuples have no order
  3. No duplicate attributes
  4. Attributes have no order
  5. Every tuple must have attribute values from each of the domains or NULL
25
Q

T/F: Tuples are unordered

A

True

26
Q

T/F: Attributes are unordered

A

True

27
Q

What are two ways to declare a key in the CREATETABLE statement?

A
  1. Declare 1 attribute when listed in the relation schema
  2. Add an additional declaration identifying a listed attribute or set of attributes which form the key
28
Q

A specific type of field in a relational database that can identify each unique record independently of any other data.

A

Candidate Key

29
Q

A column or group of columns in a relational database table that provides a link between data in two relations.

A

Foreign Key

30
Q

A special relational database table column (or combination of columns) designated to uniquely identify each table record.

A

Primary Key

31
Q

a candidate key that consists of two or more attributes that together uniquely identify an entity occurrence

A

Composite Key

32
Q

What is a stored relation?

A

Table

33
Q

Relations defined by computation. They are not stored but are constructed when needed.

A

Views

34
Q

Relations created by SQL language processor when executing queries and data modifications.

A

Temporary Tables

35
Q

Data objects that either identify or describe entities…

A

Attributes

36
Q

What are two types of attributes?

A
  1. Simple Attribute
  2. Composite Attribute
37
Q

An attribute that cannot be sub-divided

A

Simple Attribute

38
Q

An attribute that can be sub-divided to yield additional attributes

A

Composite Attribute

39
Q

An attribute that is not physically stored within the database; derived by algorithm

A

Derived Attribute

40
Q

An attribute that can only have a single atomic value

A

Single-valued Attribute

41
Q

An attribute that can have many values

A

Multi-valued Attribute

42
Q

Connections among two or more entity sets are called…

A

Relations

43
Q

The maximum number of times an instance in one entity can be associated with instances in a related entity

A

Cardinality

44
Q

The minimum number of times an instance in one entity can be associated with an instance in a related entity

A

Modality

45
Q

Cardinality values

A

One or Many

46
Q

Modality Values

A

One or Zero

47
Q

In ER Diagrams entity sets are represented by…

A

Rectangles

48
Q

In ER Diagrams attributes are represented by…

A

Ovals

49
Q

In ER Diagrams relationships are represented by…

A

Diamonds

50
Q

Requires that if a value of one attribute of a relation references a value of another attribute, then the referenced value must exist.

A

Referential Integrity Constraint

51
Q

A collection of data that is managed by a DBMS…

A

Database

52
Q

A software tool for managing data in a database

A

Database Management System (DBMS)

53
Q

If a DMBS is for a relational database?

A

RDMBS

54
Q

How does DMBS allow users to define schema (structure)?

A

Data Definition Language (DDL)

55
Q

How does DMBS allow users to query (question) or modify the data?

A

Data Manipulation Language (DML)

56
Q

What are the two types of languages used by DMBS?

A
  1. Data Definition Language (DDL)
  2. Data Manipulation Language (DML)
57
Q

In SQL, what is projection?

A

When you add criteria

DB sys IA (1 decks)

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