Table of contents: Contents Table of contents: 3 Entity Relationship Diagram 4 Part A: Analysis 5 1. Client Business Rules 5 2. Assumptions Made 5 3. Naming Conventions 5 4. Data Types Chosen 5 Part B: Testing Queries 6 B.6.1 Workshop Enrolment List 6 B.6.2 Workshop Count List 6 B.6.3 Student Transcripts 6 B.6.4 Student Assessment Totals 6 Entity Relationship Diagram DATA2001- Assessment 2 - Entity Relationship Diagram (ERD) Part A: Analysis 1. 1. Client Business Rules 2. Assumptions Made 1. 3. Naming Conventions To keep consistency, the database will use strict naming conventions that will allow easy implementation and maintenance of the database when completed. The following conventions apply: Etc. Data Types Chosen For each table, please specify the data types chosen and relevant contexts for all attributes: TABLE NAME1 Attribute Primary key Foreign Key Default NULL Attribute1 INT(8) Yes No No No Data Type B.6.1 Part B: Testing Queries Workshop Enrolment List Query: Paste your actual query here (not a screenshot) Result: Paste a screenshot of your query results here. (Hint: Snipping tool in Windows may help) B.6.2 Workshop Count List Query: Result: B.6.3 Student Transcripts Query: Result: B.6.4 Student Assessment Totals Query: Result