ITEC 340

I. Course Title: Database I

II. Course Number: ITEC 340

III. Credit Hours: 3 credits

IV. Prerequisites: ITEC 220 with a grade of “C” or better.

V. Course Description: 

A breadth first introduction to database systems including the relational model, SQL, security, database design, and stored procedures.

Note(s): Applied Learning designated course.

VI. Detailed Description of Content of the Course:

Topics include:

1. Introduction to database concepts
2. Client-server model
3. Database systems and data query, manipulation, and description languages
4. Relational database model and concepts
5. Database design and normalization
6. Web-based database applications
7. Stored procedures and triggers
8. Data security
9. Data integrity and reliability
10. Transactions and concurrency control  
11. Distributed databases
12. Database administration

VI. Detailed Description of Conduct of Course:

Techniques of database design and implementation are discussed and practiced. Students complete various assignments in database management.

VII. Goals and Objectives of the Course:

Students who complete the course will be able to:  

1. Identify the general advantages of a DBMS, including scalability, and identify specific advantages over a file system
2. Use SQL to retrieve, insert, update, and delete data in a relational database
3. Design a logical schema for a set of real world entities and events as modeled by an Entity-Relationship Diagram  
4. Assess, and where necessary normalize, relations as well as identify the limits of normalization
5. Explain the importance of data integrity and data security and assess risks to integrity and security
6. Identify and implement basic integrity rules and application-specific business rules for a given set of relations
7. Develop stored procedures and triggers to implement complex integrity rules and data intensive processes
8. Design databases and database applications which appropriately address security issues
9. Explain and implement transactions and concurrency control
10. Describe DBMS backup and recovery techniques
11. Perform data analysis
12. Students will be able to reflect on how the skills they learn in this class will apply to professional roles.

VIII. Assessment Measures:

Assessments, which may include in-class exams, presentations, homework assignments, projects, labs, and quizzes will be used to measure each student’s performance.

 

Other Course Information: None

 

Review and Approval 

April 1985        Updated                                                F. B. Green, Chair Curriculum Committee
Sept. 1991       Reviewed                                              Allen L. Bures, Chair, Dept of Management
Nov. 15, 1999                                                               Change from INSY 483 to INSY383    
                                                                                    Felix Amenkhienan, Chair,
                                                                                     Dept of Acct, Finance, and Info. Sys.
Sept. 25, 2001   Change from INSY 383 and CPSC 440 to ITEC 340
                                                                                     John P. Helm, Chair
Feb. 2003         Updated                                                 John P. Helm, Chair
Nov. 2003         Updated                                                  Joseph Chase, Chair
Nov. 2010         Updated                                                  Art Carter, Chair

Revised: May 31, 2012

March 01, 2021