- Information
- AI Chat
CSCI 2141 - Course Outline
Intro to Database Systems (CSCI 2141)
Dalhousie University
Recommended for you
Related documents
- SOCI 1016 20F Chapter 5 - Social Inequality in Canadian Society
- SOCI 1016 20F ch4 Socialization The Self and Social Identity
- SOCI 1016 20F Chapter 3 What is “Canadian” Culture
- SOCI 1016 20F Chapter 2 Applying Sociological Research Methods
- SOCI 1016 20F Chapter 1 – Seeing and Acting Through the Lens of Sociology
- SOCI1015 Lec 4 + Chapter 2 Notes
Preview text
CSCI-2141 – Intro to Database Systems
Course Information and Syllabus
Instructor Information
Instructor: Khurram Aziz, Sukhchandan E-mail: kaziz@dal sk350901@dal Class Times: T R 10:05-11:25 (Collaborate) W F 08:35-09:55 (Collaborate) Office Hour: W 10:00-11:00 (Collaborate) M 10:30 to 11:30 (MS Teams) Lab Times: B01: M 1305-1425 , B02: M 1605-1725 , B03: W 0835-0955 , B04: M 1005-1125 , B05: M 1135-1255 , B06: M 1605- Course TAs:
- Jaber Rad (Jaber@dal) – Lead TA
- Wen Fei (wn335813@dal)
- Ali Shan Khawaja (al290543@dal)
- Vishal Rakesh Jaiswal (vs928999@dal)
- Imaad Amyn Rajan (im609929@dal)
Course Homepages: dal.brightspace/d2l/home/201524 (Dr. Aziz) dal.brightspace/d2l/home/201525 (Dr. Sukhchandan)
Important Dates
For Academic Calendar visit: dal/academics/important_dates.html
Course Specific Dates:
Winter Study Break (no classes): February 21 – 25, 2022
Midterm Exam and Practicum: The week of 28 February – 04 March
Final Practicum: The week of 28 March – 01 April
Final Exam: TBA in the period of April 08 to 26 , 202 2
Problems of the week (POTW) due every Friday (except midterm week)
Weekly short quizzes every Friday (except midterm week)
Course Description
This course introduces students to the concepts of database management systems and database design. Topics include Database (DB) components, DB design using entity-relationship (relational and object oriented), SQL, and transactional properties and techniques to support them. The concepts will be reinforced using one or more Database Management Systems (DBMS).
Students will learn to analyze the database requirements and create data models, normalize tables, create databases using the Data Definition Language (DDL), manipulate data using the Data Manipulation Language (DML) and use database connectivity to connect with applications. Knowledge gained in classes will be practiced during the assignments and lab sessions.
Curriculum Map and Learning Outcomes
academics.cs.dal/curriculum/manage/course/CSCI/
Course Rationale
This is a core course for BCS and BACS covering fundamentals of database systems.
Evaluation Criteria
- Assignments (15%) Either do Option A or Option B, but not both. o Option A: Complete Problems of the week (POTW) available through Mimir every Friday o Option B: Complete 3 long assignments available on 17 Jan, 07 -Feb and 07-Mar
- Practicums (15%) o Midterm Practicum (5%)
▪ Held during your registered lab time during the Midterm week of 2022
▪ Best of Midterm or the final practicum percentage will be considered
o Final Practicum held during the last week’s lab sessions (28-Mar to 01-Apr) ▪ Final Practicum must be completed, or you lose its marks.
- Assessments ( 70 %) o Weekly short quizzes (0% or 15 %) ▪ Weekly quizzes every Friday conducted through Brightspace ▪ Best of weekly quizzes OR Final exam percentage will be considered o Midterm Exam (0% or 15 %)
▪ Held during class time during the Midterm week of 2022
▪ Best of Midterm or the final exam percentage will be considered
o Final Exam (40% or 55% or 70%) ▪ The exam will be scheduled by the university ▪ Final Exam must be completed, or you lose its marks.
The matrix below explains the several paths’ students may choose from:
Notes: (1) Marks calculation will be automatic. You do not have to inform the instructor about which path you choose to take for this course. (2) Path 1 in all cases is longer but most beneficial, while the last path is shortest but most risky. Please choose wisely, according to your study style. Assignment Options:
POTWs
Long Assignments
Contribution in Final Grade Comments Path 1 15% Not done 15% POTWs marks will be taken for Final Grade Path 2 Not done 15% 15% Long assignments marks will be taken for Final Grade Path 3 15% 15% 15% Best of POTWs and long assignments will be taken for Final Grade Platform Mimir Mimir Note: Path 3 is NOT recommended as this will result in an excessive workload.
Class Format and Course Communications
- Course will be delivered using a partially flipped classroom model in which content (including videos, lecture slides, examples etc.) will be posted on Brightspace for self- study. Students are expected to come prepared for the live online class.
- Course announcements will be posted on the course web page on Brightspace. It is the student's responsibility to check the course page on a regular basis. If you cannot access the course through Brightspace please contact the CS help desk or read the information located at: dal/faculty/computerscience/current.html
Student Declaration of Absence and Medical Absence Policy
The Student Declaration of Absence policy shall apply. dal/campus_life/safety- respect/student-rights-and-responsibilities/academic-policies/student-absence - If you cannot complete a weekly quiz as a direct result of personal illness or distress, please complete the “Student Declaration of Absence” form included in the course content on Brightspace and upload it to the appropriate Dropbox within 3 calendar days following your absence. - It is your responsibly to follow up with your instructor or classmates for any class notes/materials that you have missed. - While there will be no makeup assessments, the following rules will be applied if you submit the “student declaration of absence” within 3 calendar days: o For missed quizzes: You will receive either the average of all your remaining quizzes, or the class average for that quiz, whichever is lower. o For missed midterm or practicum: Your marks for that assessment will be moved to the final examination. - Please note that the “Student Declaration of Absence” is not valid for the final examination, final practicum, POTWs or longer assignments. - Late submissions will result in a grade of zero for that POTW. Please note that you will receive a total of 6 late days that can be applied to POTWs; however, no more than 3 late days may be applied to one POTW.
Tentative List of Topics (See course plan for weekly breakdown)
May be subject to minor changes
Database Systems (Week 1) o What are database systems and why they are needed?
Relational Database Models (Week 2) o Translating business rules to data model components o Conceptual, logical and physical data models o Developing an ER diagram
Structured Query Language (Weeks 3 – 10 ) o Data definition language o Data manipulation language o Advanced SQL
Database Design and Normalization (Weeks 11 – 13) o Normal forms o Designing Databases
Exams and Practicums Requirements
- Photo ID is required
- Closed book
- No dictionaries, notes, calculators, cell phones, PDAs, talking slide rulers, or other electronic aids allowed
- Respondus Lockdown browser with monitor and/or proctoring may be used for exams and practicums. You will need a webcam for these tests
Grade Scale and Definitions:
The Senate approved grade scale will be used, which is available at: dal/campus_life/academic-support/grades-and-student-records/grade-scale-and-defini- tions
Academic Standards
Failure to properly attribute sources in your work will be treated as academic standards issue and points may be deducted for not following citation requirements. For example, forgetting to quote text taken from other sources, failure to include in-text citations, or a failure to include required information in the citations or references. Please see the resources on proper citation provided by the Dalhousie Writing Center (dal.ca.libguides/c.php?g=257176&p=5001261).
Please note that if it appears that the error was made with intent to claim other people’s work as your own such as a lack of both citations and references, an allegation of plagiarism will be submitted to the Faculty Academic Integrity Officer, which could result in consequences such as a course failure.
Use of Plagiarism Detection Software
All submitted code may be passed through a plagiarism detection software, such as the plagiarism detector embedded in Mimir, the Moss (theory.stanford/ ̃aiken/moss/) Software Similarity Detection System, or similar systems. If a student does not wish to have their assignments passed through plagiarism detection software, they should contact the instructor for an alternative. Please note, that code not passed through plagiarism detection software will necessarily receive closer scrutiny. cdn.dal/content/dam/dalhousie/pdf/dept/university_secretariat/policy- repository/OriginalitySoftwarePolicy
Responsible Computing Policy
Usage of all computing resources in the Faculty of Computer Science must be within the Dalhousie Acceptable Use Policies (its.dal/policies/) and the Faculty of Computer Science Responsible Computing Policy. For more information, please see cs.dal/downloads/fcs_policy_local.pdf
Culture of Respect 1
Every person has a right to respect and safety. We believe inclusiveness is fundamental to education and learning. Misogyny and other disrespectful behaviour in our classrooms, on our campus, on social media, and in our community is unacceptable. As a community, we must stand for equality and hold ourselves to a higher standard.
What we all need to do:
- Be Ready to Act: This starts with promising yourself to speak up to help prevent it from happening again. Whatever it takes, summon your courage to address the issue. Try to approach the issue with open-ended questions like “Why did you say that?” or “How did you develop that belief?”
- Identify the Behaviour: Use reflective listening and avoid labeling, name-calling, or assigning blame to
University Statements
This course is governed by the academic rules and regulations set forth in the University Calendar and the Senate. academiccalendar.dal/Catalog/ViewCatalog.aspx?pageid=viewcatalog&catalogid=69&chap- terid=3457&loaduseredits=False
Territorial Acknowledgement
Dalhousie University is located in Mi’kma’ki, the ancestral and unceded territory of the Mi’kmaq. We are all Treaty people.
Internationalization
At Dalhousie, ‘thinking and acting globally’ enhances the quality and impact of education, supporting learning that is “interdisciplinary, cross-cultural, global in reach, and orientated toward solving problems that extend across national borders.” dal/about-dal/internationalization.html
Academic Integrity
At Dalhousie University, we are guided in all of our work by the values of academic integrity: honesty, trust, fairness, responsibility and respect (The Center for Academic Integrity, Duke University, 1999). As a student, you are required to demonstrate these values in all of the work you do. The University provides policies and procedures that every member of the university community is required to follow to ensure academic integ- rity. dal/dept/university_secretariat/academic-integrity.html
Accessibility
The Advising and Access Services Centre is Dalhousie’s centre of expertise for student accessibility and ac- commodation. The advising team works with students who request accommodation as a result of: a disabil- ity, religious obligation, or any barrier related to any other characteristic protected under Human Rights legislation (NS, NB, PEI, NFLD). dal/campus_life/student_services/academic-support/ac- cessibility
Conduct in the Classroom — Culture of Respect
Substantial and constructive dialogue on challenging issues is an important part of academic inquiry and exchange. It requires willingness to listen and tolerance of opposing points of view. Consideration of individual differences and alternative viewpoints is required of all class members, towards each other, towards instructors, and towards guest speakers. While expressions of differing perspectives are welcome and encouraged, the words and language used should remain within acceptable bounds of civility and respect.
Diversity and Inclusion – Culture of Respect
Every person at Dalhousie has a right to be respected and safe. We believe inclusiveness is fundamental to education. We stand for equality. Dalhousie is strengthened in our diversity. We are a respectful and inclu- sive community. We are committed to being a place where everyone feels welcome and supported, which is why our Strategic Direction prioritizes fostering a culture of diversity and inclusiveness (Strategic Priority 5). dal/cultureofrespect.html
Student Code of Conduct
Everyone at Dalhousie is expected to treat others with dignity and respect. The Code of Student Conduct allows Dalhousie to take disciplinary action if students don’t follow this community expectation. When appropriate, violations of the code can be resolved in a reasonable and informal manner—perhaps through a restorative jus- tice process. If an informal resolution can’t be reached, or would be inappropriate, procedures exist for formal dispute resolution. (read more:
dal/dept/university_secretariat/policies/student-life/code-of-student-con.html)
Fair Dealing Policy
The Dalhousie University Fair Dealing Policy provides guidance for the limited use of copyright protected material without the risk of infringement and without having to seek the permission of copyright owners. It is intended to provide a balance between the rights of creators and the rights of users at Dalhousie. (read more: dal/dept/university_secretariat/policies/academic/fair-dealing-policy-.html)
Originality Checking Software
The course instructor may use Dalhousie’s approved originality checking software and Google to check the originality of any work submitted for credit, in accordance with the Student Submission of Assignments and Use of Originality Checking Software Policy. Students are free, without penalty of grade, to choose an alternative method of attesting to the authenticity of their work, and must inform the instructor no later than the last day to add/drop classes of their intent to choose an alternate method. (read more: dal/dept/university_secretariat/policies/academic/student-submission-of-assigments- and-use-of-originality)
Student Use of Course Materials
These course materials are designed for use as part of the CSCI courses at Dalhousie University and are the property of the instructor unless otherwise stated. Third party copyrighted materials (such as books, journal articles, music, videos, etc.) have either been licensed for use in this course or fall under an exception or limitation in Canadian Copyright law. Copying this course material for distribution (e. uploading material to a commercial third party website) may lead to a violation of Copyright law.
Learning and Support Resources
Please see dal/campus_life/academic-support.html
CSCI 2141 - Course Outline
Course: Intro to Database Systems (CSCI 2141)
University: Dalhousie University
- Discover more from:
Recommended for you
Students also viewed
Related documents
- SOCI 1016 20F Chapter 5 - Social Inequality in Canadian Society
- SOCI 1016 20F ch4 Socialization The Self and Social Identity
- SOCI 1016 20F Chapter 3 What is “Canadian” Culture
- SOCI 1016 20F Chapter 2 Applying Sociological Research Methods
- SOCI 1016 20F Chapter 1 – Seeing and Acting Through the Lens of Sociology
- SOCI1015 Lec 4 + Chapter 2 Notes