Table of Contents
When the same attributes in related data files have different values this is called data?
Chapter 6 Question Answer When the same attribute in related data files has different values, this is called data: Inconsistency In associations, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards. False.
What occurs when the same data is duplicated in multiple files of a database?
Data redundancy occurs when the same piece of data is stored in two or more separate places and is a common occurrence in many businesses.
Which of the following enables users to view the same data in different ways?
Multidimensional analysis enables users to view the same data in different ways using multiple dimensions.
Which tool enables users to view the same data in different ways using multiple dimensions?
Online Analytical Processing (OLAP) supports multidimensional data analysis, enabling users to view the same data in different ways using multiple dimensions, for example: How many dishwashers were sold in the East in June.
When the same attribute may have different values is called?
When the same attribute in related data files has different values, this is called data. inconsistency. A database record is a grouping of characters into a word, a group of words, or a complete number.
Which of the following best illustrates the relationship between entities and attributes Group of answer choices?
Question: The relationship between entities and attributes is best illustrated by the entity PRODUCT with the attribute PURCHASE.
What is the degree of the above relation?
Degree: The number of attributes in the relation is known as degree of the relation. The STUDENT relation defined above has degree 5. Cardinality: The number of tuples in a relation is known as cardinality.
Which refers to the duplication or the repetition of data?
Answer: Duplication and repetition of data is known as Redundancy.
How can storing the same facts in different computer files potentially affect the integrity of the data?
How can storing the same facts in different computer files potentially affect the integrity of data? The redundant data stored in multiple files can become inconsistent when information is updated in one file and not in other files where it also resides; Violates the integrity of the data.
Which of the following best describes the importance of creating an accurate data model for your business’s database?
Which of the following best describes the importance of creating an accurate data model for your business’s database? Critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve.
What is primary key in relational DBMS?
A primary key is a column or a set of columns in a table whose values uniquely identify a row in the table. A relational database is designed to enforce the uniqueness of primary keys by allowing only one row with a given primary key value in a table.
When an organization has inconsistent duplicated data it is said to have an <UNK> Group of answer choices?
Occur as entities at one organizational level create information systems that meet only their particular needs. Duplication of data which leads to data inconsistency. When an organization has inconsistent -duplicated data, it is said to have a -data integrity problem.
Which of the following gives an accurate description of a data model?
Which of the following gives an accurate description of a data model? It is a logical representation of the data in a database that describes the data and relationships that will be stored in the database. Which step is NOT required in transforming a data model into a relational database design?.
Which of the following is a popular technique for designing relational databases?
Which of the following is a popular technique for designing relational databases? An entity-relationship (ER) diagram represents primary database elements in a graphical form. A circular reference in a spreadsheet is a powerful and useful situation.
Which wildcard matches a single character in the same position as the wildcard?
Examples of wildcard characters Character Description * Matches any number of characters. You can use the asterisk (*) anywhere in a character string. ? Matches a single alphabet in a specific position. [ ] Matches characters within the brackets. ! Excludes characters inside the brackets.
Is it possible for several attributes to have the same domain?
An attribute always has a domain associated with it. This domain gives the possible values for that attribute. Two or more attributes can be defined on the same domain .
Can two entities have the same attributes?
1 Answer. It is ok to have tables with the same attributes.
What is the difference between composite attribute and multivalued attribute?
Most attributes are atomic attributes. Multivalued A multivalued attribute may have one or more values for a particular entity. Composite Composite attributes are not atomic because they are assembled using some other atomic attributes.
Which of the following best describes a difference between an attribute and a benefit of a product?
What’s the difference between an attribute and a benefit? An attribute is simply a feature of the product such as its easy-open package, special formulation, or new lower price. A benefit is what consumers will receive or achieve by using the product, such as convenience or use.
Which of the following is a device that acts as a connection point between computers and can filter?
Most networks also contain a switch or a hub acting as a connection point between the computers. Hubs are very simple devices that connect network components, sending a packet of data to all other connected devices. A switch has more intelligence than a hub and can filter and forward data to a specified destination.
Which model can be used to analyze the direct and indirect expenses to help firms determine how much they will need to spend on specific technology implementations?
The total cost of ownership (TCO) model can be used to analyze these direct and indirect costs to help firms determine the actual cost of specific technology implementations.
What is an attribute in a relation?
An attribute is a name paired with a domain (nowadays more commonly referred to as a type or data type). An attribute value is an attribute name paired with an element of that attribute’s domain, and a tuple is a set of attribute values in which no two distinct elements have the same name.
Which of the following represents degree of relation?
The answer is (C) Cardinality. Explore more such questions and answers at BYJU’S.
Which represents the degree of relation?
The degree of a relationship is the number of entity types that participate(associate) in a relationship. By seeing an E-R diagram, we can simply tell the degree of a relationship i.e the number of an entity type that is connected to a relationship is the degree of that relationship.
What refers to duplicating data?
Duplication of data is called data redundancy. Data redundancy occurs when the same piece of data is stored in two or more separate places and is a common occurrence. Data redundancy can be found in a database, which is an organized collection of structured data that’s stored by a computer system or the cloud.
Is data redundancy and data duplication the same?
Data redundancy is what happens when aspects of data is repeated – or duplicated – across a database. With data-deduplication you need only identify and securely back up what would otherwise be the same data repeated tens, hundreds or even thousands of times, once.
Which of the following can be termed as repetition of data?
Repetition of data is called Redudancy.
