Design a conceptual data model - make an Entity-Relationship diagram - and then use that and the data itself ... so it is complete and has all the data in it so you'll be ready to write SQL Queries ...

-- NOTE! If you have used non-SQL datatypes in your design, you will have to change these here. -- Modify this code to update the DB schema diagram.