Question 1

The most efficient tables in a relational database in terms of storage space have no redundant data and very few null values.

Accepted Answer

Redundant data and null values take up unnecessary storage space in a relational database, so tables with minimal redundancy and null values are more efficient in terms of storage space.

Question 2

When moving from logical data models to physical data models,you should update your CRUD matrix.

Accepted Answer

When moving from logical data models to physical data models, the CRUD matrix should be updated to reflect changes in data structures and relationships.

Question 3

One process when considering data storage design is to move from physical data models to logical data models.

Accepted Answer

The process typically moves from logical data models to physical data models. Logical models outline the structure without being tied to a specific database technology, while physical models are designed based on the specifics of the database system being used.

Question 4

Transaction processing systems and decision support systems will generally have very different data storage needs.

Accepted Answer

Transaction processing systems are optimized for efficient and fast processing of large volumes of operational data while decision support systems require access to large amounts of historical and current data for analysis and decision-making, which may include unstructured or semi-structured data. Therefore, they will have very different data storage needs.

Question 5

When converting a logical ERD into a physical data model,you will want to specify both primary keys and international keys.

Accepted Answer

When converting a logical ERD into a physical data model, you specify both primary keys and foreign keys, not "international keys."

Question 6

A CRUD matrix shows exactly how data are used and created by major processes in the system.

Accepted Answer

A CRUD matrix (also known as a CRUD chart) is a tool used in software development that illustrates the Create, Read, Update, and Delete operations for data within a system. It helps to identify how data is used and managed by major processes in the system.

Question 7

The two primary ways to optimize a relational database are (a)for storage efficiency and (b)for using the smallest amount of space.

Accepted Answer

The two primary ways to optimize a relational database are for performance and data integrity, not storage efficiency or smallest space usage. Storage efficiency and smallest space usage can be secondary considerations for optimization.

Question 8

Maria is working for the Minneapolis Dance Troop (MDT)and wants a database that can support text,numbers,video,and audio.She will probably select the multidimensional database format.

Accepted Answer

Maria would likely choose a multimedia database, as it is specifically designed to handle various data types including text, numbers, video, and audio, unlike a multidimensional database which is optimized for analyzing data.

Question 9

Systems to support decision making generally need to update data frequently with a large volume of data.

Accepted Answer

The answer of Systems to support decision making generally need...

Question 10

Brian wants an e-commerce system to be able to do a lot of rapid processing - like search for particular keywords in documents;return the price of an item;update quantities in the shopping cart.He is probably building an Expert System.

Accepted Answer

Brian is likely building a transaction processing system, not an expert system. Expert systems are designed to provide expert-level advice or decision-making based on rules and knowledge specific to a particular domain or industry.

Question 11

MIS stands for Management Information Systems.

Accepted Answer

MIS is the abbreviation for Management Information Systems.

Question 12

When working on a major project,project teams will always select and stay with only one database format for consistency of development and use.

Accepted Answer

Project teams may start with one database format but can switch to another or use multiple formats concurrently if it better suits the project's evolving needs, scalability, performance requirements, or integration capabilities.

Question 13

When changing from logical data models to physical data models,you will want to change the attributes of the logical ERD to fields in the physical ERD.

Accepted Answer

In the physical data model, the attributes of the logical ERD become fields in the database. The physical model represents the actual implementation of the database using specific database technologies and data storage methods.

Question 14

Technical feasibility might play a major part in selecting a database system (for example,if a project group and development group are very familiar with relational databases,it might be best to stay with relational databases).

Accepted Answer

Technical feasibility refers to the practicality of implementing a particular technology or solution. If a project group and development team are already familiar with a particular type of database system, it may be easier and more efficient to continue using that system rather than switching to a new one that requires significant training and learning. Therefore, technical feasibility can be an important factor in selecting a database system.

Question 15

Rachel wants aggregated data like find the number of banking customers who have savings accounts over $100,000 and home mortgages with her bank.She probably wants to use a Decision Support System.

Accepted Answer

Rachel's goal of finding the number of banking customers with specific account types and balances is best served by a Decision Support System (DSS) which can process and analyze large amounts of data to provide her with the aggregated information she needs.

Question 16

Although TJ did a lot of work normalizing the database so that it is in third normal form (3NF),he may want to 'denormalize' it so that access might be faster.

Accepted Answer

Denormalization is a technique used to increase query performance by adding redundant data back into the database, which may violate 3NF, but allows for faster access to data.

Question 17

The best design for accessing data faster is generally the most efficient storage as well.

Accepted Answer

The best design for accessing data faster often prioritizes speed and may use more resources or less efficient storage methods (like indexing or caching), whereas the most efficient storage design aims to use resources most effectively, which can sometimes compromise access speed.

Question 18

CRUD stands for 'create','read','update' and 'delete'.

Accepted Answer

CRUD is an acronym for the basic operations that can be performed on a database or data structure, which are create, read, update, and delete.

Question 19

Sanjay is creating a screen form that interfaces with a relational database.He should use the median (middle)value in the database as his default value - as that will make it easier for the users to move up and down in the table.

Accepted Answer

Sanjay should use the average or the most often-used value as the default value, not the median. Using the median as the default value may not be as helpful for the users to navigate the table.

Question 20

When changing logical data models to physical data models,you will want to change entities to tables or files.

Accepted Answer

Entities in a logical data model are equivalent to tables or files in a physical data model. Therefore, when changing from a logical data model to a physical data model, entities should be transformed into tables or files.

Quiz 11: Data Storage Design