Lecture, four hours; laboratory, two hours; outside study, six hours. Enforced requisite: course 32 or Program in Computing 10C. Information systems and database systems in enterprises. File organization and secondary storage structures. Relational model and relational database systems. Network, hierarchical, and other models. Query languages. Database design principles. Transactions, concurrency, and recovery. Integrity and authorization. Letter grading.

Review Summary

Clarity
10.0 / 10
Organization
10.0 / 10
Time
5-10 hrs/week
Overall
10.0 / 10

Reviews

    Quarter Taken: Spring 2022 In-Person
    Grade: A-

    This was a great experience. Don't let the past reviews from Spring 2019 scare you; Professor Rosario was extremely helpful and accommodating this quarter. He recorded all the in-person lectures and uploaded them to Youtube no more than a day after each class. His slides are well-written, informative and contain (almost) all of what you need to know to succeed in his class. Nothing like the reviews from 2019.

    That being said though, don't come into Rosario's CS 143 thinking it'll be easy. Getting a B shouldn't be too difficult, but an A is quite challenging and requires lots of effort and patience. The exams are not at all easy as the average on the midterm was 69 and final 59. I felt like the tests were for the most part fair, though some questions on the final required a deep understanding of the material and some ingenuity. On the flip side, the homework is worth 40% of the final grade and graded very leniently, as some parts were graded for completion rather than accuracy.

    Difficulty wise, this iteration of the class definitely seems harder than Spring 2020 or Spring 2021 since we're now back in-person, but definitely easier than Spring 2019. One piece of feedback I'd give for next year's class is to maybe add some harder homework problems that are more in line with the difficulty of the exams. I noticed that Rosario tended to include the easiest problems on his homework assignments, which probably led to a rude awakening for some students on the final.

Course

Instructor
Ryan Rosario
Previously taught
23W 22S

Grading Information

  • No group projects

  • Attendance not required

  • 1 midterm

  • Finals week final

  • 100% recommend the textbook

Previous Grades

Grade distributions not available.

Textbooks

Textbook information not available.