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.