There are a lot of books on relational database design. Some of them are very mathematical. But for small applications, just some rules must be known.
- All tables are at least in the third normal form
- All PKs are integers (and then all FKs)
- Null values are not allowed
- Applications have access to views (not to tables)