1. Data and information (5 points):
1.1. Please use a few sentences to describe the relationship between data and information.
1.2. As a business analyst, why do we need to differentiate data and information?
2. NoSQL database (5 points):
2.1. Please describe the differences between SQL and NoSQL databases.
2.2. Please also explain how a company should make a decision about which one to choose.
3. ERD design (8 points):
3.1. Suppose you design a database to store data about movies and actors. Write down the business rules between actors and movies. Your business rules should be reasonable and precise. (2 point).
3.2. Draw an ERD based on your business rules in 3.1. Have at least four attributes for each entity. Bridge entities (you do NOT need to have four attributes for bridge entities) should be used if needed. PKs and FKs should be identified. Your attributes should follow good naming convention. (6 points).
4. Based on the following ERD, answer the three questions. (10 points)