This comparative study assesses three leading database systems: Oracle, Postgres, and MySQL. The aim of this MQP was to create systematic selection criteria for college instructors to assist them in choosing the most suitable database management system for teaching database courses. As many industries rely on databases, the choice of appropriate database systems for the curriculum is crucial to prepare students for real-world applications. Our methodology included a thorough literature review of each system, practical evaluations via installations on multiple operating systems, and syntactical analyses through hands-on projects. The results show unique features of each system, with implications for how they fit within university curricula, depending on course design and goals.

• This report represents the work of one or more WPI undergraduate students submitted to the faculty as evidence of completion of a degree requirement. WPI routinely publishes these reports on its website without editorial or peer review.

Creator

• Luca, Axel
• Pollack, Ethan
• Taylor, Harrison

Subject

• Industry
• Project-Based Learning
• Computing
• Learning

Publisher

• Worcester Polytechnic Institute

Identifier

• E-project-101223-201311
• 114023

Keyword

• Complexity
• Structured Query Language (SQL)
• Comparison
• Database
• Education

Advisor

• Wong, Wilson
• Neamtu, Rodica

Year

• 2023

UN Sustainable Development Goals

• 4 - Quality Education
• 9 - Industry, Innovation and Infrastructure

Date created

• 2023-10-12

Resource type

• Major Qualifying Project

Major

• Computer Science

Source

• E-project-101223-201311

Rights statement

• In Copyright

Last modified

• 2023-12-04