Practice Exercises

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.