Module 1 Flashcards
What is an entity?
A person, place, thing, or event about which data will be collected and stored.
What is an attribute?
A characteristic of an entity, such as customer last name, customer first name, customer phone number.
What does a relationship describe?
An association among entities.
In the relationship ‘PAINTER paints PAINTING’, what type of relationship is it?
One to Many
In the relationship ‘EMPLOYEE learns SKILL’, what type of relationship is it?
Many to Many
What is defined as an organized collection of logically related data?
Database
What is essential for organizations to survive and prosper?
Data
What refers to facts concerning objects and events that could be recorded and stored?
Data
True or False: Data consists of raw facts.
True
We define _________ as data that have been processed in such a way that the knowledge of the person who uses the data is increased.
Information
What are the Basic File Terminology? Select all that apply.
- Data
- File
- Field
- Record
What is a field?
A character or group of characters (alphabetic or numeric) that has a specific meaning.
What is a record?
A logically connected set of one or more fields that describes a person, place, or thing.
What captures the nature and relationships among data?
Data Models
What is an entity in a data model?
A person, place, thing, or event about which data is collected.
In a one-to-many (1:M) relationship, which of the following is true?
One entity can be related to multiple entities on the other side.
Which relationship type requires an intermediate table for proper database modeling?
Many-to-Many (M:N)
What does a crow’s foot notation indicate in the ER diagram?
A one-to-many relationship
What is the separation of data descriptions (metadata) from the application programs called?
Data Independence
What refers to all of the system’s physical devices?
Hardware
What manages all hardware components and allows other software to run?
Operating System Software
Who are known as DBAs?
Database administrators
What do database designers do?
They are the database architects.
Who designs and implements application programs?
System analysts and programmers
Who uses application programs to run daily operations?
End users
What governs the design and use of the database system?
Procedures
What is the first step in designing a database?
Data modeling
What is a relatively simple representation of complex real-world data structures?
Data model
What is the main purpose of constraints in a data model?
To ensure data integrity
Which of the following is an example of a Many-to-Many (M:N) relationship?
A student enrolls in multiple classes, and each class has multiple students.
What is an example of a One-to-One (1:1) relationship?
Each store has only one manager, and each manager manages only one store.
What is the first step in properly identifying entities, attributes, relationships, and constraints in a data model?
Clearly identifying the business rules for the problem domain
What is the purpose of business rules in a database?
To define policies, procedures, or principles within an organization
What part of a business rule usually represents a relationship in a data model?
A verb
The ‘3 Vs’ concept of Big Data consists of which of the following?
Volume, Velocity, and Variety
What refers to a movement to find new ways to manage large amounts of data?
Big Data
What refers to the amounts of data being stored?
Volume
What refers to the speed with which data grows?
Velocity
What refers to the fact that the data being collected comes in multiple different data formats?
Variety
What type of database represents data as a collection of tables?
Relational Databases
What is a software system used to create and maintain user databases?
Database Management Systems
What refers to an organization of components that define and regulate data management?
Database system
What is one of the key benefits of data models?
They facilitate interaction among designers, programmers, and users.
What is an abstraction of a real-world entity?
Object
What is the ability of an object to inherit attributes from classes above it?
Inheritance
What is a collection of similar objects with shared structure and behavior?
Class
What describes a set of diagrams and symbols to model a system?
Unified Modeling Language (UML)
What is a metalanguage used to represent and manipulate data elements?
Extensible Markup Language (XML)