Design a relational database schema for a multi-user course registration system, detailing the tables, keys, and normalization choices.