Data

Question 1

What does RAD stand for?

Answer 1

Rapid Application Development

Question 2

What does RDBMS stand for?

Answer 2

Relational Database Management System

Question 3

Tables, fields, & relationships are called base elements or….

Answer 3

Schema

Question 4

FM field data types (5):
T
N
D
T
T

Answer 4

Text
Number
Date
Time
Timestamp

Question 5

A coherent, distinct type of thing the app will track (think nouns of a system description)

Answer 5

Entity

Question 6

A quality or feature regarded as a characteristic or inherent part of someone or something

Answer 6

Attribute

Question 7

Spreadsheet Term: Worksheet … data modeling term?

Answer 7

Data Modeling Term: Entity

Question 8

Data Modeling Term: Entity … Database term?

Answer 8

Database Term: Table

Question 9

SS Term: Worksheet - DM Term: Entity … Database term?

Answer 9

Database Term: Table

Question 10

SS Term: Column … DM Term?

Answer 10

Data Modeling Term: Attribute

Question 11

SS Term: Column - DM Term: Attribute … Database Term?

Answer 11

Database Term: Field

Question 12

SS Term: Row … Data modeling term?

Answer 12

Data modeling term: Individual instance of this entity

Question 13

SS Term: Row - DM Term: Individual instance of this entity … Database Term?

Answer 13

Database Term: Record

Question 14

A collection of data categories (entities) that have been connected in various ways.

Answer 14

Relational database

Question 15

Connections between data categories

Answer 15

Relationships

Question 16

Customer - Order Relationshp

Each order is associated with one and only one customer.

Each customer may potentially have many orders in the app.

Answer 16

One-to-many relationship

Question 17

Actor - Movie Relationship

One actor may act (over time) in many movies.

One movie generally has roles for many actors.

Answer 17

Many-to-many relationship

Question 18

A diagram that shows a number of entities and their relationships.

Answer 18

Entity-Relationship Diagram (ERD)

Question 19

An attribute that is guaranteed to be non-empty, unchanging, and unique for each occurrence of a given entity.

Answer 19

Primary Key

Question 20

An attribute used to establish a link to another entity, generally by pointing back to the primary key of that entity.

Answer 20

Foreign Key

Question 21

When a field has more than one value at once…

Answer 21

Multivalued attribute

Question 22

How to resolve a many-to-many relationship

Answer 22

Two one-to-many relationships with a ‘join entity’ with 2 foreign keys. Each foreign key is the primary key from the main entities. Add any other additional attributes (if needed)

Question 23

—–|< (hatch plus fork)

Answer 23

Minimum of one, maximum of many

Question 24

—–o< (circle plus fork)

Answer 24

Minimum of zero, maximum of many

Question 25

—–|-|- (hatch plus hatch)

Answer 25

Minimum of one, maximum of one

Question 26

—–o|- (circle plus hatch)

Answer 26

Minimum of zero, maximum of one

Question 27

A “slot” that can hold information specific to a single database record.

Answer 27

Field

Question 28

Field option ‘Data’

Answer 28

Enters data when a new record is created. This is useful when you want a field to be populated with a default value on new record creation.

Question 29

Field option ‘Calculated Value’

Answer 29

Populates the initial value of a field with the value returned by a calculation formula.

Question 30

‘Do not replace existing value of field (if any)’

Answer 30

Prevents overwriting data already present in the field. When unchecked, the auto-enter triggers both when the record is created & when any of the current table’s fields referenced in the calc. form. are modified.

Question 31

Field option ‘Looked-up Value’

Answer 31

Populates a field with a value from another field obtained via a relationship.

Question 32

Field Validation

Answer 32

Allows you to test field data against specific criteria and warn the user if the field value is invalid in some way. If a user tries to commit a record containing field data that fails validation rules, the user will receive a warning and be prompted to change the non-conforming data.