information systems and technology

you will find the question in the next picture

NOTE:PLEASE SOLVE IT WITH ONLY (MICROSOFT ACCESS )

Student Portal: The system administrator of the industrial engineering department at EMU want to create an information system that allows students to check their grades in different courses, calculate their total grade or CGPE, and shows the courses credits and fees. The system shows also the financial data of each student, including their scholarship and credit. Each student has a unique student number Each student can take many courses in one semester. Many students can be registered in the same course in a given semester. Each student has one account for financial data. Questions : 1- Create An E-R diagram for this information system. A. Identifyting Entitites B. Attributes C. Identifying Relationships D. Drawing the ERD 2- Which entities are in 2NF, which ones are in 3NF (normal form) ? 3. Draw the ERD that you will use un physical design phase. (20 minutes) (represent the relationships to be done in Ms Access)