Select the Course Number to get further detail on the course. Select the desired Schedule Type to find available classes for the course. The Schedule Type links will be available only when the schedule of classes is available for the selected term. |
CNIT 27200 - Database Fundamentals |
Credit Hours: 3.00. A study of relational database concepts. These concepts include data design, modeling, and normalization; the use of Structured Query Language (SQL) to define, manipulate, and test the database; programmatic access to a database and practical issues that database developers must handle. Typically offered Fall Spring Summer.
0.000 OR 3.000 Credit hours Syllabus Available Levels: Undergraduate, Graduate, Professional Schedule Types: Distance Learning, Laboratory, Lecture, Practice Study Observation All Sections for this Course Offered By: College of Technology Department: Computer Information Tech Course Attributes: Credit By Exam, Lower Division May be offered at any of the following campuses: Northwest- Westville West Lafayette Anderson Columbus Kokomo Lafayette South Bend Learning Outcomes: 1. Explain the principles and characteristics of good relational database design. 2. Design entity relationship models for a business problem domain. 3. Build data models that solve business problems. 4. Compare and contrast components of Structured Query Language (SQL). 5. Write SQL queries in a multiple table environment. 6. Understand the concept of database transactions, and demonstrate the proper use of commits and rollbacks. |