Please enable JavaScript.
Coggle requires JavaScript to display documents.
Normalisation, Functional Dependency, View, Normalisation - Coggle Diagram
-
-
View
Benefits of Using Views
-
-
Computed columns
Views can create computed columns, which are computed on the fly
CREATE VIEW
Create a view of specific columns, combine data from tables
-
Normalisation
-
Normal Form
1NF
Table format, no repeating groups/multivalued attributes, and PK identified
-
-
-
-
-
A technique that enables the creation of well structured relations that support the data requirements of an enterprise