This course is about the application of relational database techniques in the context of Accounting Information Systems (AIS). This project-oriented course aims to provide AIS students comprehensive training in practical IS database analysis and design. Advanced topics and techniques of accounting database systems, including SQL, transaction, accounting database administration and Internet-based database applications will be reviewed. The data warehousing techniques for modern AIS will also be introduced. The course work includes a team project in which students will design and implement Internet-based database applications to model and solve real business problems. Students are required to write systems analysis and design reports and present their reports at the end of the course. In-depth tutorials on commercial database management systems and applications will be given as well.

Upon successful completion of this course, students should be able to: 1. Apply the fundamentals of database theory in a practical accounting situation; 2. Gain familarity in the specification of accounting databases in Entity-Relationship Model; 3. Build and implement relational databases models for accounting-related systems; 4. Gain hands-on experience in designing and implementing real-world accounting-related systems.