Appendix C for relational database design basics and Normalization rules). Figure B-1 shows ACME tables and relationships between them.
Figure B-1: ACME database schema