In this course, you will learn about the basic models and capabilities of standard database management systems (DBMS) packages. Included in the course is an overview of database principles, file-level models, data-level models, operation. The course also emphasizes implementation, maintenance and security considerations. You will will study and use methods of DBMS selection and evaluation to implement the design for your proposed database project solution.

Prerequisite : The prerequisite for the course is ITE 115. Students must also be able to read and write at the college level and must have a working knowledge of the WINDOWS environment.

Upon completion of this course, students will be able to:

• Define essential database vocabulary
• Effectively apply data relationships and normalization techniques
• Describe the transformation of database design from a conceptual user model (e.g., an ERD) to a normalized relational model
• Explain and apply Structured Query Language (SQL) in a database environment
• Describe the methods available for minimizing DBMS risks and security failures
• Characterize the roles and responsibilities of the Database Administrator (DBA)
• Apply fundamental database concepts to an information systems problem

Possible Assignments Include: (Subject to change each semester. The actual assignments are available in the Syllabus in the Blackboard course site on the first day of classes.)

Your final grade may be based on the following scale.

There are 3 proctored exams and 2 take-home exams in this course.