Name tables and fields using Hungarian notation, camel case, no spaces, no symbols. Use the smallest possible data type.
books table | ||
book title | ||
word count | ||
release date |
authors table | ||
author website |
series table | ||
series name |
events table | ||
event name | ||
event start date |