INSY 3304 Exam 1 Questions And Answers Rated 100% Correct
7 views 0 purchase
Course
INSY 3304
Institution
INSY 3304
_________ provide a description of the data characteristics and the set of relationships
that link the data found within the database. - ️️Metadata
Within the database environment, a data model represents data structures with the
purpose of supporting a specific problem domain. - ️️True
...
INSY 3304 Exam 1
_________ provide a description of the data characteristics and the set of relationships
that link the data found within the database. - ✔️✔️Metadata
Within the database environment, a data model represents data structures with the
purpose of supporting a specific problem domain. - ✔️✔️True
Database designers determine the data and information that yield the required
understanding of the entire business. - ✔️✔️False
In an SQL-based relational database, each table is dependent on every other table. -
✔️✔️False
An operational database is sometimes referred to as an enterprise database. -
✔️✔️False
Corporations use only structured data. - ✔️✔️False
Business rules apply to businesses and government groups, but not to other types of
organizations such as religious groups or research labs. - ✔️✔️False
A _______ is anything about which data are to be collected and stored. - ✔️✔️entity
________ data exist in a format that does not lend itself to processing that yields
information. - ✔️✔️Unstructured
A ________ is bidirectional. - ✔️✔️relationship
A data warehouse can store data derived from many sources. - ✔️✔️True
A ____ is a collection of related records. - ✔️✔️file
A noun in a business rules translates to an ______ in the data model. - ✔️✔️entity
The database structure in a DBMS is stores as a - ✔️✔️collection of files.
M:N relationships are not appropriate in a relational model. - ✔️✔️True
___________ relates to the activities that make the database execute transactions
more efficiently in terms of storage and access speed. - ✔️✔️Performance tuning
, Data processing can be as simple as organization data to reveal patterns. - ✔️✔️True
An _________ is the equivalent of a field in a file system. - ✔️✔️attribute
Data is the results of processing raw facts to reveal its meaning. - ✔️✔️False
A desktop database is a ________ database. - ✔️✔️single-user
A workgroup database is a ________ database. - ✔️✔️multiuser
Database programming languages receive all application requests and translate them
into the complex operations required to a fulfill those requests. - ✔️✔️False
Each row in the relational table is known as an entity instance or entity occurrence in
the ER model. - ✔️✔️True
The external model is the representation of the database as "seen" by the DBMS -
✔️✔️False
An _______ database is used by an organization and supports many users across
many departments. - ✔️✔️enterprise
An entity is the entity relationship model corresponds to a table in the relational
environment. - ✔️✔️True
In organizations that generate large number of transactions, ________ are often a top
priority in database designs. - ✔️✔️high processing speeds
Relationships between entities always operate in one directions. - ✔️✔️False
In the entity relationship diagram (ERD), cardinality is indicated using the ________
notation, where max is the maximum number of associated entities and min represents
the minimum number of associated entities. - ✔️✔️(min, max)
The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key
column had no null entries, and all entries are unique. This is an example of ______
integrity. - ✔️✔️entity
___________ are especially useful when you are trying to determine what values in
related tables cause referential integrity problems. - ✔️✔️Outer joins
The first step in building an entity-relationship diagram (ERD) is - ✔️✔️creating a
detailed narrative of the organization's descriptions of operations
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 PatrickKaylian. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.39. You're not tied to anything after your purchase.
