Module 1

Question 1

What is an entity?

Answer 1

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

Question 2

What is an attribute?

Answer 2

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

Question 3

What does a relationship describe?

Answer 3

An association among entities.

Question 4

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

Answer 4

One to Many

Question 5

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

Answer 5

Many to Many

Question 6

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

Answer 6

Database

Question 7

What is essential for organizations to survive and prosper?

Answer 7

Data

Question 8

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

Answer 8

Data

Question 9

True or False: Data consists of raw facts.

Answer 9

True

Question 10

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

Answer 10

Information

Question 11

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

Answer 11

• Data
• File
• Field
• Record

Question 12

What is a field?

Answer 12

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

Question 13

What is a record?

Answer 13

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

Question 14

What captures the nature and relationships among data?

Answer 14

Data Models

Question 15

What is an entity in a data model?

Answer 15

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

Question 16

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

Answer 16

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

Question 17

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

Answer 17

Many-to-Many (M:N)

Question 18

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

Answer 18

A one-to-many relationship

Question 19

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

Answer 19

Data Independence

Question 20

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

Answer 20

Hardware

Question 21

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

Answer 21

Operating System Software

Question 22

Who are known as DBAs?

Answer 22

Database administrators

Question 23

What do database designers do?

Answer 23

They are the database architects.

Question 24

Who designs and implements application programs?

Answer 24

System analysts and programmers

Question 25

Who uses application programs to run daily operations?

Answer 25

End users

Question 26

What governs the design and use of the database system?

Answer 26

Procedures

Question 27

What is the first step in designing a database?

Answer 27

Data modeling

Question 28

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

Answer 28

Data model

Question 29

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

Answer 29

To ensure data integrity

Question 30

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

Answer 30

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

Question 31

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

Answer 31

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

Question 32

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

Answer 32

Clearly identifying the business rules for the problem domain

Question 33

What is the purpose of business rules in a database?

Answer 33

To define policies, procedures, or principles within an organization

Question 34

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

Answer 34

A verb

Question 35

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

Answer 35

Volume, Velocity, and Variety

Question 36

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

Answer 36

Big Data

Question 37

What refers to the amounts of data being stored?

Answer 37

Volume

Question 38

What refers to the speed with which data grows?

Answer 38

Velocity

Question 39

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

Answer 39

Variety

Question 40

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

Answer 40

Relational Databases

Question 41

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

Answer 41

Database Management Systems

Question 42

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

Answer 42

Database system

Question 43

What is one of the key benefits of data models?

Answer 43

They facilitate interaction among designers, programmers, and users.

Question 44

What is an abstraction of a real-world entity?

Answer 44

Object

Question 45

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

Answer 45

Inheritance

Question 46

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

Answer 46

Class

Question 47

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

Answer 47

Unified Modeling Language (UML)

Question 48

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

Answer 48

Extensible Markup Language (XML)