please solve in R

Design a database to store student personal details, module details, and assessment results for the students taking the Information Systems and Operations Management degree (you can swap this with your own degree if it is different). Implement your tables as data frames. Write code to simulate random test data and use it to populate your database. Ensure you enforce referential integrity. Using your simulated data, create at least two charts showing information on module assessment results.