SNHU IT-235: Database Design
IT-235 teaches relational database design from requirements: entity-relationship diagrams in Crow's Foot notation, normalization, and translating a business scenario into tables and relationships. The multi-part final project produces a complete database design package for a business case.
Fennie is independent and not affiliated with Southern New Hampshire University. This is an unofficial study guide.
What makes it hard
Unlike DAD-220's hands-on SQL, IT-235 is mostly design thinking, and normalization is the wall. Students can follow the 1NF/2NF/3NF definitions but stumble applying them to a messy real scenario, and ERD assignments lose points to relationship and cardinality choices that seem small but cascade through the whole design.
What you'll cover
- • Relational database concepts
- • Entity-relationship diagrams (Crow's Foot)
- • Entities, attributes, and relationships
- • Normalization (1NF, 2NF, 3NF)
- • Translating requirements to schemas
- • Design documentation
The IT-235 study guide
How to study for SNHU IT-235, step by step.
- 1
Practice ERDs beyond the assigned minimum
Reading an ERD and drawing one are different skills. Take small everyday scenarios (a library, a gym) and diagram them until cardinality choices feel obvious rather than arbitrary.
- 2
Learn normalization by fixing bad tables
Don't memorize the normal-form definitions; take a deliberately messy table and walk it to 3NF, naming the violation at each step. That's exactly what the assignments and the final project ask you to do.
- 3
Interrogate the business scenario like an analyst
Most design mistakes come from misread requirements, not bad technique. List the nouns and the rules in the scenario before drawing anything; entities and relationships fall out of that list.
- 4
Build the final project as the term goes
The design package assembles skills in the order the course teaches them. Drafting each section in its module week turns the final submission into assembly rather than a deadline scramble.
Today
Today's IT-235 plan
What a Fennie Daily Plan looks like for IT-235. Yours is built from your own syllabus and adapts every day to your deadlines and progress.
First plan free, no card required. Fennie is independent and unaffiliated with your school.
FAQ
Is SNHU IT-235 hard?
It's conceptual rather than technical (no heavy SQL), but normalization and cardinality decisions take real practice to get right. Students who only read the definitions struggle when applying them to a messy business scenario.
What is the IT-235 final project?
A multi-part database design package for a business scenario: requirements analysis, an entity-relationship diagram, a normalized table design, and supporting documentation, built in stages across the term.
IT-235 or DAD-220: what's the difference?
IT-235 is about designing databases (ERDs, normalization, requirements) while DAD-220 is hands-on SQL in MySQL. They complement each other; which you take depends on your degree plan.
More SNHU courses
IT-140: Introduction to Scripting
IT-140 is SNHU's first programming course, teaching Python through zyBooks labs over an 8-week term. It feeds into IT-145 and the CS sequence, and it ends with a final project where you build a text-based adventure game from scratch.
IT-145: Foundation in Application Development
IT-145 follows IT-140 and switches you from Python to Java, covering object-oriented basics: classes, objects, inheritance, and methods. The course builds toward a final project implementing a rescue-animal management system with multiple interacting classes.
IT-200: Fundamentals of Information Technology
IT-200 surveys the main IT domains (hardware, software, networks, data, and security) and how the pieces fit together in organizations. It's an early requirement in SNHU's IT degree, assessed through weekly discussions and scenario-based assignments rather than programming.