a) An ER diagram for the system. Show all entities, relationships, cardinalities and optionalities. Also, include all intersection entities. You must use the Finkelstein methodology as per the study book and tutorials.
b) A list of relations (equivalent to Finkelstein entity list). Produce complete relations for all entities and attributes. Show all primary and foreign keys. Include all attributes that are specifically mentioned and all key attributes. You may need to create primary and foreign keys that are not specifically mentioned. You must use the Finkelstein methodology as per the study book and tutorials.
NOTE: We use PART MARKING for the relations and will mark four relations chosen at random.
c) A single SQL statement or multiple statements that create/s the table for the relation LAWYER. All key constraints should be included and data types suitable to each attribute should be chosen.