Database system architectures, relational data model, relational algebra, relational calculus, SQL, QBE, query processing, integrity constraints (key constraints, referential integrity), database design, ER and object- oriented data model, functional dependence, lossless join and dependency preserving decompositions, Boyce-Codd and Third Normal Forms.

Prerequisites: Computer Science 130A.

4

Units

Letter

Grading

1, 2, 3

Passtime

None

Level Limit

Engineering

College
These majors only cmpsc cmpen cptcs
Jianwen Su
2.0
30 reviews
GIRV 2128
R
17:00 PM - 17:50 PM
38 / 38 Full

PHELP2524
T
17:00 PM - 17:50 PM
37 / 37 Full

NH 1105
R
13:00 PM - 13:50 PM
38 / 38 Full

PHELP1260
R
14:00 PM - 14:50 PM
37 / 37 Full

See All
CMPSC 174A Su J Fall 2023 Total: 95
CMPSC 174A Su J Fall 2022 Total: 17
See All
30
2.0
CMPSC174A . 1 Year, 3 Months Ago

Pretty good class overall. There are only 5 homework assignments and you have at least a week to do each one. Textbook + lectures explain everything you need for assignments. Exams are as easy or easier than homework. Partner project at the end of the quarter, start early if you can because it does take time. Piazza will be your best friend

0 helpful 0 unhelpful
CMPSC174A . 1 Year, 3 Months Ago

I was worried about this class based on Prof. Su's rating here on RMP but I don't know why it's so low. His class isn't the most organized or clear but him and the TAs like Momin Haider were very responsive and accessible outside of class. The exams are straightforward and so were the assignments. Decent class overall.

0 helpful 0 unhelpful
CMPSC174A . 2 Years Ago

I was worried about taking this class, but I'm happy to say it's improved a lot since the last time it was taught. Homeworks were kind of difficult but they're only worth 2% each. Late days are generous. Exams were straightforward and a lot easier than the homework. Project was not too bad, but make sure to start early on it as it is a bit tedious.

0 helpful 0 unhelpful
CS174A . 5 Years Ago

DO NOT TAKE! 2/5 of the material is relevant, the rest is unnecessarily complicated and not important to understanding SQL databases. HWs are difficult and each only account for 2% of your grade. Exams are not graded fairly. Project is incredibly unclear, very time consuming, and graded VERY unfairly. Lectures are boring and unnecessary.

0 helpful 0 unhelpful
CS174A . 5 Years Ago

Literally no one goes to class because his lectures are so useless. The project was so vague and took weeks to complete and I ended up having 3000 lines of code that looked exactly the same. The project was due the last day of dead week so good luck studying for anything else since it takes forever. The TAs are the ones carrying this class.

0 helpful 0 unhelpful
CMPSC174A . 5 Years Ago

1. Lectures are useless, he goes off on random tangents about his research and you learn nothing. 2. HWs take 3/4 weeks to be graded, so there is no learning feedback at all 3. Midterm solutions and hw solutions are posted the day before the final?! Crazy. 4. HUGE, redudant, busy-work project with terrible instructions. 5. A lot of hw. 6. Terrible

0 helpful 0 unhelpful
See all 30 reviews
CMPSC 165A
150 / 150 Full
Artificial Intelligence
Preiss J A
T R
11:00 AM - 12:15 PM
53.6% A
CMPSC 165B
150 / 150 Full
Machine Learning
Guo W
T R
15:30 PM - 16:45 PM
59.7% A
CMPSC 170
100 / 100 Full
Operating Systems
Tao Yang 3.0
T R
09:30 AM - 10:45 AM
39.5% A
CMPSC 174B
73 / 150 Enrolled
Design and Implementation Techniques of Database Systems
Divyakant Agrawal 2.9
M W
09:30 AM - 10:45 AM
55.3% A
CMPSC 176C
47 / 150 Enrolled
Advanced Topics in Internet Computing
Gupta A
M W
12:30 PM - 13:45 PM
61.3% A
CMPSC 177
75 / 150 Enrolled
Computer Security
Kevin Burk 3.0
M W
11:00 AM - 12:15 PM
42.9% A