Course Outline (W2023)
COE848: Fundamentals of Data Engineering
|Instructor(s)||Dr. Faezeh Ensan [Coordinator]|
Phone: (416) 979-5000 x 554904
Office Hours: Wednesdays, 12:30 pm - 2:30 pm
|Calendar Description||Data engineering is core to the effective development of scalable software applications. Rich data management schemes are needed to handle the sizeable Big Data that is available for processing. This course will cover related topics such as entity-relation diagrams, relational databases, data definition and manipulation languages, structured data representations formats, development of novel vocabularies and semi-structured data and also novel concepts in NoSQL databases.
- Database Systems: The Complete Book, by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer D. Widom, Prentice Hall, 2nd Edition, 2008, ISBN: 0131873253
|Learning Objectives (Indicators) |
At the end of this course, the successful student will be able to:
- Use engineering knowledge to solve real world open-ended engineering problems. Use the specialized engineering knowledge to design specific components, systems, or processes.
- Use engineering knowledge to solve real world open-ended engineering problems. Use the specialized engineering knowledge to design specific components, systems, or processes. (1d)
- Anticipate the needs of the project, customize design processes, analyzes progress, and revises plans as necessary. Generate solutions for complex engineering design problems
- Design and develop software tools that adhere to specific project specifications relating to data modeling and data model designs. (5a)
- Design and implement a data-focused software project. Demonstrate the project to the Teaching Assistant through oral communication and get feedback and evaluate and improve the project modeling and implementation based on the technical feedback (6b)
- Anticipate legal requirements related to the software project and managing and storing data. Customize modeling and implementation based on these requirements. (9b)
- Systematically account for professional codes of ethics in data modeling and software design and implementation. (10a)
NOTE:Numbers in parentheses refer to the graduate attributes required by the Canadian Engineering Accreditation Board (CEAB).
3.0 hours of lecture per week for 13 weeks
1.0 hours of lab per week for 12 weeks
0.0 hours of tutorial per week for 12 weeks
|Teaching Assistants||Omid Shokrollahi ,|
|Midterm Exam|| 30 %|
|Final Exam|| 35 %|
|Lab Reports and Final Project|| 35 %|
Note: In order for a student to pass a course, a minimum overall course mark of 50% must be obtained. In addition, for courses that have both "Theory and Laboratory" components, the student must pass the Laboratory and Theory portions separately by achieving a minimum of 50% in the combined Laboratory components and 50% in the combined Theory components. Please refer to the "Course Evaluation" section above for details on the Theory and Laboratory components (if applicable).
|Examinations||Midterm exam in Week 7, two hours, closed book (covers Weeks 1-6).|
Final exam, during exam period, two hours, closed-book (covers Weeks 1-13).
|Other Evaluation Information||The written reports will be assessed not only on their academic merit, but also on the communication skills of the author as exhibited through the reports. In order to achieve a passing grade in this course, the student must achieve an average of at least 50% in both theoretical and laboratory components.|
Lab assignments should be submitted before 11:59 pm the day before the scheduled next lab. The penalty for up to 8 hours delay in submission is 20% of the lab mark. More than 8-hours late lab assignments will not be accepted and will receive a mark of 0.
|Teaching Methods||Lectures will be in the following room, On Wednesdays 3pm - 6pm:|
Introduction to relational Database Systems
Entity-Relationship (E/R) Data Model
Relational Database Model Subclass Structures to Relations
Algebra of Relational Operations
Structured Query Language (SQL)
Database Connectivity- Database Modifications Views OOP Access to RDBMS
Data Access and Integrity Models-Database Indices
Semi-structured Data Representation (XML XML Schema DTD)
Project Scope Definition and Project Specification Document Development
E/R Diagram Design
Policies & Important Information:
Students are reminded that they are required to adhere to all relevant university policies found in their online course shell in D2L and/or on the Senate website
- In accordance with the Policy on TMU Student E-mail Accounts (Policy 157), Toronto Metropolitan University (TMU) requires that any electronic communication by students to TMU faculty or staff be sent from their official university email account;
- Any changes in the course outline, test dates, marking or evaluation will be discussed in class prior to being implemented;
- Assignments, projects, reports and other deadline-bound course assessment components handed in past the due date will receive a mark of ZERO, unless otherwise stated. Marking information will be made available at the time when such course assessment components are announced.
- Familiarize yourself with the tools you will need to use for remote learning. The Continuity of Learning Guide for students includes guides to completing quizzes or exams in D2L or Respondus, using D2L Brightspace, joining online meetings or lectures, and collaborating with the Google Suite.
- The University has issued a minimum technology requirement for remote learning. Details can be found at: https://torontomu.ca/covid-19/students/minimum-technology-requirements-remote-learning. Please ensure you meet the minimum technology requirements as specified in the above link.
- Toronto Metropolitan University COVID-19 Information and Updates (available https://www.torontomu.ca/covid-19/students) for Students summarizes the variety of resources available to students during the pandemic.
- Refer to our Departmental FAQ page for information on common questions and issues at the following link: https://www.ecb.torontomu.ca/guides/Student.Academic.FAQ.html.
Missed Classes and/or Evaluations
When possible, students are required to inform their instructors of any situation which arises during the semester which may have an adverse effect upon their academic performance, and must request any consideration and accommodation according to the relevant policies as far in advance as possible. Failure to do so may jeopardize any academic appeals.
- Academic Consideration Requests for missed work (e.g. missing tests, labs, etc) - According to Senate Policy 134, Section 1.2.3, if you miss any exams, quizzes, tests, labs, and/or assignments for health or compassionate reasons you need to inform your instructor(s) (via email whenever possible) in advance when you will be missing an exam, test or assignment deadline. When circumstances do not permit this, you must inform the instructor(s) as soon as reasonably possible". In the case of illness, a Toronto Metropolitan Student Health Certificate, or a letter on letterhead from an appropriate regulated health professional with the student declaration portion of the Student Health Certificate attached. For reasons other than illness, proper documentation is also required (e.g. death certificate, police report, TTC report). ALL supporting documentation for illness or compassionate grounds MUST be submitted within three (3) working days of the missed work." NOTE: You are required to submit all of your pertinent documentation through the University's online Academic Consideration Request system at the following link: prod.apps.ccs.torontomu.ca/senateapps.
- Religious, Aboriginal and Spiritual observance - If a student needs accommodation because of religious, Aboriginal or spiritual observance, they must submit a Request for Accommodation of Student Religious, Aboriginal and Spiritual Observance AND an Academic Consideration Request form within the first 2 weeks of the class or, for a final examination, within 2 weeks of the posting of the examination schedule. If the requested absence occurs within the first 2 weeks of classes, or the dates are not known well in advance as they are linked to other conditions, these forms should be submitted with as much lead time as possible in advance of the absence. Both documents are available at www.torontomu.ca/senate/forms/relobservforminstr.pdf. If you are a full-time or part-time degree student, then you submit the forms to your own program department or school;
- Academic Accommodation Support - Before the first graded work is due, students registered with the Academic Accommodation Support office (AAS - prod.apps.ccs.torontomu.ca/senateapps) should provide their instructors with an Academic Accommodation letter that describes their academic accommodation plan.
Virtual Proctoring Information (if used in this course)
Online exam(s) within this course may use a virtual proctoring system. Please note that your completion of any such virtually proctored exam may be recorded via the virtual platform and subsequently reviewed by your instructor. The virtual proctoring system provides recording of flags where possible indications of suspicious behaviour are identified only. Recordings will be held for a limited period of time in order to ensure academic integrity is maintained and then will be deleted.
Access to a computer that can support remote recording is your responsibility as a student. The computer should have the latest operating system, at a minimum Windows (10, 8, 7) or Mac (OS X 10.10 or higher) and web browser Google Chrome or Mozilla Firefox. You will need to ensure that you can complete the exam using a reliable computer with a webcam and microphone available, as well as a typical high-speed internet connection. Please note that you will be required to show your Toronto Metropolitan University OneCard prior to beginning to write the exam. In cases where you do not have a Toronto Metropolitan University OneCard, government issued ID is permitted.
Information will be provided prior to the exam date by your instructor who may provide an opportunity to test your set-up or provide additional information about online proctoring. Since videos of you and your environment will be recorded while writing the exam, please consider preparing the background (room / walls) so that personal details are not visible, or move to a room that you are comfortable showing on camera.
Toronto Metropolitan University's Policy 60 (the Academic Integrity policy) applies to all students at the University. Forms of academic misconduct include plagiarism, cheating, supplying false information to the University, and other acts. The most common form of academic misconduct is plagiarism - a serious academic offence, with potentially severe penalties and other consequences. It is expected, therefore, that all examinations and work submitted for evaluation and course credit will be the product of each student's individual effort (or an authorized group of students). Submitting the same work for credit to more than one course, without instructor approval, can also be considered a form of plagiarism.
Suspicions of academic misconduct may be referred to the Academic Integrity Office (AIO). Students who are found to have committed academic misconduct will have a Disciplinary Notation (DN) placed on their academic record (not on their transcript) and will normally be assigned one or more of the following penalties:
- A grade reduction for the work, ranging up to an including a zero on the work (minimum penalty for graduate work is a zero on the work);
- A grade reduction in the course greater than a zero on the work. (Note that this penalty can only be applied to course components worth 10% or less, and any additional penalty cannot exceed 10% of the final course grade. Students must be given prior notice that such a penalty will be assigned (e.g. in the course outline or on the assignment handout);
- An F in the course;
- More serious penalties up to and including expulsion from the University.
The unauthorized use of intellectual property of others, including your professor, for distribution, sale, or profit is expressly prohibited, in accordance with Policy 60 (Sections 2.8 and 2.10). Intellectual property includes, but is not limited to:
- Lecture notes
- Presentation materials used in and outside of class
- Lab manuals
- Course packs
For more detailed information on these issues, please refer to the Academic Integrity policy(https://www.torontomu.ca/senate/policies/pol60.pdf) and to the Academic Integrity Office website (https://www.torontomu.ca/academicintegrity).
Academic Accommodation Support
Toronto Metropolitan University acknowledges that students have diverse learning styles and a variety of academic needs. If you have a diagnosed disability that impacts your academic experience, connect with Academic Accommodation Support (AAS). Visit the AAS website or contact email@example.com for more information.
Note: All communication with AAS is voluntary and confidential, and will not appear on your transcript.
Important Resources Available at Toronto Metropolitan University
- The Library provides research workshops and individual assistance. If the University is open, there is a Research Help desk on the second floor of the library, or students can use the Library's virtual research help service at https://library.torontomu.ca/ask to speak with a librarian.
- Student Life and Learning Support offers group-based and individual help with writing, math, study skills, and transition support, as well as resources and checklists to support students as online learners.
- You can submit an Academic Consideration Request when an extenuating circumstance has occurred that has significantly impacted your ability to fulfill an academic requirement. You may always visit the Senate website and select the blue radial button on the top right hand side entitled: Academic Consideration Request (ACR) to submit this request).
Please note that the Provost/Vice President Academic and Deans approved a COVID-19 statement for Fall 2022 related to academic consideration. This statement will be built into the Online Academic Consideration System and will also be on the Senate website (www.torontomu.ca/senate) in time for the Fall term:
Policy 167: Academic Consideration for Fall 2022 due to COVID-19: Students who miss an assessment due to cold or flu-like symptoms, or due to self-isolation, are required to provide a health certificate. All absences must follow Senate Policy 167: Academic Consideration.
Also NOTE: Policy 167: Academic Consideration does allow for a once per term academic consideration request without supporting documentation if the absence is less than 3 days in duration and is not for a final exam/final assessment. If the absence is more than 3 days in duration and/or is for a final exam/final assessment, documentation is required. For more information please see Senate Policy 167: Academic Consideration.
- TMU COVID-19 Information and Updates for Students summarizes the variety of resources available to students during the pandemic.
- TMU COVID-19 Vaccination Policy.
- If taking a remote course, familiarize yourself with the tools you will need to use for remote learning. The Remote Learning guide for students includes guides to completing quizzes or exams in D2L Brightspace, with or without Respondus LockDown Browser and Monitor, using D2L Brightspace, joining online meetings or lectures, and collaborating with the Google Suite.
- Information on Copyright for students.
- At Toronto Metropolitan University (TMU), we recognize that things can come up throughout the term that may interfere with a student's ability to succeed in their coursework. These circumstances are outside of one's control and can have a serious impact on physical and mental well-being. Seeking help can be a challenge, especially in those times of crisis.
If you are experiencing a mental health crisis, please call 911 and go to the nearest hospital emergency room. You can also access these outside resources at anytime:
- Distress Line: 24/7 line for if you are in crisis, feeling suicidal or in need of emotional support (phone: 416-408-4357)
- Good2Talk: 24/7 hour line for postsecondary students (phone: 1-866-925-5454)
- Keep.meSAFE: 24/7 access to confidential support through counsellors via My SSP app or 1-844-451-9700
If non-crisis support is needed, you can access these campus resources:
- Centre for Student Development and Counselling: 416-979-5195 or email firstname.lastname@example.org
- Consent Comes First - Office of Sexual Violence Support and Education: 416-919-5000 ext: 553596 or email email@example.com
We encourage all Toronto Metropolitan University community members to access available resources to ensure support is reachable. You can find more resources available through the Toronto Metropolitan University Mental Health and Wellbeing website.