This course provides an introduction to Databases, followed by a review of: entity relationships, normalization modeling, Structured Query Language (SQL); along with a systems analysis from a database perspective. Students will complete a business case project where they will analyze a case with a view to constructing a database. They will also have an opportunity to construct a relational database solution (model only – no coding).
Date First Offered:
Total Hours: 45
Lecture Hours: 45
This course is offered online:
Database Systems in Organizations
Data Modeling with Entity-Relationship Data Model
Principles of System Analysis
Business Process for Constructing a Database Solution
MS Access, PostgreSQL, and MYSQL
Upon successful completion of this course the student has reliably demonstrated the ability to:
- Describe the role of database systems in organizations
- Perform data modeling using the entity-relationship data model
- Apply the principles of systems analysis,
- Analyze business process to construct a database solution
- Operate MS ACCESS, PostgreSQL or MYSQL
Final Exam: 30 %
Quizzes and Tests: 20 %
Assignments: 20 %
Other: 30 %
Percentage of Individual Work:
Course Offered in Other Programs:
-Policies and Procedures: Students registered in the Information and Communication Technology Program are guided by the policies and procedures of their registering college. You are encouraged to review the policy definitions and guidelines of the college at which you are registered. You can view these policies and procedures by visiting your college's website or by contacting the Program Coordinator.
-Plagiarism Guidelines: The instructor will advise the student in writing if plagiarism is suspected; a copy of this letter should be sent to the coordinator at the registering college; this should be done in a timely manner. If a student commits plagiarism, the policy of the registering college prevails.
-Attendance: As this is an on-line course, attendance requires participation in the course, not time in a classroom. However, students must ensure that they complete their required participation in online discussions and other similar assignments. Online meeting/discussion forums times may be arranged in conjunction with the students availability.
-The student will not successfully complete the course without passing the final exam and completing at least 50% of scheduled quizzes and tests.