Appendix:http://i.imgur.com/kb6vFPU.png.http://i.imgur.com/uq0tiB5.png.Using the

Appendix:http://i.imgur.com/kb6vFPU.png.http://i.imgur.com/uq0tiB5.png.Using the information pictured in the links above:.1. Explain what the relevant entries are and how you would assign attributes to them.2. Explain what the primary key would be for each entity3. Explain to me how you would establish relationships and relationship rules between entities.4. Produce an Entity-Relationship Model to demonstrate the relationship.5. Add foreign key/s to the relevant entity/entities to enable the relationship to be established….The requirements for the work to be a pass:Candidates will need to provide evidence to demonstrate their Knowledge and/or Skills by showing that they can: extract key information needs from source documents and produce design notes detailing relevant data to be stored in a relational database. Design notes will include:The resulting relational database should comprise three tablesThe tables should include: