Practice Exercises
1
.
Draw a flow diagram that explains how information architects, database designers, data owners, data stewards, database administrators, and data scientists coordinate their activities.
2
.
Research how bad data can result in bad information and why sources impact the quality of the data.
3
.
Draw a diagram of a DBMS architecture that could be used to run a medium-scale website.
4
.
Research and provide a few examples of pros and cons of SQL databases compared to NoSQL databases.
5
.
Which statement is correct?
- The Boyce-Codd normal form is more strict than the fourth normal form.
- The Boyce-Codd normal form is more strict than the third normal form.
- The second normal form is more strict than the Boyce-Codd normal form.
- The first normal form is more strict than the Boyce-Codd normal form.
6
.
Give practical examples of applications where it would be best to use the following: key-value store, document store, column-oriented database, graph-based database
7
.
Use a simple example to explain the difference between hindsight, foresight, and insight. What type of technology can be used to derive each one of these?
8
.
Which Amazon tool would you use to turn text into speech? What are the other tools listed used for?
- Amazon Lex
- Amazon Echo
- Amazon Polly
- Amazon Rekognition
9
.
State a major constituent of informatics.