How to design of a database (both logical and physical approach) to fulfill business needs of a school's Learning Management System (LMS) based on the below requirements. How to show logical approach by providing E-R model of how the system might look and provide support that it will be efficient given the operations. How to show physical design and provide an outline of strategies and infrastructure to put into place to support the business requirements.

Online student enrollment is 3,000 annually

Access is password protected

There needs to be a feature to create new accounts with different roles

A role (faculty, student, staff) may have access to only certain features

Students may be enrolled in multiple courses

Faculty can teach multiple courses/sections

Student records must be kept indefinitely

Users should have near 24/7 access