Create a List of Tables Create a list of tables including unique tables and relationship tables. See Figure 14-12 in the Simkin textbook or the layout we used in class to complete this part. For each table, be sure to include the primary key, any foreign key(s), and other attributes based on the data collected by the firm as shown in the table below. Data Collected

Services Description, rate per hour Bank Account number (GL), account type (checking or savings), beginning balance Clients Client name, client type, address, city, state, zip code, phone number Employees First name, middle initial, last name, address, city, state, zip code, phone number Engagements Engagement number, service type, client, employee(s), date started, date completed, billable hours by employee Cash Receipts Cash receipt number, engagement number, employee, client, date, amount received

Keep in mind that you may need to add attributes to this list of data collected. For example: for the Service table, you would need a primary key such as service number or service ID.