DBA625 - Database Administration

Outline info
Semester
School
Last revision date 2017-05-29 00:32:41.009
Last review date 2017-07-17 00:15:35.458


Subject Title
Database Administration

Subject Description
This subject will review the purpose and responsibilities of the Database Administrator. The student will learn how the DBMS manages the data and controls such as recovery, locking and transaction logging and performance tuning. Through hands on Database Adminstration using Oracle, the student will practice much of the theory presented.

Credit Status
1 Credit for CPA/CPAC Diploma Students

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

1. Demonstrate a working knowledge of the utilities of the DBMS in use

2. Describe in detail the functions performed by a DBA

3. Demonstrate an understanding of the architecture and functions of the DBMS(s) in use

4. Demonstrate a working knowledge of DBA administrative tasks and basics of backup and recovery and performance tuning

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)
DBS301

Topic Outline
DataBase Administration 40% 

Administrative Functions: 
  • develop & maintain data standards 
  • develop schemes 
  • control data redundancy
  • cost/benefit analysis
  • procure hardware and software
  • develop procedures for recovery 
  • set performance standards 
  • manage database security 
  • set programming standards 
Technical Functions: 
  • install DBMS 
  • generate data dictionary reports 
  • construct and maintain external schemas 
  • implement programming standards 
  • construct and maintain storage schemas 
  • monitor systems performance and activity 
  • construct and maintain integrity controls 
  • construct and maintain security controls 
  • load, reorganize and recover databases 
  • tune databases 
  • install systems enhancements (upgrades) 

Oracle DBA   60%
- Hands on component will have students create and maintain their own database including:
  • backup and recovery
  • dictionary reporting
  • import and export
  • parameter setting
  • security and other basic DBA functions
  • space management
  • tuning

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.

Lectures and Lab Sessions
ASSIGNMENTS
Assignments must be submitted using a Seneca College Oracle account for the class the student is registered in.  

Prescribed Texts
Oracle 11G Notes - for DBA625
Based on Copyright Agreement, the Oracle notes are for students' personal education use only.

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:


Assignments (2) 40%
Midterm Test 30%
Final Exam 30%




 









Approved by: Denis Gravelle