ISM 310 EXAM #2 QUESTIONS AND VERIFIED
ACCURATE ANSWERS
What is the main purpose of a database? - Answers - to keep track of things
What is the difference between a database and a workbook/worksheet? - Answers -
Spreadsheets are computer programs that arrange data in a series of rows and
columns. Databases gather information from external tables, instead of storing data in
individual cells.
What is the competitive advantage for using databases? - Answers - help users share
data quickly, effectively, and securely across an organization.
What is analytics? - Answers - the scientific process of transforming data into insight for
making better decisions
What is access and reporting? - Answers - Alerting seeing what needs to be done. To
be query to examine where the problem is. Ad hoc reports which asks the questions
how many, how often, where? Standard reports which ask what happened
What is a database? - Answers - Any collection of related items stored in a computers
memory
What is another term for table? Record? Field? - Answers - A table has records (rows)
and fields (columns).
What is metadata? What are some examples? - Answers - Data that describes data
make databases more useful and easier to use.
Ex... Schema, Data definitions, Data types, Field size
What is a relation? What is a relationship? - Answers - Relation can be used to show
the mutual connection between two different countries or Relations can also indicate
people who are related to each other in a specific way. A relationship is link between
two subjects or human beings and is used informally.
How do we relate two tables in a database? - Answers - A relationship works by
matching data in key columns, usually columns (or fields) that have the same name in
both tables.
What is a primary key and what is an example? - Answers - A primary key, also called a
primary keyword, is a column in a relational database table that's distinctive for each
record. It's a unique identifier, such as a driver's license number, telephone number with
, area code or vehicle identification number (VIN). A relational database must have only
one primary key.
What is a foreign key and what is an example? - Answers - Is a column or combination
of columns that is used to establish and enforce a link between the data in two tables to
control the data that can be stored in the foreign key table.
What are the four DBMS operations and what do they each do? - Answers - 1. Read
2. Insert
3. Modify
4. Delete data
What is the purpose of a form? - Answers - Can help you easily create an interface to
view, add, update, and delete data from a database
What is the purpose of a report? - Answers - to communicate and create a permanent
record
What is the purpose of a query and how does it differ from a report? - Answers - A
query is a question you define and send to the data source to retrieve the data. A report
is an organized and formatted view of the data the query retrieved
What are some examples of application programs in a database? - Answers - MySQL,
Oracle, PostgreSQL, Microsoft SQL Server, MongoDB, Redis, Elasticsearch,
Cassandra, MariaDB, IBM Db2.
How do we know what entities to create? What is an entity? - Answers - An entity in a
database is a thing, place, person or object that is independent of another. In
databases, you store information about things in the real world, and these things are
database entities
What is a data model comprised of? How does this differ from Database design? -
Answers - Data model is a set or collection of construct used for creating a database
and producing designs for the databases. Database design is stored in the database
schema, which is in turn stored in the data dictionary.
What are attributes? - Answers - characteristics of an entity
What is an identifier (also known as unique identifier)? - Answers - a numeric or
alphanumeric string that is associated with a single entity within a given system
How do we represent entities/entity names? Primary keys? Attributes? In a data model.
- Answers - An entity is an object in the real world with an independent existence that
can be differentiated from other objects. An entity might be an object with physical
existence, an object with conceptual existence. Each entity is described by a set of
attributes (e.g., Employee = (Name, Address, Birthdate (Age), Salary).
ACCURATE ANSWERS
What is the main purpose of a database? - Answers - to keep track of things
What is the difference between a database and a workbook/worksheet? - Answers -
Spreadsheets are computer programs that arrange data in a series of rows and
columns. Databases gather information from external tables, instead of storing data in
individual cells.
What is the competitive advantage for using databases? - Answers - help users share
data quickly, effectively, and securely across an organization.
What is analytics? - Answers - the scientific process of transforming data into insight for
making better decisions
What is access and reporting? - Answers - Alerting seeing what needs to be done. To
be query to examine where the problem is. Ad hoc reports which asks the questions
how many, how often, where? Standard reports which ask what happened
What is a database? - Answers - Any collection of related items stored in a computers
memory
What is another term for table? Record? Field? - Answers - A table has records (rows)
and fields (columns).
What is metadata? What are some examples? - Answers - Data that describes data
make databases more useful and easier to use.
Ex... Schema, Data definitions, Data types, Field size
What is a relation? What is a relationship? - Answers - Relation can be used to show
the mutual connection between two different countries or Relations can also indicate
people who are related to each other in a specific way. A relationship is link between
two subjects or human beings and is used informally.
How do we relate two tables in a database? - Answers - A relationship works by
matching data in key columns, usually columns (or fields) that have the same name in
both tables.
What is a primary key and what is an example? - Answers - A primary key, also called a
primary keyword, is a column in a relational database table that's distinctive for each
record. It's a unique identifier, such as a driver's license number, telephone number with
, area code or vehicle identification number (VIN). A relational database must have only
one primary key.
What is a foreign key and what is an example? - Answers - Is a column or combination
of columns that is used to establish and enforce a link between the data in two tables to
control the data that can be stored in the foreign key table.
What are the four DBMS operations and what do they each do? - Answers - 1. Read
2. Insert
3. Modify
4. Delete data
What is the purpose of a form? - Answers - Can help you easily create an interface to
view, add, update, and delete data from a database
What is the purpose of a report? - Answers - to communicate and create a permanent
record
What is the purpose of a query and how does it differ from a report? - Answers - A
query is a question you define and send to the data source to retrieve the data. A report
is an organized and formatted view of the data the query retrieved
What are some examples of application programs in a database? - Answers - MySQL,
Oracle, PostgreSQL, Microsoft SQL Server, MongoDB, Redis, Elasticsearch,
Cassandra, MariaDB, IBM Db2.
How do we know what entities to create? What is an entity? - Answers - An entity in a
database is a thing, place, person or object that is independent of another. In
databases, you store information about things in the real world, and these things are
database entities
What is a data model comprised of? How does this differ from Database design? -
Answers - Data model is a set or collection of construct used for creating a database
and producing designs for the databases. Database design is stored in the database
schema, which is in turn stored in the data dictionary.
What are attributes? - Answers - characteristics of an entity
What is an identifier (also known as unique identifier)? - Answers - a numeric or
alphanumeric string that is associated with a single entity within a given system
How do we represent entities/entity names? Primary keys? Attributes? In a data model.
- Answers - An entity is an object in the real world with an independent existence that
can be differentiated from other objects. An entity might be an object with physical
existence, an object with conceptual existence. Each entity is described by a set of
attributes (e.g., Employee = (Name, Address, Birthdate (Age), Salary).
