IS 301 Midterm Exam 2025

The DBMS reveals much of the database's internal complexity to the application programs and users. True False - False ____ is used to reveal the meaning of data. Raw facts Knowledge Formatting Information - Information Most data you encounter is best classified as ____. Structured Semistructured Unstructured Historical - Semistructured A(n) ____ database is used by an organization and supports many users across many departments. desktop workgroup enterprise transactional - enterprise ____ exists when different versions of the same data appear in different places. Data inconsistency Data consistency Better data integration Improved decision making - Data inconsistency The only way to access the data in a database is through the DBMS. True False - True Accurate, relevant, and timely information is the key to ____. data management good decision making knowledge understanding - good decision making A(n) ____ database is designed to support a company's day-to-day operations. desktop workgroup enterprise transactional - transactional Historically, a manual file system was composed of a system of file folders and filing cabinets. True False - True ____ data exist in a format that does not lend itself to processing that yields information. Structured Semistructured Unstructured Historical - Unstructured Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data. True False - False A ____ database supports data distributed across several different sites. single-user multiuser centralized distributed - distributed Initially the files within a computer file system were similar to manual files. True False - True The database structure in a DBMS is stored as a ____. file collection of files set of key/value pairs collection of queries - collection of files End-user data is ____. raw facts about the end-user raw facts of interest to the end-user data about data accurate, relevant and timely information - raw facts of interest to the end-user A verb associating two nouns in a business rule translates to a(n) ____ in the data model. entity attribute relationship constraint - relationship Which of the following is true of business rules? They allow the designer to set company policies with regard to data. They allow the designer to develop business processes. They can serve as a communication tool between the users and designers. They provide a framework for the company's self actualization. - They can serve as a communication tool between the users and designers. A data model is usually graphical. True False - True ____ are important because they help to ensure data integrity. Attributes Entities Relationships Constraints - Constraints A(n) ____ model represents a global view of the database as viewed by the entire organization. external conceptual internal physical - conceptual A(n) ____ is a restriction placed on the data. attribute entity relationship constraint - constraint ____ are normally expressed in the form of rules. Attributes Entities Relationships Constraints - Constraints MySQL is an example of a(n) ____. hierarchical model file system data model relational data model XML data model - relational data model The ____ model uses the concept of inheritance. You Answered relational network object-oriented entity relationship - object-oriented Database designers determine the data and information that yield the required understanding of the entire business. True False - False End-user interfaces require the end user to manually generate SQL code. True False - False A challenge with naming components of a database in a manner that tends toward self-documentation is the solution provider/designer may have a strong need for ____. managerial input standardization conducting interviews data storage space - standardization M:N relationships are not appropriate in a relational model. True False - True A manager and a programmer usually have the same view of the same data. True False - False In a relational database, you cannot implement a ____ relationship between two entities, such as STUDENT and COURSE. Some modeling tools will not allow the designer to draw an Entity Relationship Diagram (ERD) that contains such a