DAT702 - Introduction to Databases

Outline info
Semester
School
Last revision date 2017-05-29 00:33:36.687
Last review date 2017-07-17 00:15:35.346


Subject Title
Introduction to Databases

Subject Description

Through theoretical lectures and hands-on laboratory exercises and group project work, students will learn to work with Database Management Systems such as MySQL and SQL Server. Students will gain knowledge of the various components of a Relational Database Management System. In addition, students will learn how to design and implement a Database using MySQL . Finally, students will learn how to use Structured Query Language (SQL0 and Normalization of Database Tables)

Credit Status
1 Credit in the CNS/CTY Program.

Learning Outcomes
Upon successful completion of this subject the student will be able to:

1. Create and maintain Databases and Tables

2. Use SQL to interact with Tables in a Database

3. Design and implement a simple Databases

4. Perform Database Table Normalization

5. Construct a variety of SQL queries

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on http://library.senecacollege.ca for further information regarding cheating and plagiarism policies and procedures.

Discrimination/Harassment
All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at student.conduct@senecacollege.ca.

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.

Prerequisite(s)
INT213  

Topic Outline

Database Concepts   4%
Introduction to Database -File system data Management
-Database System Environment
-Database Model
6%
Relational Database -Entities and Attribute
-Tables
-Relationships
10%
Structured Query Language (SQL) -Data Definition Commands
-Create, select, Update Drop
-Queries, joins, subqueries
50%
Database Design -Basic Modeling Concepts
-Data Models
-E-R Model
-E-R diagram
10%
Normalization of Database Tables -The need for Normalization
-First Normal form
-Conversion to Second Normal Form
-Third Normal form
15%
Other Topics -Transactions
-Triggers
-Stored Procedures
-Views
-Log Files
-Use of a Database in Web Page Design
- Permissions
15%

Mode of Instruction
Classroom lectures and discussions are supplemented by lab sessions with the instructor, reinforced by assigned readings and assignments between classes.
It is the student's responsibility to save documents, articles and notes that the instructor has provided on BlackBoard or in class. Students will not be able to access BlackBoard as of the last day of the student’s class.

Prescribed Texts
Database Systems, Design, Implementation & Management, 11th edition
by Peter Rod & Carlos Coronel, Course Technology, ISBN# 9781285196145

Reference Material
MySQL 5.0 Certification Study Guide
by Paul Dubois, Prentice Hall, ISBN#978-067-2328121

Promotion Policy

Grading Policy
A+ 90%  to  100%
A 80%  to  89%
B+ 75%  to  79%
B 70%  to  74%
C+ 65%  to  69%
C 60%  to  64%
D+ 55%  to  59%
D 50%  to  54%
F 0%    to  49% (Not a Pass)
OR
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online (http://www.senecacollege.ca/academic-policy) or at Seneca's Registrar's Offices.


Modes of Evaluation
Since this is a professional credit subject, marking standards reinforce professional practice by demanding legible, tidy work. Written materials should be well organized and grammatically correct, with proper spelling and punctuation.

Assignments

  • Students must retain a duplicate of all assignments.
  • Computer assignments should be documented to the instructor's standards.
  • Assignments must be handed in on the scheduled due date. Late assignments are penalized.
  • For particulars, please obtain standards, dates, etc. from your instructor.

Absenteeism and Tests
  • Students should be aware that absenteeism will impact on their ability to achieve satisfactory grades.
  • If you miss a test, you must provide the reason in writing to the instructor prior to the next scheduled class. If your reason is accepted, you will be permitted to write a make-up test. Otherwise, you will be given a zero for the test. You must submit an original doctor’s certificate identifying the date, length of time of expected absence and the specific reason for your absence, or other appropriate documentation.

Term Work and Final Exam
  • Students must attain a combined grade of at least 50% on term work and the final exam. Students must pass the final exam in order to pass the subject
  • For further information on evaluation and academic standing, see a copy of the Academic Policy available at Seneca registration offices. 

Grading is based on the following marking scheme: 

Mid Term Test
20%
Progress Test
10%
Assignments (minimum 2)
30%
Lab Work (minimum 2)
10%
Final Exam 
30%


Approved by: Denis Gravelle