108k views
3 votes
Which is NOT true about the characteristics of a table?

a) Each table row represents a single entity occurrence within the entity set
b) The order of the rows and columns is important to the DBMS
c) Each column has a specific range of values known as the attribute domain

User Bubblez
by
6.6k points

1 Answer

4 votes

Final answer:

The characteristic of a table that is not true is that the order of rows and columns is significant to the DBMS.

Rows can be accessed regardless of order using keys and indexes, while column order must remain consistent as it denotes specific attributes of the entities.

Step-by-step explanation:

The option that is NOT true about the characteristics of a table is b) The order of the rows and columns is important to the DBMS. In databases, the logical order of rows, which represent individual records or entities, does not affect how the data is stored or retrieved.

Database Management Systems (DBMS) use keys and indexes to access data, rather than relying on the order of rows. However, the order of columns must be consistent across rows, as each column corresponds to a specific attribute of the entity.

Additionally, c) Each column has a specific range of values known as the attribute domain is true, because each column (attribute) in a table is designed to hold a certain type of data within a specified range. For example, a 'date of birth' column would have a domain that includes all possible dates. Similarly, a) Each table row represents a single entity occurrence within the entity set is also true.

User Tomislav Markovski
by
7.7k points