ACIT 1630
Database Systems
| School | School of Computing and Academic Studies |
|---|---|
| Program | Computer Information Technology Diploma |
| Course Credits | 4 |
| Minimum Passing Grade | 50% |
| Start Date | September 03, 2019 |
| End Date | December 13, 2019 |
| Total Hours* | 60 |
| Total Weeks | 15 |
| Hours/Weeks | 4 |
| Delivery Type | Lecture/Lab |
| CRN | 41871 |
Acknowledgement of Territories
The British Columbia Institute of Technology acknowledges that our campuses are located on the unceded traditional territories of the Coast Salish Nations of Sḵwx̱wú7mesh (Squamish), səl̓ilwətaɁɬ (Tsleil-Waututh), and xwməθkwəy̓əm (Musqueam).
Instructor Details
| Name | Benjamin Yu |
|---|---|
| benjamin_yu@bcit.ca | |
| Location | DTC-676 |
| Office Hours | TBA |
Course Description
This course covers relational database technology, including basic concepts, relational algebra, enhanced entity-relationship data modeling, functional dependencies and normalization, design methodology, SQL query language (DDL and DML), views, security and transaction management.
Course Learning Outcomes/Competencies
Upon successful completion of this course, the student will be able to:
- Analyze database requirements.
- Apply database design techniques including:
- Enhanced Entity Relationship Modeling.
- Derivation of relation schema from EER models.
- Identification of functional dependencies.
- Table normalization.
- Create database and database objects using a desktop RDBMS.
- Use SQL to implement and query a relational database.
- Identify security issues and propose data protection techniques for databases.
- Identify and diagnose issues related to transaction management and concurrency control.
- Use relational algebra operations to solve relational queries.
Learning Resources
DATABASE SYSTEMS DESIGN, IMPLEMENTATION, AND MANAGEMENT (13th Edition) by Carlos Coronel, Steven Morris, Cengage Learning, 2018.
ISBN-10: 1337627909
ISBN-13: 978-1337627900
Desire2Learn (D2L) online portal.
All material (outside of the text) is delivered by D2L
Course Goals
- Apply concepts covered to progressively complex problems
- Solve database related problems under time pressure/constraint
- Model real-life situations using Visio
- Develop database and create database objects using SQL Server
- Discuss current database trends and industry needs
- Collaborate effectively in a team environment
Evaluation Criteria
| Criteria | % | Comments |
| Final Exam | 25 | A combined average of 50% on the midterm and the final exam is required in order to pass this course |
| Midterm | 25 | A combined average of 50% on the midterm and the final exam is required in order to pass this course |
| Lab Exercises, Review Questions | 10 | Online participation is required. All assignments must be completed and submitted. |
| Online Discussions, Pre-Lecture Readings | 10 | Online participation is required. |
| Quizzes | 10 | |
| Projects | 20 | |
| 100 |
- Group work: A large component of this course is based on online participation. It is the responsibility of the group to let the instructor know if someone is not pulling their weight. Each online group discussion is worth marks, and it's based on what is submitted online.
- Makeup Tests, exams, or quizzes: There will be no makeup tests, exams, or quizzes. If you miss a test, exam or quiz, you will receive zero marks. Exceptions may be made for documented medical reasons or extenuating circumstances. In such a case, it is the responsibility of the student to inform the instructor immediately.
- Late assignments/online submissions or projects will not be accepted except for proof of illness. No assignments/projects will be accepted after marked assignments or solutions to questions have been posted.
- Midterm exams, final exams, and project papers will not be returned to the student.
Attendance Requirements
Attendance in class is mandatory.
In case of illness or other unavoidable cause of absence, the student must communicate as soon as possible with his/her instructor indicating the reason for the absence.
Prolonged illness which causes the student to miss 10% or more of the labs will require a BCIT-approved medical certificate submitted to the department, substantiating the reason for the absence.
Unapproved absence of 10% or more of the labs may result in failure or forced withdrawal from this course.
Course Specific Requirements
Computer Use Policy: BCIT has an Institute-wide policy (#3501) pertaining to information technology and services and to the resources available in support of the Institute mission. Computer Systems Technology students are expected to exercise the highest degree of professionalism and ethical behavior related to information technology. Violations of BCIT Policy #3501 will result in disciplinary action which may include suspension or expulsion of students. Also, refer to the Computer Systems Technology Student Conduct Guidelines.
Ethics: BCIT assumes that all students attending the Institute will follow a high standard of ethics. Incidents of cheating or plagiarism may, therefore, result in a grade of zero for the assignment, quiz, test, exam, or project for all parties involved and/or expulsion from the course.
Assignments: Late assignments, lab reports or projects will not be accepted for marking. Assignments must be done on an individual basis unless otherwise specified by the instructor.
Makeup Tests, Exams or Quizzes: There will be no makeup tests, exams or quizzes. If you miss a test, exam or quiz, you will receive zero marks. Exceptions may be made for documented medical reasons or extenuating circumstances. In such a case, it is the responsibility of the student to inform the instructor immediately.
Course Outline Changes: The material or schedule specified in this course outline may be changed by the instructor. If changes are required, they will be announced in class.
Labs and Tutorials: Lab attendance is mandatory. Lab exercises are due at the end of the lab period unless otherwise specified by the instructor. Tutorials are due as indicated on the tutorial sheets.
Lab Discussions: During some of the labs, case studies will be discussed. Attendance in the labs and participation in the discussions are requirements of the course. You may be required, on occasion, to make a mini-presentation.
I.D. Required in Examination Centres: Effective December 2000, in order to write exams, students will be required to produce photo-identification at examination centers. Photo I.D. must be placed on the desk before an exam will be issued to the student. The I.D. must remain in view on the desk while writing the exam, for inspection by invigilators. Students should bring a BCIT OneCard or alternatively two pieces of identification, one of which must be government photo I.D. such as a driver’s licence. Please see BCIT Policy #5300, Formal Invigilation Procedures.
Final Exam and Project Papers: The exam papers and the final project will not be returned to the student
Online Content: This course includes significant online content and activities. Lack of participation in the online portion of this class may result in failure of the course.
Other information
Computer Use Guidelines
BCIT Computing students are expected to use BCIT resources in both a professional and ethical manner. When using BCIT computer resources, some specific expectations include:
- Respect others. Do not download, view, or distribute inappropriate or offensive material.
- Respect copyright. Do not download or share any unauthorized materials (e.g. music, movies, games and software).
- Respect our vendor software agreements. Do not download products which are not used in your specific courses (we have tracking mechanisms in place). It is each student's responsibility to remove vendor provided software when the course ends.
- Respect confidentiality. Do not attempt to gain unauthorized access to any account, system, or data. Do not attempt to bypass any protective mechanism or attempt unauthorized access or alteration of BCIT data.
- Respect availability. Do not engage in any denial of service activity or take actions that will degrade the use of BCIT or other resources. Only use BCIT resources for your BCIT coursework.
For more information see BCIT policies 3501 Acceptable Use of Information Technology and3502 Information Security.
Consequences of policy violation could result in loss of access to BCIT resources and/or removal from classes.
Course Schedule and Assignments
|
Session |
Material Covered |
Reference/ |
Assignment |
Due Date |
|
1 September 1 |
Introduction to Database Systems · File Systems · Database Systems |
Chapter 1 |
Review Questions 1 Discussion Topic 1 |
Session 2 |
|
2 September 8 |
Relational Model · Data Models · Business Rules · Relational Algebra |
Chapter 2 |
Review Questions 2 Discussion Topic 2 |
Session 3 |
|
3 September 15 |
Entity Relationship Modeling · Relationships and Strengths · Primary and Foreign Keys Quiz 1 |
Chapter 3 |
Review Questions 3 ERD Project Discussion Topic 3 |
Session 4 Session 6 |
|
4 September 22 |
Relational Algebra - Set operations - Relational operators |
Chapter 4 |
Review Questions 4 Discussion Topic 4 |
Session 5 |
|
5 September 29 |
Normalization 1 · Normalization Stages · Normal Forms Quiz 2 |
Chapter 6 |
Review Questions 5 Discussion Topic 5 |
Session 6 |
|
6 October 6 |
Normalization 2 - Normalization Steps |
Chapter 6 |
Review Questions 6 Discussion Topic 6 |
Session 7 |
|
7 October 13 |
Enhanced Entity Relational Modeling - EERD - Generalization and Specialization |
Chapters 5 |
Review Questions 7 Discussion Topic 7 |
Session 9 |
|
8 October 20 |
Midterm Exam |
|||
|
9 October 27 |
Introduction to Structured Query Language (SQL) · Creating Databases, Tables, and Constraints |
Chapter 7 |
Review Questions 8 SQL Project Discussion Topic 8 |
Session 10 Session 14 |
|
10 November 3 |
Structured Query Language · SELECT · Aggregate Operations · Date, Mathematical, String, and System Functions Quiz 3 |
Chapters 7 |
Review Questions 9 Discussion Topic 9 |
Session 11 |
|
11 November 10 |
Basic SQL · Joining Tables · INSERT, UPDATE, DELETE Quiz 4 |
Chapter 8 |
Review Questions 10 Discussion Topic 10 |
Session 13 |
|
12 November 17 |
Review / Project |
|||
|
13 November 24 |
Advanced SQL · VIEWS · Subqueries · Indexes Transactions Quiz 5 |
Chapter 10 |
Review Questions 11 Discussion Topic 11 |
Session 14 |
|
14 December 1 |
Data Warehouse |
Chapters 13 |
||
|
15 December 8 |
Final Exam |
BCIT Policy
The following statements are in accordance with the BCIT Policies 5101, 5102, 5104, and 7507, and their accompanying procedures. To review these policies and procedures please click on the links below.
Attendance/Illness:
In case of illness or other unavoidable cause of absence, the student must communicate as soon as possible with his/her instructor or Program Head or Chief Instructor, indicating the reason for the absence. Students who are seeking accommodation for a medical absence must have a BCIT approved medical certificate submitted to the department, substantiating the reason for absence. For other absences, the student should be prepared to provide appropriate supporting documentation. Unapproved absence in excess of the prescribed regulations within this outline may result in failure or forced withdrawal from the course or program. Please see Policy 5101 - Student Regulations, and accompanying procedures.
Academic Integrity:
Violation of academic integrity, including plagiarism, dishonesty in assignments, examinations, or other academic performances are prohibited and will be handled in accordance with Policy 5104 - Academic Integrity and Appeals, and accompanying procedures.
Accommodation:
Any student who may require accommodation from BCIT because of a physical or mental disability should refer to BCIT's Policy on Accommodation for Students with Disabilities (Policy #4501), and contact BCIT's Accessibility Services (SW1 2360, 604-451-6963) at the earliest possible time. Requests for accommodation must be made to Accessibility Services, and should not be made to a course instructor or Program area.
Any student who needs special assistance in the event of a medical emergency or building evacuation (either because of a disability or for any other reason) should promptly inform their course instructor(s) and Accessibility Services of their personal circumstances.
Human Rights, Harassment and Discrimination:
The BCIT community is made up of individuals from every ability, background, experience and identity, each contributing uniquely to the richness and diversity of the BCIT community as a whole. In recognition of this, and the intrinsic value of our diversity, BCIT seeks to foster a climate of collaboration, understanding and mutual respect between all members of the community and ensure an inclusive accessible working and learning environment where everyone can succeed.
Campus Mediation Services is a supportive resource for both students and employees of BCIT, to foster a respectful learning and working environment. Any student who feels that they are experiencing discrimination or harassment (personal or human rights-related) can confidentially access this resource for advice and support. Please see Policy 7507 – Harassment and Discrimination and accompanying procedure.
Students should make themselves aware of additional Education, Administration, Safety and other BCIT policies listed at https://www.bcit.ca/about/administration/policies.shtml
Guidelines for School of Computing and Academic Studies
Attempts:
Students must successfully complete a course within a maximum of three (3) attempts at the course. Students with two attempts in a single course will be allowed to repeat the course only upon special written permission from the Associate Dean. Students who have not successfully completed a course within three attempts will not be eligible to graduate from their respective program.
Approved
I verify that the content of this course outline is current.
Benjamin Yu, Instructor
August 23, 2019
I verify that this course outline has been reviewed.
Thomas Lane, Program Head
August 30, 2019
I verify that this course outline has been reviewed and complies with BCIT policy.
Aaron Hunter, Acting Associate Dean
August 30, 2019
Note: Students will be given reasonable notice if changes are required to the content of this course outline.
*Course hours and credits are calculated per Policy 5012 and the associated procedure.
Total hours – Example of 3 credit lecture/lab course:
- Full-time course: 45 hours of scheduled learning
- Flexible Learning course: 36 hours of scheduled learning plus 9 hours of independent (non-scheduled, non-instructional) learning