|Course Name:||Database Design Principles|
|Offered Date:||Winter - 2018 | Other versions|
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)
|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
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.|
Students can use one of the following editions in BTD210:
Database Systems: Design, Implementation, & Management, 12th Edition
by Carlos Coronel and Steven Morris
Database Systems: Design, Implementation, & Management, 11th Edition
by Carlos Coronel and Steven Morris
Database Systems: Design, Implementation, & Management, 10th Edition
by Carlos Coronel, Steven Morris, and Peter Rob
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.
Online resources are linked on the course web site.
Removable disk drive for use with the College lab room computers.
To obtain a credit in this subject, a student must:
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.
|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 firstname.lastname@example.org.
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.
BTD210 Course Outline