Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Exam 1 Ch1-4 | INFO 3233 - Data and Information Management, Quizzes of Deductive Database Systems

Class: INFO 3233 - Data and Information Management; Subject: Management Information Systems; University: University of North Carolina - Charlotte; Term: Fall 2014;

Typology: Quizzes

2015/2016

Uploaded on 09/26/2016

akindler29
akindler29 🇺🇸

2 documents

1 / 11

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
TERM 1
Data
DEFINITION 1
"Raw Facts"
TERM 2
Field
DEFINITION 2
A character or group of characters that have a specific
meaning .A field is used to define and store data
TERM 3
Record
DEFINITION 3
a logically connected set of one or more fields that describes
a nounEx- a customers name and address
TERM 4
File
DEFINITION 4
a collection of related records
TERM 5
Metadata
DEFINITION 5
data about data
pf3
pf4
pf5
pf8
pf9
pfa

Partial preview of the text

Download Exam 1 Ch1-4 | INFO 3233 - Data and Information Management and more Quizzes Deductive Database Systems in PDF only on Docsity!

Data

"Raw Facts"

TERM 2

Field

DEFINITION 2

A character or group of characters that have a specific

meaning .A field is used to define and store data

TERM 3

Record

DEFINITION 3

a logically connected set of one or more fields that describes

a nounEx- a customers name and address

TERM 4

File

DEFINITION 4

a collection of related records

TERM 5

Metadata

DEFINITION 5

data about data

Entity

Anything about which data are to be collected and stored

TERM 7

Attribute

DEFINITION 7

A characteristic of an entity

TERM 8

Relationship

DEFINITION 8

Describes association aoming entities types:-one to many-

many to many-one to one

TERM 9

Constraint

DEFINITION 9

a restriction placed on the data

TERM 10

Relational Model

DEFINITION 10

hides complexity from the user by managing all the physical

details and allowing the user to work at the logical level the

relational diagram represents entities attributes and

relationships

Table

two-dimensional structure composed of rows and columns

contains group of related entity occurrences

TERM 17

Key

DEFINITION 17

one or more attributes that determine other attributes

TERM 18

Determination

DEFINITION 18

if you know the value of attribute A, you can look up or

determine the value of attribute BEx: if you know the Student

ID Number you can then determine the Student Name

TERM 19

Functional Dependence

DEFINITION 19

Attribute B is functionally dependent on attribute A if each

value in column A determines one and only one value in

column B

TERM 20

Composite Key

DEFINITION 20

composed of more than one attribute

Super Key

Any key that uniquely identifies each row. A superkey

functionally determines all of the entity's attributes

TERM 22

Candidate Key

DEFINITION 22

a superkey without unnecessary attributes

TERM 23

Primary Key

DEFINITION 23

A candidate key selected to uniquely identify all other

attribute values in any given row. CANNOT CONTAIN NULL

ENTRIES

TERM 24

Foreign Key

DEFINITION 24

In the context of relational databases, a foreign key is a field

in one table that uniquely identifies a row of another table.

TERM 25

Null

DEFINITION 25

no data entry

UNION

combines all rows from 2 tables and excludes duplicates

TERM 32

INTERSECT

DEFINITION 32

yields rows that are shown in both tables

TERM 33

DIFFERENCE

DEFINITION 33

yields rows in one table not found in the other table

TERM 34

PRODUCT

DEFINITION 34

yields all possible rows from two tables

TERM 35

JOIN

DEFINITION 35

links 2 tables together

NATURAL JOIN

1. product2. select3. project

TERM 37

INNER JOIN

DEFINITION 37

1. product2. select

TERM 38

OUTER JOIN

DEFINITION 38

gives inner join plus unmatched records from one of the two

tables

TERM 39

Composite

entity

DEFINITION 39

bridge entity used to avoid problems inherent to M:N

relationships

TERM 40

Index

DEFINITION 40

orderly arrangement used to logically access rows in a table

Cardinality

expresses min and max number of entity occurrences

associated with one occurrence of related entity

TERM 47

Weak (non-identifying) relationship

DEFINITION 47

the foreign key is not part of the primary key

TERM 48

Strong (identifying) Relationship

DEFINITION 48

when the PL f the related entity contains the PK component

of the parent entity

TERM 49

Weak Entity

DEFINITION 49

1. existence-dependent = it cannot exist without the entity

with which it has a relationship2. its primary key is partially

or totally derived from parent entity in relationshipa strong

relationship indicates that the related entity is weak

TERM 50

Associative (Composite) Entities

DEFINITION 50

Bridge entities used to implement M:N relationships

composed of PKs of each of the entities to be connected