MISC #2 (VIEWS, INDEXES, CARDINALITY, Operands)

Question 1

Views

Answer 1

• a virtual table that is based on the result of a statement
• Views are saved queries, and it shows you data from table(s) based on a specific query
• it exists to offer a way out from repeadtedly typing complex queries by storing a specific query and executing that query when you just referenced the view

Question 2

Materialized View

Answer 2

Require way more space and must be refreshed frequenctly because the query is computer before hand and stored physically as a table in the database.

Question 3

3 different types of Cardinality

Answer 3

• One to many
• many to one
• many to many

Question 4

r

One to many

Answer 4

a relationship that means one record in onetable can be accoicuated with multiple records in another table

Question 5

many to one

Answer 5

a relationship that means multiple records in one table can be associated with a single record in another table

Question 6

many to many

Answer 6

a relationship that means multiple records in one table can be associated with multiple records in another table