MSCI 245Databases and Software Design
- Faculty
- Engineering
- Last listed
- Spring 2024
No longer offered. It was in Waterloo’s course catalog since at least Winter 2020 (as far back as Open Data goes) to Spring 2024 and last ran in Spring 2024. It isn’t in the 2024–25 or later calendars.
When it ran
- S20
- F20
- W21
- S21
- F21
- W22
- S22
- W23
- S23
- W24
- S24
Ran in 11 terms, Spring 2020 to Spring 2024.
This course introduces students to software systems that use a relational database management system (RDBMS) for data storage. One focus of this course is multi-tier software architectures, such as websites and other software as a service (SaaS) systems. Students will learn common software concepts such as design patterns, and modelling processes, objects, logic, and data. Students will learn how to organize data in a RDBMS and how to interact with the database using the structured query language (SQL). [Offered: S]
Requirements, as last listed
Prereq: MSCI 240; Level at least 2B Management Engineering. Antireq: CS 338, 348
In today’s calendar
Discussed on r/uwaterloo
13 posts and comments in 11 threads mention MSCI 245, January 2021 to December 2024. Quoted word for word, newest first; each reply sits under the post and the comment that started its branch. Search r/uwaterloo for newer posts.
Spring 2024
easy vs usefulelectives for first years? 10 points, 4 comments
“I'm conflicted between choosing an elective that is actually useful to me versus a bird course that will lighten up my workload. …”
u/ConsequenceNo3618: “… Full-stack design courses MSCI 245/342 were the most useful for me - you can try to audit them but idk if they'll allow it”
Management Eng students, it you had the opportunity to go to UTSG CS instead, would you do it? 10 points, 55 comments
“Please explain why you would or would not. UTSG CS = University of Toronto St. George campus, Computer Science”
u/ConsequenceNo3618: “Management Eng is not that close to a CS program so I don't think it's a meaningful comparison As a 4th year MGTE student, I would definitely go for UTSG because I feel it has more freedom in course …”
u/ConsequenceNo3618: “Yes, most of us go into SWE; not because we want to, but because there's few other career paths for us We don't have that many CS/SWE courses, and the ones that we do have are pretty watered down (MSCI 121/240/245/342). You'll learn the fundamentals but you won't go in-depth”
u/1000Ditto: “I am too unknowledgeable about it, but would highly consider it - my nature better fits eng courses in general simply, if you want cs background then take cs, if you want engineering background, look …”
u/ConsequenceNo3618: “… The 75% is between the intro course (MSCI 121) and the data structures course (MSCI 240) \[not the database course MSCI 245\] MSCI 121 is very introductory so don't worry about it. …”
Winter 2024
What has been your Co op experience for Management Engineering at U Waterloo? 1 point, 6 comments
“Heading there in Septmeber from out of province and not sure what to expect. How hard is it to secure co ops, the process, etc?”
u/nyephe: “… For example, MSCI 245/342 teach web and full-stack development The process starts in the first weeks of classes. Most students will search on the school's job board, WaterlooWorks (WW). …”
Can't SSH into Linux Host Servers from Anywhere other than On Campus: 1 point, 9 comments
“Title. Basically, for CS246 whenever I try to SSH into the linux school servers from any network other than "University of Waterloo" on campus, it fails in VSCode. …”
u/suiyui: “When I did MSCI 245, we had to VPN into the school's network through Cisco before we could SSH. But even then, there were lots of technical issues and the server kept crashing”
Fall 2023
which course is the most useful/useless of ur major? 24 points, 44 comments
u/suiyui: “Useful: MSCI 342/245 - Full stack development MSCI 240 - OOP MSCI 446 (TE) - Machine learning Useless: Everything else, especially the non-MSCI courses”
Resume Building Courses 7 points, 2 comments
“List some courses preferably that requires no prerequisites or does, that teaches you software or any skill that would boost a resume. …”
u/suiyui: “… Should be easy to override unless class hits capacity - MSCI 245/342 Project based Full stack with Node/React - ECE 452 Software architecture and design - MSCI 446 Machine learning - MSCI 343 Human computer interaction for UI/UX design Difficult but rewarding - CS 341 Algorithms …”
Winter 2022
Management Eng v.s. Computer Eng v.s. SYDE? 0 points, 9 comments
“This might not be the place to ask this question, sorry if it isn’t. I’m interested in a software engineering/developer career. …”
u/wagwanm0n: “Easiest to get into management and prospects for software jobs are great. Good amount of coding courses too”
u/Alternative_Way_3534: “… Databases and Software Design (MSCI 245) 4. Software Engineering (MSCI 342) 5. Human Computer Interaction (MSCI 343) 6. Search Engines (MSCI 541) 7. Intro Machine Learning (MSCI 446) 8. Analytics and User Experience (MSCI 543) 9. Advanced Machine Learning (MSCI 546) 10. …”
Fall 2021
What is your least favourite course? 31 points, 55 comments
u/queendbag: “Msci245 it’s the prof not the course tbh.”
Spring 2021
Failed a course spectacularly, need advice! (Kinda urgent) 17 points, 19 comments
“I'm in engineering (2B) and I've failed a course rather spectacularly, such that no matter what I do in the course I can't get over 32 (Due to unironic crippling depression, bad time management, …”
u/Lone_Wolfffff: “What course is this for?”
u/Current-Highlight189: “… If it is MSCI 245, you don't have a final in that course. If you don't mind a lower mark on your transcript, don't do the project. Put your effort towards your other courses. …”
u/1000Ditto: “msci 245 is like being waterboarded every other day, fuck that shit”
Job Opportunities and Workload: SYDE, Tron, and Management 1 point, 9 comments
“I have recently been thinking of switching from mechanical engineering and am deciding between SYDE, Tron, and Management. …”
u/wagwanm0n: “Management does have a good number of coding courses”
u/original-random: “… Core: MSCI 121 Intro to programming (Java) MSCI 240 Algorithms and Data Structures MSCI 245 Databases and Software Design (build web apps by yourself) MSCI 342 Principles of Software Engineering (build web apps as a team for a client) MSCI 343 Human Computer Interaction MSCI 436 …”
Winter 2021
Admissions / High School Megathread (Fall 2020) 316 points, 7,386 comments
“I think we lost track of the old one somewhere, and this is to also help reset the expiry date (these threads archive after six months) Engineering Admissions Blog: https://theroadtoengineering.com/ …”
u/Kbreadman: “\++I applied to management engineering because I love the idea of streamlining processes + working with data and using it to solve problems or draw conclusions, etc. …”
[deleted]: “… Looks like a mix to me of mechanical engineering (MODs, Thermo, Mechanics, Material Science), software (MSCI 101, 240, 245, 342), and more vague systems-y stuff (MSCI 211,331,334?). …”
Check it elsewhere
- Undergraduate Calendar, 2023–24Its last calendar entry, on ucalendar
- Course outlinesSyllabi from past terms (UW login)
- UW FlowStudent ratings and reviews
- WClassesPast sections back to 2004, and who taught them