Question: how to design a relational database schema?
Answer: Step 1: Define the Purpose of the Database (Requirement Analysis) ...  Step 2: Gather Data, Organize in tables and Specify the Primary Keys. ...  Step 3: Create Relationships among Tables. ...  Step 4: Refine & Normalize the Design.