COM SCI 143
Database Systems
Description: Lecture, four hours; laboratory, two hours; outside study, six hours. Enforced requisite: course 111. 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.
Units: 4.0
Units: 4.0
Most Helpful Review
He's an okay professor. He has a somewhat soft voice, so if you sit in the back, you might not hear him. He tends to read off slides, so it might be boring at times. A lot of the material can be done through reading, which is based on a book he wrote himself. If you have a good TA, then it will be helpful to understand the material. His exams and homework are really not that hard, so if you just do the reading, you should be able to get a decent grade.
He's an okay professor. He has a somewhat soft voice, so if you sit in the back, you might not hear him. He tends to read off slides, so it might be boring at times. A lot of the material can be done through reading, which is based on a book he wrote himself. If you have a good TA, then it will be helpful to understand the material. His exams and homework are really not that hard, so if you just do the reading, you should be able to get a decent grade.
Most Helpful Review
Winter 2021 - He's actually ok. He teaches with many examples and slides were easy to follow. He makes sure to answer every question and come up with solutions until the students figured it out. I have one issue with this class however. A lot of students cheated on the midterm and final. Professor noticed a very high average on the midterm (93% average), and decided to make the final harder (90% average). Even with that, many students still cheated because students are really afraid of their grades apparently. Midterm was proctored by the way on Zoom, but many students got on Google doc or some messaging app on Chrome and collaborate throughout the exam. Final was held 24hrs, but the timer will start once you click on it. Still, gives a lot of students opportunities to cheat and collaborate with each other, and the average was still relatively high. It really sucks for people who are trying their best like me, but these cheaters in my class set the curve, and the professor cannot do anything about that, because of how COVID limits a lot of options. It's very unfortunate for those honest students. Homeworks and projects are honestly whatever. For projects, you can definitely learn something out of it and will apply to your future SDE. Make sure you use Google often because you will need to learn a lot by yourself. Homeworks, you can literally write whatever and get full credit. I'm sure by the time you read this, you will most likely be on campus since it is likely that he will teach this class again next year. If you need a professor who teaches well, this professor is that person. I am not saying this professor is awful when dealing with cheaters. I am saying it is very unfortunate this quarter that many students cheated and that the professor cannot make assumptions to go find those cheaters. I can see the professor is pretty much helpless when it comes to academic dishonesty, and I wish I had a much better experience. Your grades do not matter, it's your brain that matters.
Winter 2021 - He's actually ok. He teaches with many examples and slides were easy to follow. He makes sure to answer every question and come up with solutions until the students figured it out. I have one issue with this class however. A lot of students cheated on the midterm and final. Professor noticed a very high average on the midterm (93% average), and decided to make the final harder (90% average). Even with that, many students still cheated because students are really afraid of their grades apparently. Midterm was proctored by the way on Zoom, but many students got on Google doc or some messaging app on Chrome and collaborate throughout the exam. Final was held 24hrs, but the timer will start once you click on it. Still, gives a lot of students opportunities to cheat and collaborate with each other, and the average was still relatively high. It really sucks for people who are trying their best like me, but these cheaters in my class set the curve, and the professor cannot do anything about that, because of how COVID limits a lot of options. It's very unfortunate for those honest students. Homeworks and projects are honestly whatever. For projects, you can definitely learn something out of it and will apply to your future SDE. Make sure you use Google often because you will need to learn a lot by yourself. Homeworks, you can literally write whatever and get full credit. I'm sure by the time you read this, you will most likely be on campus since it is likely that he will teach this class again next year. If you need a professor who teaches well, this professor is that person. I am not saying this professor is awful when dealing with cheaters. I am saying it is very unfortunate this quarter that many students cheated and that the professor cannot make assumptions to go find those cheaters. I can see the professor is pretty much helpless when it comes to academic dishonesty, and I wish I had a much better experience. Your grades do not matter, it's your brain that matters.
AD
Most Helpful Review
Winter 2015 - He's not the greatest lecturer at UCLA, but the material is presented in an easy-to-understand manner. His slides are really good. I thought one of the best parts of the course were the "bunnies" -- mini-quizzes worth nothing that gave concrete examples to in-class material. Condie went through the examples in full depth, and that really helped out with understanding the material. Most students ended up not attending class. It put those who did at a significant advantage. I would recommend attending class, if only to go through the bunnies and midterm in-depth.
Winter 2015 - He's not the greatest lecturer at UCLA, but the material is presented in an easy-to-understand manner. His slides are really good. I thought one of the best parts of the course were the "bunnies" -- mini-quizzes worth nothing that gave concrete examples to in-class material. Condie went through the examples in full depth, and that really helped out with understanding the material. Most students ended up not attending class. It put those who did at a significant advantage. I would recommend attending class, if only to go through the bunnies and midterm in-depth.
Most Helpful Review
Spring 2019 - The final exam just does not make any sense. The professor tries to be like Paul Eggert but fails hardly and makes the class much worse than Eggert's. Eggert's final exam at least allows us to use all notes and books, but professor Rosario only allows one cheat sheet and gives us questions randomly pulled from enormous amount of lecture slides. I don't think the final exam is very helpful as a recap of what we have learned during the quarter and is extremely difficult. I can say it is more difficult than Eggert's. Eggert teaches cs131 pretty good btw.
Spring 2019 - The final exam just does not make any sense. The professor tries to be like Paul Eggert but fails hardly and makes the class much worse than Eggert's. Eggert's final exam at least allows us to use all notes and books, but professor Rosario only allows one cheat sheet and gives us questions randomly pulled from enormous amount of lecture slides. I don't think the final exam is very helpful as a recap of what we have learned during the quarter and is extremely difficult. I can say it is more difficult than Eggert's. Eggert teaches cs131 pretty good btw.
Most Helpful Review
Class: I hear one complain (from other student) about expectation of going to this class that is to learn MySQL ONLY. I can tell you right now that you did not just learn MySQL. You learn to write MySQL query better, setup database schema with various of I/O calculation and theory. Professor: He uses slides, and they are OUTDATED slide. Some of mysql on the slide does not work anymore on the newer version of MySQL. The essential query statement still is the same. He lecture alright, he could put you to sleep if you didn't follow him for one second; because he MUMBLES. However, it is strongly encouraged that you go to lecture, because the book DOES NOT do a good job at all. The textbook is one of bad textbook ever. You might misunderstand something in the text and you definitely will; therefore, it is better to go to class. Projects: The projects are connected dependently, meaning whatever you did wrong on previous project, you might did wrong again on the next one if you don't correct it.
Class: I hear one complain (from other student) about expectation of going to this class that is to learn MySQL ONLY. I can tell you right now that you did not just learn MySQL. You learn to write MySQL query better, setup database schema with various of I/O calculation and theory. Professor: He uses slides, and they are OUTDATED slide. Some of mysql on the slide does not work anymore on the newer version of MySQL. The essential query statement still is the same. He lecture alright, he could put you to sleep if you didn't follow him for one second; because he MUMBLES. However, it is strongly encouraged that you go to lecture, because the book DOES NOT do a good job at all. The textbook is one of bad textbook ever. You might misunderstand something in the text and you definitely will; therefore, it is better to go to class. Projects: The projects are connected dependently, meaning whatever you did wrong on previous project, you might did wrong again on the next one if you don't correct it.