In this part of the course, we're going to work with a website for game lovers. The website enables users to add new games which they find in stores and provide basic information about them.
Because the content of the website is provided by its users, there are some problems: some games occur a few times, some data have negative values etc. We need to implement the proper mechanisms to prevent such situations. We'll start off with board games.
Take a look at the example code. Pay attention to the new elements: UNIQUE
, NOT NULL
, CHECK
, DEFAULT
. Try to guess what they mean. We'll explain everything in great detail in this part of the course. When you're done, press the Next exercise button to continue.