Weekly Question: 18th Sept

For this weekly question, respond to the two questions below in a few sentences. Try to make it insightful rather than just repeating what you have learnt in class.

1. Give an example where a JOIN statement would be useful. So for example, if you have orders in one table and customers in another table, you would join the order table and the customer table to figure out which customers make which orders.
2. What is the difference between an ERD and a schema