Notes for the A3/Q4

Question 1

how do you decide between logical and physical joins?

Answer 1

• physical view actually merges the data and makes a new table; you will see all the fields and rows together as if you are creating one big table
• logically: the data is not merged it is temporary