BTM 382: Database Management

 

Classroom and times	JMSB Building room MB 5.245 (Computer lab) Section AA: 5:45 to 8:15 pm Tuesdays Section B: 10:15 to 1 pm Wednesdays Tutorials: To be determined
Instructor	Dr. Chitu Okoli <btm382@okoli.org>; (514) 848-2424 x2985; MB 12.339 Office hours: Tuesdays 1 to 3 pm Tutor: Ribal Atallah
Course websites	The primary course website (here, no login required) is located at http://chitu.okoli.org/btm382. Piazza for announcements and discussion: http://chitu.okoli.org/btm382/piazza. You must check your e-mail registered with Piazza at least once every day. There are some useful guides available for how to make the most of Piazza. Moodle (http://chitu.okoli.org/btm382/moodle) for gradebook, assignment submission, and lecture recordings

 

BTM 382 Database Management provides a comprehensive foundation for designing, building, and working with databases, enabling students to understand and use commercially available database products effectively. The course examines different models of representing data with emphasis on the relational model. Topics include data modeling, database design, queries, transaction management, implementation issues, and an overview of distributed database management systems, data warehouses, databases in electronic commerce, database administration, and knowledge management. Examples are drawn from various functional and operational areas including enterprise and supply chain operations, management, and planning.

Key resources for this course

• Course outline
• Semester schedule
• Register your iClicker (deadline: Wednesday October 5, 2016)
• Textbook website
• Copyrighted textbook materials available in Moodle:
  • Online appendices
  • Datasets
  • Solutions to selected problems in the textbook
  • Publisher’s original PowerPoint slides (for customized slides used for this course, see the semester schedule)
• How to install or access Oracle
• Study resources (exam study guides, practice questions, etc.) are available in Moodle.

 

Other course resources

• YouTube videos displayed in class
• Database links and resources
• Course documents
  • Academic Code of Conduct
  • Honour Pledge
• Other useful information
  • Concordia University Student Parents Centre (CUSP), a student service on campus which assists students with dependent children
  • Careers in Business Technology Management
  • JMSB Career Management Service