Introduction to Databases

Topics include: Motivation for and capabilities of database management systems; relational data model; relational algebra; functional dependencies and normalization; SQL language; data integrity, security & privacy; entity relationship data modeling; CRUD analysis; stored procedures; JDBC; brief introduction to data warehouses, big data, and XML.

Instructor: Andrew McAllister (please contact the instructor if you need an up-to-date syllabus)
Prerequisite: CS 1073

Why take this course?

• Database design & database programming are fundamental skills for professional software developer.
• This is a core course for UNB’s Bachelor of Computer Science and Bachelor of Science in Software Engineering degree programs.
• Serves as a prerequisite for upper year computer science courses such as Information Security, Programming on the Web, and Big Data Systems.

Course details

Students have six months from the registration date to complete the course. All course exams and/or assignments must be completed by the designated end date.

Assignments and examinations

• 11 x Quizzes (22% total)
• 9 x Assignments (18% total)
• 1 x Final Exam (invigilated, 60%)

The exam(s) for this course will be invigilated on an approved date using Respondus e-proctoring software (LockDown Browser and Monitor). This is a free tool provided with this course, a webcam is required. More information will be given once you have been registered.

Fees and payments

There is a $150 non-refundable/non-transferable online fee per course in addition to applicable tuition & fees. Learn more about tuition and fees and methods of payment.