Assistive Menu

IT 221 - Database Design

Description:IT 221 is an introductory course on database concepts, design and implementation. This course incorporates both theoretical concepts and the practical application of those concepts through lectures, text assignments, case studies and projects. The course content focuses on the three phases of database design; logical design, physical implementation, and application development. Students will learn how to analyze a business problem, model data flow, create a conceptual Entity-Relationship model of a database to solve the problem and develop the database application using modern software tools. Students will participate in project teams to resolve the final case project. Microsoft Visio will be used as the modeling software and Microsoft Access will be used as the relational database management software in this course. As a second-year course, IT 221 requires that a student possess fundamental computer skills in a Windows environment. This is not an entry-level course.
Credit hours:2-2-3
Applicability towards graduation:
  • Certificate or degree - All Certificates, AAS, ALS
  • Group requirement - Not Applicable
  • Area of concentration - Not Applicable
Offered:Spring

Information Technology Courses

NumberTitleHours
IT 105Information Technology Systems2-2-3
IT 115Windows Fundamentals2-2-3
IT 116Windows Client Operating Systems2-2-3
IT 120Spreadsheet Applications2-2-3
IT 130Word Processor Applications2-2-3
IT 131Programming Logic2-2-3
IT 141Networking Fundamentals2-4-4
IT 151Internet Techniques2-2-3
IT 153Web Development2-2-3
IT 173A+ Computer Technologies2-4-4
IT 205Help Desk Techniques2-2-3
IT 206Operating Systems Support2-2-3
IT 207Software Applications Support2-2-3
IT 210Presentation Graphic Applications2-2-3
IT 220Data Management Applications2-2-3
IT 221Database Design2-2-3
IT 222Structured Query Language2-2-3
IT 230Project Management2-2-3
IT 241Network Routing Technologies2-4-4
IT 242Wireless Networking2-2-3
IT 243Network Switching Technologies2-4-4
IT 244Wide Area Networks2-4-4
IT 245Network Security2-2-3
IT 271Windows Server Operating Systems2-2-3
IT 272Unix/Linux Fundamentals2-2-3
IT 273Managing Windows Networks2-2-3
IT 274Windows Active Directory2-2-3
IT 280Advanced Systems Development3-2-4
IT 282Dynamic Web Development2-2-3
IT 284Web Programming2-2-3
IT 285Systems Analysis & Design2-4-4
IT 290Work Experience Practicum1-10-3
IT 295Workplace Simulation & Projects1-10-3
IT 297Emerging Technologies1-0-1 to 3-0-3