IT 221 Database Design Using SQL
is an introductory course incorporating both theoretical and practical application of database concepts, design and implementation 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. Through the use of a threaded case study and project teams, students learn how to analyze a business problem, model data flow, create a conceptual Entity-Relationship model of a database to solve the problem and incorporate Structured Query Language (SQL) to develop and maintain the relational database application using modern software tools (Microsoft Visio and Access or other system). This course is applicable toward all certificates and degrees (credit hours 3.0, lecture hours 2.0, lab hours 2.0).