Consider that you are designing a database for a pharmacy. Define two tables (i.e. two things that a pharmacy would want to keep information about.) Define the fields (i.e. columns) in each table (i.e. what do we want to know about these two things) Define the primary keys of these two tables. Link these two tables by using a foreign key