ARST 554: DATABASE DESIGN – Course Syllabus (3)
Program: ARST / LIBR
Year: Winter 2009, Term 2
Course Schedule: Wednesdays, 6:00 - 8:50 p.m.
Location: IKBLC 461
Instructor: Doug Brigham
Office location: SLAIS Sessionals’ Office
Office phone: 604-822-8672
Office hours: Wednesdays, 4:30 – 5:30 p.m. and by appointment
E-mail address: doug.brigham@ubc.ca
Course website address: https://www.vista.ubc.ca/webct/logon/2855309053121
Course Goal: To provide students with an understanding of the principles of relational database design and the ability to apply these principles in the design and development of database projects.
Course Objectives:
- an understanding of database concepts and terminology
- an understanding of the roles and functions of databases
- methods for identifying and modeling database requirements
- an understanding of the relational data model
- an approach to designing an appropriate database solution
- experience in designing and implementing a relational database using MS Access 2007
- knowledge of how to interact with a database
Course Topics:
- Overview of databases and database design
- Components of a DBMS
- The relational model
- Entity-Relationship diagramming
- Data normalization
- Creating a desktop database application using MS Access 2007
- Querying a database using QBE and SQL
- Presenting information from a database
Prerequisites: ARST 500/LIBR 500, ARST 510, ARST 515, ARST 516, ARST 520, ARST 540, ARST 573, ARST 587 for student in MAS program
Format of the course: One lecture session per week and IT labs in selected weeks.
Required and Recommended Reading:
Required:
- Hernandez, Michael J. Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design. 2nd ed. Toronto: Addison Wesley, 2003.
- Conrad, Jeff and John Viescas. Microsoft Office Access 2007 Inside Out. Redmond, WA: Microsoft Press, 2007.
Other readings on particular topics may be distributed over the course of the term.
Course Assignments, Due Dates and Weights in Relation to Final Course Mark:
Take Home #1 |
10 February |
25% total |
Take Home #2 |
31 March |
|
Term Project Outline |
20 January |
|
Term Project Proposal |
03 March |
|
Peer Evaluation |
10 March |
15% |
Term Project |
14 April |
50% |
Discussions / Participation |
|
10% |
Course Schedule:
Week |
Date |
Topics / Readings / Assignments Due |
1 |
06 January |
Introduction to the course |
2 |
13 January |
Introduction to data & databases |
3 |
20 January |
Database Design Process |
4 |
27 January |
Table Structures & Keys |
5 |
03 February |
Field Definition |
6 |
10 February |
Table Relationships & Entity-Relationship Diagramming |
7 |
17 February |
Reading Week – No class |
8 |
24 February |
Reading Week – No class |
9 |
03 March |
Table and Field Definition |
10 |
10 March |
Basic Queries using QBE and SQL |
11 |
17 March |
Advanced Queries using QBE and SQL |
12 |
24 March |
Forms |
13 |
31 March |
Reports |
14 |
07 April |
Lab time for Term Project |
15 |
14 April |
Term Project Presentations |
Attendance: The calendar states: “Regular attendance is expected of students in all their classes (including lectures, laboratories, tutorials, seminars, etc.). Students who neglect their academic work and assignments may be excluded from the final examinations. Students who are unavoidably absent because of illness or disability should report to their instructors on return to classes.”
Evaluation: All assignments will be marked using the evaluative criteria given on the SLAIS web site.
Written & Spoken English Requirement: Written and spoken work may receive a lower mark if it is, in the opinion of the instructor, deficient in English
Disability Accommodation: The University accommodates students with disabilities who have registered with the Access and Diversity unit: [http://www.students.ubc.ca/access/drc.cfm]. You must register with the Disability Resource Centre to be granted special accommodations for any on-going conditions
Religious Accommodation: The University accommodates students whose religious obligations conflict with attendance, submitting assignments, or completing scheduled tests and examinations. Please let your instructor know in advance, preferably in the first week of class, if you will require any accommodation on these grounds. Students who plan to be absent for varsity athletics, family obligations, or other similar commitments, cannot assume they will be accommodated, and should discuss their commitments with the instructor before the course drop date. UBC policy on Religious Holidays: http://www.universitycounsel.ubc.ca/policies/policy65.pdf
Academic Dishonesty: Please review the UBC Calendar Academic regulations for the University policy on cheating, plagiarism, and other forms of academic dishonesty: http://www.students.ubc.ca/calendar/index.cfm?tree=3,54,111,959 . Also visit and review the contents of these two resources: Plagiarism Resource Centre: For Students: http://www.library.ubc.ca/home/plagiarism/welcome.html and Plagiarism Avoided: Taking Responsibility For Your Work: http://www.arts.ubc.ca/arts-students/plagiarism-avoided.html for useful information on avoiding plagiarism and on correct documentation practice. Students are held responsible for knowing and following all University regulations regarding academic dishonesty. If a student does not know how to properly cite a source or what constitutes proper use of a source it is the student's personal responsibility to obtain the needed information and to apply it within University guidelines and policies. If evidence of academic dishonesty is found in a course assignment, previously submitted work in this course may be reviewed for possible academic dishonesty and grades modified as appropriate. UBC policy requires that all suspected cases of academic dishonesty must be forwarded to the Dean for possible action.
Other Course Policies
- The instructor reserves the right to alter the class and assignment schedules.
- You are responsible for all announcements made in class. If you are unable to attend class, make certain you ask a classmate to fill you in on announcements and activities.
- Assignments are due as specified by the instructor if you are to receive full credit. Extenuating circumstances (serious injuries or illnesses confirmed with a doctor’s note) should be presented to the instructor in advance of the due date if you are requesting an extension.
