Information Technology 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:
- Introduction to database concepts
- Client-server model
- Database systems and data query, manipulation, and description languages
- Relational database model and concepts
- Database design and normalization
- Web-based database applications
- Stored procedures and triggers
- Data security
- Data integrity and reliability
- Transactions and concurrency control
- Distributed databases
- 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:
- Identify the general advantages of a DBMS, including scalability, and identify specific advantages over a file system
- Use SQL to retrieve, insert, update, and delete data in a relational database
- Design a logical schema for a set of real world entities and events as modeled by an Entity-Relationship Diagram
- Assess, and where necessary normalize, relations as well as identify the limits of normalization
- Explain the importance of data integrity and data security and assess risks to integrity and security
- Identify and implement basic integrity rules and application-specific business rules for a given set of relations
- Develop stored procedures and triggers to implement complex integrity rules and data intensive processes
- Design databases and database applications which appropriately address security issues
- Explain and implement transactions and concurrency control
- Describe DBMS backup and recovery techniques
- Perform data analysis
- 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