BTD210 Course Outline

Course Code: BTD210
Course Name: Database Design Principles
Offered Date: Winter - 2018 | Other versions
Print Outline
Course Description:
This course introduces the principles of relational database design and use. Students will learn a methodology for relational database design that uses Entity Relationship Diagrams and normalization of data. The design will then be used to create a database schema, and implement a database by using an introductory subset of SQL (Structured Query Language). Students will also use SQL to perform query and data modification operations. A modern and widely-used database server will be used to host the database.
Credit Status: 1 credit (3 units)
Required for BSD program - Bachelor of Technology (Software Development)
Prerequisite: None
Mode of Instruction: Modes: In-class lecture, in-class exercises, and hands-on activity
Hours per week: 4
Room configurations: Classroom, and computer lab
Typical scheduling pattern: Winter and Summer terms
Learning Outcomes:
  • Compose SQL to retrieve data from databases
  • Compose SQL to create and modify tables in databases
  • Prepare a physical relational database schema for specific business applications
  • Prepare a logical relational database schema for specific business applications
  • Compose an Entity Relationship Diagram for specific business applications
  • Re-organize data to third normal form
  • Distinguish the differences between relational, hierarchical and network databases
  • Differentiate between the basic functions of a Database Management System
  • Describe the responsibilities of a Database administrator in an organization
  • Compose such specialized material as Entity Relationship Diagrams, normalized database schemas and databases
Employability Skills:
Communicate clearly, concisely and correctly in the written, spoken and visual form that fulfils the purpose and meets the needs of the audience.|Execute mathematical operations accurately.|Apply a systematic approach to solve problems.|Use a variety of thinking skills to anticipate and solve problems.|Locate, select, organize, and document information using appropriate technology and information systems.|Analyze, evaluate, and apply relevant information from a variety of sources.|Manage the use of time and other resources to complete projects.|
Topic Outline:

  • Overview of Databases - 10%
    • Database Management System overview
    • Database advantages and disadvantages
    • Database Models: Hierarchical, Network, Relational, Object-oriented Relational, Object-oriented
  • Relational Model - 5%
    • Terminology: File-based (file, record, field) versus data model (entity, attribute, relationship) versus relational model (relation, tuple, attribute) versus relational database (table, row, column)
    • Relational Algebra Operators: Select, Project, Join
  • Database Design Methodology - 15%
    • Information-Level (Logical) versus Physical-level Design
    • Identification of User Views
    • Logical Database Design: Entity Relationship Diagram, entity/relation, attribute, relationships, cardinality
    • Physical Database Design: tables, primary keys, foreign keys
    • Top-down versus Bottom-up Design: use of both approaches for correct, complete result
  • Detailed Logical Design - 25%
    • Functional Dependence
    • Primary Key
    • First Normal Form (1NF)
    • Second Normal Form (2NF)
    • Third Normal Form (3NF)
    • Relational Schema
    • Update and Delete Data Anomalies
  • Structured Query Language (SQL) Overview - 25%
    • Introduction to SQL
    • Create a table and view using SQL CREATE statement
    • Add data using SQL INSERT statement
    • Query data using simple SELECT statement
    • Modify database structure using SQL ALTER statement
    • Query data dictionary tables using SELECT statement
    • Preserve database integrity using SQL's NOT NULL, CHECK, PRIMARY KEY and FOREIGN KEY constraints
    • Enforce uniqueness by UNIQUE INDEX
  • Detailed Physical Database Design - 15%
    • Identify views, indexes, security, integrity constraints, and additional constraints: uniqueness, mandatory/optional, default value, validation criteria
  • Database Management System Features - 3%
    • Maintain data dictionary - "metadata"
    • Maintain application data
    • Manage integrity constraints for application data
    • Manage shared access to data
    • Facilitate backup and recovery of database
    • Provide security: passwords, views, encryption
    • Facilitate data availability through replication of database
    • Provide utilities for common tasks
  • Database Administrator Responsibilities - 2%
    • Selection, installation and maintenance of DBMS
    • Training
    • Manage data dictionary tables
    • Monitor and improve DBMS performance
    • Manage end user access to DBMS
    • Approve application database design
    • Develop and administer database policies
Prescribed Text(s):
Students can use one of the following editions in BTD210:

Database Systems: Design, Implementation, & Management, 12th Edition
by Carlos Coronel and Steven Morris
ISBN: 9781305627482

Database Systems: Design, Implementation, & Management, 11th Edition
by Carlos Coronel and Steven Morris
ISBN: 9781285196145

Database Systems: Design, Implementation, & Management, 10th Edition
by Carlos Coronel, Steven Morris, and Peter Rob
ISBN: 9781111969608

Some editions are available in print format, new or used.
Some editions are available in eBook format, for varying amounts of time.

As of January 2017, we plan to use this book in the BTD310 course, which is the fall-term successor to this course.

Reference Material:
Online resources are linked on the course web site.
Removable disk drive for use with the College lab room computers.
Promotion Policy:
To obtain a credit in this subject, a student must:
  •     Pass the weighted average of all assessments
  •     Pass the weighted average of the exam and the tests
  •     Pass the final exam
  •     Successfully complete all of the assignments and exercises. Submissions that do not meet specifications will be returned to the student for revision and resubmission.
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)
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.

Labs (approximately 10) 20%
Project(s) 20%
Written Test(s) and Quizzes 35%
Final Exam 25%

Approved By:
Mary-Lynn Manton
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 and 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.
Accomodation 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.

Program Information