1. Create table showing all entities, attributes, primary key and one or more foreign keys, as well as with all necessary referential constraints. (40 marks)2. Create ER diagram showing global logical data model. (40 marks)Word processor and Case toolsYou will be modelling the problem using DIA or any other suitable modelling software. In the event you are using alternative software modelling tool, please make sure the lecturer will be able to assess your work with the proper software tool. You could use Microsoft word or any word processor as long as the lecturer could open the soft copy of your document.