Brainscape's Knowledge GenomeTM

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


See full index

Databases > terms > Flashcards

terms Flashcards

1
Q

What is atomicity?

A

the rule to make data in its simplest form

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

what is data integrity?

A

the overall completeness, accuracy, and consistency of data within a database

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

what is data redundancy?

A

Duplication of the same attributes in a table.

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

what is data duplication?

A

Data that is physically duplicated across a database

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

what is referential integrity?

A

States that table relationships must always be consistent

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

what is a field?

A

a heading in a table which data of the same data type is stored under

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

what is a record?

A

a complete row of data contained in a table

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

what is a relationship?

A

Associations between tables that are created using join statements to retrieve data

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

what is data dictionary?

A

a collection of the names of fields, tables, and attributes for data within a table

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

what is the private key?

A

remains confidential to the respective owner

used to decrypt the message

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

what is the public key?

A

made available to everyone via a publicly accessible repository or directory
used to encrypt the message

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

what is the foreign key?

A

the foreign key is defined in a second table, but refers to the primary key or a unique key in the first table.

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

what is the primary key?

A

a field designated to uniquely identify all the table records
must contain a unique value for each row of data

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

what are the different data types?

A

text (letters, numbers, symbols) (need “”)
integer (whole numbers) (no decimals)
real (decimal numbers)

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

what are biometrics?

A 
measure the unique characteristics of a person.
includes: 
voice patterns
fingerprint scans
iris scans
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

what is digital signature?

A

process that guarantees the contents of a message haven’t been altered in transit.

17
Q

what is encryption?

A

converting information or data into a code to prevent unauthorised access.

18
Q

what is decryption?

A

the conversion of encrypted data into its original form

19
Q

what is an attribute?

A

any single piece of data inside a table

20
Q

what is a character?

A

a single visual object

21
Q

what is an entity?

A

real world things that are represented in the database

22
Q

what is a table?

A

a structure collection of fields, attributes, and records

23
Q

what is a database?

A

An organised collection of records presented in a standardised format searched by computers.

24
Q

what is the purpose of database documentation?

A

it provides a common language between business decision makers and IT personnel

25
Q

what is chen’s notation made up of?

A

entities
attributes
relationships
cardinality

26
Q

what are all of the cardinalities?

A

1-1 (1 to 1)
1-M (1 to many)
M-1 (many to 1)
M-N (Many to Many)

Databases (1 decks)

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