Hired As A Database Consultant To Assist

Solution: ER DiagramSolution: AssumptionsWe are assuming following features of the system:A program consists of coursesA program contains at least one courseA school has at least one program.A course has a term.A student can enroll for only program.A faculty can teach only one course.A catalogue contains information on many programs.Dean is also a faculty of the university.Solution: Class DiagramSolution: Types of business intelligence reports Standard, static reportStandard or static reports are Subject oriented reports. The information contained in such report is defined precisely before creation. The information present in the static report such as student’s profile, course contents would have a fixed layout which is designed by a report designer at the time of report creation. Static reports contain sub reports and have the ability to perform calculations and or implement advanced functions. Static reports can be made available by a request from the end user or are refreshed at regular intervals from a scheduler. These reports are generally made available on a web server or a shared storage. These reports would be particularly beneficial when a history of a particular student or staff members is