Week 19

To achieve the 3rd Normal Form relation,  a relation must be 2NF and not contain any transitive partial dependency. In simpler terms, there shouldn't be any non-key attributes that determine another attribute; furthermore, deleting x shouldn't affect y. 3NF is crucial for reducing data duplication and maintaining data integrity.

What is an SQL view? How is it similar to a table? In what ways is it different?

An SQL view is essentially a virtual table containing a query's snapshot. You can still manipulate the data in the view as you would with a regular table. Still, a view can act as a layer of security that one could use to provide access to data to end-users without giving complete access to all the data in the database. A view and a table are both collections of related data organized in tables and columns but a table is essentially what data is stored in initially whereas a view is a snapshot of a query on the table shown as a table.