IT 3233 – Database Design and Implementation
A course provides students with the opportunity to develop in-depth knowledge of database design, implementation, and systems development. The course covers data modeling concepts, approaches and techniques, and stages in database development processes (conceptual, logical and physical design). The course also covers methods and approaches used in system analysis and design, including the system development life cycle, prototyping, and rapid application design. To reinforce the course concepts, students will carry out individual and group projects based on real world situations. This course is part of the IT core required for all IT majors.
A minimum grade of “C” in IT 1430, IT 2333, and MATH 2130.
On completion of the course, students will be able to
- Discuss the concepts and fundamental principles involved in systems analysis and design.
- Describe commonly used methods for systems analysis and design including RAD, prototyping, and SDLC.
- Describe the functionalities provided by a database management system and the relational database model.
- Understand data models using enhanced ER diagramming.
- Discuss the role of normalization in database design and normalize a set of tables up to 3rd normal form.
- Use SQL to create, query, and maintain relational tables.
- Perform basic database administration tasks.
Rationale for Inclusion
The course contributes to the following student outcomes and attributes:
(2) Analyze user needs to design IT-based solutions.
(5) Use current computing techniques, skills and technologies.
(a) An ability to apply knowledge of computing and mathematics appropriate to the discipline.
(c) An ability to design, implement, and evaluate a computer-based system, process, component, or program to meet desired needs.
(i) An ability to use current techniques, skills, and tools necessary for computing practice.
(j) An ability to use and apply current technical concepts and practices in the core information technologies.
(k) An ability to identify and analyze user needs and take them into account in the selection, creation, evaluation and administration of computer-based systems. [IT]
(m) An understanding of best practices and standards and their application. [IT]
(n) An ability to assist in the creation of an effective project plan. [IT]