Databases and Information Systems Management Systems

Question: Discuss about the Databases and Information Systems for Management Systems? Answer: a: The system is expected to identify the students who are under risk of being withdrawn from the school due to poor academic performance rather than completing their course of studies. Hence, the system must record and process the following data, (Gorman, 2014) Personal records of the students, including their names, date of births, address, contact details and so on. Details of the courses enrolled by the student. Like course name, course fees, starting date, duration and so on. Details of the performance of the students in the enrolled courses. For example, credits achieved, results and so on. Weekly progress details for each enrolled course, in terms of term results, attendance and attentiveness, timely delivery of assignments and so on. It will also include details of the assignments, final project of each course and for each student enrolled in a course. b: The sources of the student, course and the performance data can be fetched from the other information systems and from different feedback forms filled by instructors, student record files from the university, performance tracking system and so on (Haav Kalja, 2013). c: The logical database design is, References: Gillenson, M. L. (2011). Fundamentals of Database Management Systems. John Wiley Sons. Gorman, M. M. (2014). Database Management Systems. Butterworth-Heinemann. Haav, H.-M., Kalja, A. (2013). Databases and Information Systems II. Springer . Silberschatz, A., Korth, H. F., Sudarshan, S. (2011). Database System Concepts (6th ed.). McGraw-Hill.