1. The third normal form is a concept in normalization that helps to eliminate unnecessary data and "entanglements" between table columns. Every column in a table that is not a key must only rely upon the table's primary key in order to maintain data integrity, less redundancy, and a more straightforward database. Normalizing tables is especially important for ensuring that queries are more efficient and faster, as well as for future scalability of the database.
2. An SQL view is an "abstract" table that is temporarily created in order to help users analyze data. Some similarities to a table include: the ability to query, columns and rows, and ability to join them together. A key difference is that, whereas a table is physically stored, the view lacks persistence and is only temporarily created. Another difference is that views lack indexes and constraints, whereas tables are able to support them. Views are also typically not able to be updated unlike tables.
No comments:
Post a Comment