Quiz
Instruction
Welcome to our quiz! This is an additional part where you can check how much you remember from the whole course. We've prepared a few challenging tasks for you. Ready, steady... go!
Exercise
A local publishing house organizes a competition for the best short story. They need a table to store information about the entries they get.
Create a table entry with the following columns:
idan integer number,title- a text of up to 250 characters,date_submitted- date & time when the entry was submitted,category- a code of exactly 5 characters,summary- a longer text field,is_anonymous- a yes/no field used to determine whether the author wants to be anonymous.
The column id is the primary key.
Stuck? Here's a hint!
Do you remember the various kinds of data types we used? They were discussed in detail in Part 2. Take a look back if you can't recall them!
