Required:

• Database Systems: A Practical Approach to Design, Implementation and Management, 4th.Edition, Connolly, Thomas and Carolyn Begg, Addison-Wesley, 2004.
• Oracle Database 10g DBA Handbook, Loney, Kevin and Bob Bryla, McGraw-Hill, 2005.

Recommended:

• Oracle Database 10g: The Complete Reference, Loney, Kevin, McGraw-Hill, 2004.

Week	Topic(s)
1	Introduction, Review of Database Concepts
2	ER Modeling and UML and Transformation
3	ER Modeling and Transformation
4	Normalization
5	Higher Normal Forms
6	B-trees, Hashing
7	Access Methods, Indexes
8	Mid-term Exam, Management and Security
9	Physical Design and Tuning, Distributed Database Design
10	Distributed Database Design and Allocation
11	Data Warehouses, Data Marts, Star Schema
12	Warehouses, OLAP, Data Mining
13	Data Mining, Remote Database Access with 3GLs
14	Remote Database Access
15	Final Exam

The student should be able to:

1. Understand the advantages and disadvantages of using a database management system and professional design tools. II III IV VII IX XI XII
2. Use a formal language of data definition and data manipulation to accomplish various administrative tasks. III IV VII XI
3. Recognize the components of alternative database models and appreciate how implementations as systems may vary from the relational model. III IV VII IX XI XII
4. Transform a complex conceptual design into a logical data base design and to a physical database design. III IV VII IX XI XII
5. Perform the database administration function. I II III IV V IX XI XII
6. Recognize classic data structuring techniques. I II III IV V IV IX XI XI

Students will:

1. Use professional tools to produce software components and documentation. Technological Literacy Outcome, Transitional Strategy, Active Learning
2. Learn to analyze and solve problems using structured analytical techniques. Technological Literacy Outcome, Active Learning Strategies
3. Use professionally accepted methods and materials in completion of applications. Technological Literacy Outcome, Transitional Strategy, Active Learning

1. Explain the similarities and differences of various data models. C D E
2. Perform advanced database normalization. D E
3. Develop complex Entity-Relationship Models. D E
4. Create data for data warehouses and/or data marts. A C D E
5. Explain the functions of database administration. B E
6. Write programs using query languages to accomplish administrative tasks. A B
7. Use data mining techniques to make associations and predictions. A C
8. Describe solutions to problems associated with distributed database systems. A C E
9. Use the World Wide Web to access databases. A B C E
10. Represent data using the object-oriented model. C E F
11. Describe the concept of binary trees, B-trees, linked lists, and hash tables. A C D E F
12. Explore XML as an alternative database organization. B C D
13. Explain file organizations and access methods. A C F
14. Explain the concept of indexes. A C F

1. Testing Procedures:
   Two comprehensive exams will be given during the course of the semester. Dates will be announced in class and each test will account for 250 points of your final grade -- 500 points total.
   
   
2. Laboratory Expectations:
   Several lab projects will be assigned during the course of the semester. A late penalty may be imposed on any overdue assignment. Individual and/or group projects may be assigned to emphasize practical solutions to database problems. Failure to satisfactorily complete any assigned projects may result in a grade of F for the course. Lab projects will account for 500 points (50%) of your final grade.
   
   
3. Field Work:
   This information, if applicable, will be provided by the instructor in full detail during the first week of class via syllabus supplement.
   
   
4. Other Evaluation Methods:
   This information, if applicable, will be provided by the instructor in full detail during the first week of class via syllabus supplement.
   
   
5. Grading Scale:
   

   93 – 100	A
   88 – 92	B+
   83 – 87	B
   78 – 82	C+
   73 – 77	C
   65 – 72	D
   Below 65	F

1. Attendance Policy:
   Pellissippi State Technical Community College expects students to attend all scheduled instructional activities. As a minimum, students in all courses must be present for at least 75 percent of their scheduled class and laboratory meetings in order to receive credit for the course. [NOTE: No differentiation is noted for excused/unexcused absences. These will be treated as an absence.] (Pellissippi State, 2004-2006 Catalog, page 83)
   
   
2. Academic Dishonesty:
   Plagiarism, cheating, and other forms of academic dishonesty are prohibited. Students guilty of academic misconduct, either directly or indirectly through participation or assistance, are immediately responsible to the instructor of the class. In addition to other possible disciplinary sanctions which may be imposed through the regular Pellissippi State procedures as a result of academic misconduct, the instructor has the authority to assign an F or a zero for the exercise or examination or to assign an F in the course. (Pellissippi State, 2004-2006 Catalog, pages 62-63)
   
   
3. Computer Usage Guidelines:
   College-owned or –operated computing resources are provided for use by students of Pellissippi State. All students are responsible for the usage of Pellissippi State's computing resources in an effective, efficient, ethical and lawful manner. (Pellissippi State, 2004-2006 Catalog, pages 67-70)
   
   
4. Other:
   1. Plagiarism, cheating, software piracy, non-educational use of computer systems and other forms of academic dishonesty are strictly prohibited. A student caught cheating or infracting specific rules will be given a grade of "F" for the course.
   2. Make-up exams: All exams are required, and make-ups will be allowed only in the rarest of cases. In the event of an emergency, notification of the instructor must be made in advance.
   3. It is the student's responsibility to request help from the instructor prior to an assignment's due date.