The incorrect statement about relational databases is that you shouldn't use underscores in table names, as they are commonly used for readability. The power of relational databases comes from linking tables using relationships structured with primary and foreign keys.
The statement that is NOT true regarding tables and relational databases is: 2) Do not use special characters, such as an underscore, in table names. In practice, underscores are often used in table names to improve readability and to separate words.
Relational databases consist of tables that store data in an organized structure of rows and columns. The real power of a relational database is realized when these tables are linked through relationships, which allows for complex queries and data analysis. The links between tables are established using primary and foreign keys, thereby enforcing referential integrity and enabling operations that involve multiple tables such as joins.
This structure provides a systematic way to handle and manage data. Contrary to the incorrect statement, using underscores in table names is a common convention and does not negatively impact the functionality of the database.
In conclusion, underscores are commonly used in table names within relational databases, and therefore option 2 is the incorrect statement regarding the practices of database management.