Module 1 Flashcards

1
Q

What is an entity?

A

A person, place, thing, or event about which data will be collected and stored.

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

What is an attribute?

A

A characteristic of an entity, such as customer last name, customer first name, customer phone number.

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

What does a relationship describe?

A

An association among entities.

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

In the relationship ‘PAINTER paints PAINTING’, what type of relationship is it?

A

One to Many

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

In the relationship ‘EMPLOYEE learns SKILL’, what type of relationship is it?

A

Many to Many

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

What is defined as an organized collection of logically related data?

A

Database

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

What is essential for organizations to survive and prosper?

A

Data

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

What refers to facts concerning objects and events that could be recorded and stored?

A

Data

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

True or False: Data consists of raw facts.

A

True

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

We define _________ as data that have been processed in such a way that the knowledge of the person who uses the data is increased.

A

Information

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

What are the Basic File Terminology? Select all that apply.

A
  • Data
  • File
  • Field
  • Record
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is a field?

A

A character or group of characters (alphabetic or numeric) that has a specific meaning.

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

What is a record?

A

A logically connected set of one or more fields that describes a person, place, or thing.

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

What captures the nature and relationships among data?

A

Data Models

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

What is an entity in a data model?

A

A person, place, thing, or event about which data is collected.

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

In a one-to-many (1:M) relationship, which of the following is true?

A

One entity can be related to multiple entities on the other side.

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

Which relationship type requires an intermediate table for proper database modeling?

A

Many-to-Many (M:N)

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

What does a crow’s foot notation indicate in the ER diagram?

A

A one-to-many relationship

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

What is the separation of data descriptions (metadata) from the application programs called?

A

Data Independence

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

What refers to all of the system’s physical devices?

21
Q

What manages all hardware components and allows other software to run?

A

Operating System Software

22
Q

Who are known as DBAs?

A

Database administrators

23
Q

What do database designers do?

A

They are the database architects.

24
Q

Who designs and implements application programs?

A

System analysts and programmers

25
Q

Who uses application programs to run daily operations?

26
Q

What governs the design and use of the database system?

A

Procedures

27
Q

What is the first step in designing a database?

A

Data modeling

28
Q

What is a relatively simple representation of complex real-world data structures?

A

Data model

29
Q

What is the main purpose of constraints in a data model?

A

To ensure data integrity

30
Q

Which of the following is an example of a Many-to-Many (M:N) relationship?

A

A student enrolls in multiple classes, and each class has multiple students.

31
Q

What is an example of a One-to-One (1:1) relationship?

A

Each store has only one manager, and each manager manages only one store.

32
Q

What is the first step in properly identifying entities, attributes, relationships, and constraints in a data model?

A

Clearly identifying the business rules for the problem domain

33
Q

What is the purpose of business rules in a database?

A

To define policies, procedures, or principles within an organization

34
Q

What part of a business rule usually represents a relationship in a data model?

35
Q

The ‘3 Vs’ concept of Big Data consists of which of the following?

A

Volume, Velocity, and Variety

36
Q

What refers to a movement to find new ways to manage large amounts of data?

37
Q

What refers to the amounts of data being stored?

38
Q

What refers to the speed with which data grows?

39
Q

What refers to the fact that the data being collected comes in multiple different data formats?

40
Q

What type of database represents data as a collection of tables?

A

Relational Databases

41
Q

What is a software system used to create and maintain user databases?

A

Database Management Systems

42
Q

What refers to an organization of components that define and regulate data management?

A

Database system

43
Q

What is one of the key benefits of data models?

A

They facilitate interaction among designers, programmers, and users.

44
Q

What is an abstraction of a real-world entity?

45
Q

What is the ability of an object to inherit attributes from classes above it?

A

Inheritance

46
Q

What is a collection of similar objects with shared structure and behavior?

47
Q

What describes a set of diagrams and symbols to model a system?

A

Unified Modeling Language (UML)

48
Q

What is a metalanguage used to represent and manipulate data elements?

A

Extensible Markup Language (XML)