Describe how you would design a schema for a database that needs to store and query highly structured clinical trial records.
