Information Technology 340

ITEC 340: Database I

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

Credit Hours: (3)

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

Detailed Description of Content of 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

Detailed Description of Conduct of Course

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

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

Assessment Measures

Students will be evaluated based on assignments and a minimum of two examinations.

Other Course Information


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