INSY 3304 Exam 1 Questions And 100% Correct Answers
A _______ is anything about which data are to be collected and stored. - ANSWER entity
A ________ is bidirectional. - ANSWER relationship
Database designers determine the data and information that yield the required
understanding of the entire business. - ANSWER False
In an SQL-based relational database, each table is dependent on every other table. -
ANSWER False
An operational database is sometimes referred to as an enterprise database. - ANSWER
False
Corporations use only structured data. - ANSWER False
Business rules apply to businesses and government groups, but not to other types of
organizations such as religious groups or research labs. - ANSWER False
________ data exist in a format that does not lend itself to processing that yields
information. - ANSWER Unstructured
A data warehouse can store data derived from many sources. - ANSWER True
A ____ is a collection of related records. - ANSWER file
A noun in a business rules translates to an ______ in the data model. - ANSWER entity
, The database structure in a DBMS is stores as a - ANSWER collection of files.
M:N relationships are not appropriate in a relational model. - ANSWER True
_________ refers to the activities that make the database perform transactions more
efficiently in terms of speed of storage and access. - ANSWER Performance tuning
Data processing can be as simple as organization data to reveal patterns. - ANSWER
True
An _________ is the equivalent of a field in a file system. - ANSWER attribute
Within the context of the database environment, a data model represents data
structures with the purpose of supporting a particular problem domain. - ANSWER True
The result of processing raw facts to reveal its meaning is called data. - ANSWER False
A desktop database is a ________ database. - ANSWER single-user
A workgroup database is a ________ database. - ANSWER multiuser
__________ describe the characteristics of data and the relationships that interconnect
data within the database. - ANSWER Metadata
Database programming languages get all application requests and translate them into
the complex operations required to a fulfill those requests. - ANSWER False
Every row in relational table is called as an entity instance or entity occurrence in the
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 Stetson. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.