.An ERD (logical schema) of your proposed idea using an ERD that contains at least 7-8 Entities in it. It also indicates key attributes for each entity set and the cardinality of each relationship. It also Indicates participation for each entity related to each relationship. A diagram (physical data model) clearly shows , Each table, Attributes and Constraints including data types and Keys.