BTM 382 Outline Fall 2016
|Classroom and times||JMSB Building room MB 5.245 (Computer lab)
|Instructor||Dr. Chitu Okoli|
|firstname.lastname@example.org (#1 way to reach me). However, please use Piazza as much as possible; e-mail me directly only for private matters|
|Phone||(514) 848-2424 x2985|
|Office||MB 12.339 (12th floor of the JMSB Building)|
|Office hours||Tuesdays 1 to 3 pm|
|Tutorials||There will be optional tutorial sessions held throughout the semester where you can physically meet with the tutor to help you with modules, assignments and the project. The times and location will be determined later and announced in class.|
|Course description||This course 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.|
|Prerequisites||COMM 226 or COMM 301|
|Flipped classroom||This course partially adopts a “flipped classroom” approach, which means that you will do most of the reading, exercises and studying outside of class. The learning components will be divided into modules which involve reading the textbook and other specified resources, and doing exercises. You will do all of this outside of class. The classroom time will be used to the maximum to synthesize, review and strengthen the learning modules. Specifically, we will have reading quizzes, lectures about database management theory, review of preceding modules, preview of upcoming modules, and in-class exercises. The instructor and tutor will support your learning outside of class through optional tutorial sessions and the Piazza discussion forum. It is critical that you do all assigned learning modules before class time, otherwise you will not be able to keep up with the class and you will not learn as much as you should.|
|Course websites and e-mail||You will use three websites for this course:
You will be expected to check your e-mail at least once every day, since this is the primary means of communication for this class. I will send announcements through Piazza, so please make sure that your e-mail address registered with Piazza is the one that you check every day. You are responsible to act on all communications sent to that e-mail address.
|Textbook (required)||Database Systems: Design, Implementation and Management by Carlos Coronel and Steven Morris. 12th edition (2017) published by Cengage Learning. ISBN 13: 978-1-305-62748-2
Supplementary materials (online appendices, datasets, and answers to selected textbook problems) are available from Moodle.
|Panopto class recordings||All class sessions will be recorded using the Panopto system. Specifically, the instructor’s computer screen and the instructor’s voice will be recorded. After each class, you may review the session using the Panopto module in Moodle. This is an optional service to aid your learning; there is no course mark associated with it, so you are free to choose whether or not to use it. I have made a tutorial that demonstrates the basic functionality.|
|Map of assessments to learning outcomes||
|Grading policy||The following grading scale will be used for this course:
|Homework assignments||Two homework assignments are designed to give you extended time to work on the material learned in class. These assignments are to be conducted either individually or in pairs of two students maximum (I will explicitly specify in each case). Homework 1 is worth 4% and Homework 2 is worth 5% of the course grade.
Late submissions: Late submissions incur the following penalties: –20% if submitted over 15 minutes after the specified deadline up till the end of the first day that it is late; and an additional –10% for each day late after that.
|Project||The purpose of the project is to provide the opportunity for you to apply the knowledge learned in the class to a business database scenario. The project is to be done in groups of three to five people; I may adjust the group memberships to maintain optimal group numbers and sizes. The project is worth 25% of the course grade.
The project will be submitted in two stages. The ERD (5%) will be submitted, marked and corrected first, and then the SQL sections (20%) based on the corrected ERD will be submitted at the end of the semester.
Each individual must submit a confidential Peer Evaluation. Your individual grade for the group project will depend partially on your group grade, and also on how your peers evaluate you. So, be a team player!
|Reading quizzes and in-class participation||
|Examinations||There will be a midterm examination and a final examination, each worth 30% of the course grade. The specific content, dates, times, and locations will be announced in class. Important Note: In accordance with the SCBTM Department policy, your average on both exams together must be at least 50% to pass the course.|
|Academic honesty||The Code of Conduct (Academic) at Concordia University states that “the integrity of University academic life and of the degrees, diplomas and certificates the University confers is dependent upon the honesty and soundness of the instructor-student learning relationship and, in particular, that of the evaluation process. As such, all students are expected to be honest in all of their academic endeavours and relationships with the University,” (Academic Code of Conduct, art. 1).
All students enrolled at Concordia are expected to familiarize themselves with the contents of this Code. You are strongly encouraged to read the pertinent section in the Concordia Undergraduate Calendar and visit the university’s Academic Integrity website.
For this class, I require you to sign and submit an Academic Honour Pledge; you will submit it using Moodle. You will not be permitted to submit any assignments in this class until I have received your signed Honour Pledge.
All graded work in this course must be done individually unless explicitly specified otherwise. If you consult any outside resources for any assignment or project, all sources used must be properly cited. I provide detailed instructions for appropriate citation and use of outside sources for this course and for computer development in general.
Any violation of the Code of Conduct will constitute academic dishonesty and will be handled through the appropriate university channels. If you have any question about what might be a violation of the Code, ask me directly and I will gladly clarify you. Thus, claiming to have misunderstood is not an acceptable excuse.
|Make-up policy||Only students who miss an exam for university-approved and verifiable reasons will be allowed to take a make-up exam. Even then, except in the most extreme circumstances, no student may miss a scheduled exam without receiving permission before the exam. Make-up exams might be significantly different in format from the regular exams, and will be administered at a time of my own convenience.|
|Classroom etiquette||We want to maintain a classroom atmosphere that is conducive for learning where everyone respects each other. To that effect, please take care of the following principles of classroom etiquette during class time:
|Schedule||The class schedule is described in a separate document.|
|Acknowledgements||I thank Dr. Raul Valverde for his kind assistance and provision of source materials that I have adapted in the design and development of this course.|