Exercises

  1. Define and give examples of the following database terms: tuple, attribute, relation.

  2. What does it mean to normalize a database design? Describe first, second, and third normal forms.

  3. Reinforce your knowledge by reviewing the basic SQL course at www.sqlcourse.com. It allows you to formulate and run SQL queries online.

  4. Write an SQL statement to display the name and age of everyone in the Person table who is older than 39.

  5. Write an SQL statement to display the name of everyone in the Person table who lives in a NATO country and listens to the Beatles. There are 19 member nations of the North Atlantic Treaty Organization, including the USA, UK, Canada, France, Germany, Greece, and Poland. New members join from time to time, ...

Get Just Java™ 2 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial