What is the main purpose of a database? correct answers to keep track of things
What is the difference between a database and a workbook/worksheet? correct answers Spreadsheets are computer programs that arrange data in a series of rows and columns. Databases gather information from external tab...
ISM 310 exam #2 || with 100% Correct Answers.
What is the main purpose of a database? correct answers to keep track of things
What is the difference between a database and a workbook/worksheet? correct 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? correct answers help users share data
quickly, effectively, and securely across an organization.
What is analytics? correct answers the scientific process of transforming data into insight for
making better decisions
What is access and reporting? correct 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? correct answers Any collection of related items stored in a computers
memory
What is another term for table? Record? Field? correct answers A table has records (rows) and
fields (columns).
What is metadata? What are some examples? correct 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? correct 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? correct 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? correct 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? correct 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? correct answers 1. Read
2. Insert
3. Modify
4. Delete data
What is the purpose of a form? correct 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? correct answers to communicate and create a permanent record
What is the purpose of a query and how does it differ from a report? correct 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? correct 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? correct 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? correct 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? correct answers characteristics of an entity
What is an identifier (also known as unique identifier)? correct 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. correct
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).
What is meant by cardinality? How do we represent: required, optional, many? correct answers
Determines the number of entities on one side of the relationship that can be joined to a single
entity on the other side. In databases, cardinality refers to the relationships between the data in
two database tables. Cardinality can be used to define data models as well as analyze entities
within datasets.
What is normalization? Why do we do it? What do we mean by single themes when we
normalize? correct answers Converting poorly structured tables into two or more well structured
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller FullyFocus. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.