Database Management Systems

Curriculum guideline

Effective Date:
Return to Course
Print Guideline
Course
CSIS 2300
Discontinued
No
Course code
CSIS 2300
Descriptive
Database Management Systems
Faculty
Commerce & Business Administration
Credits
3.00
Start date
End term
201430
PLAR
Yes
Semester length
15 Weeks X 4 Hours per Week = 60 Hours
Max class size
35
Contact hours
Lecture: 2 Hours per week Seminar: 2 Hours per week Total: 4 Hours per week
Method(s) of instruction
Lecture
Seminar
Learning activities

Lecture, seminar and hands-on exercises in the lab

Course description
This course will provide the student with knowledge of database concepts. Emphasis will be placed on designing, modifying, and querying a database using a DBMS such as SQL Server or MS Access. The course will discuss data models, database design and implementation, SQL, stored procedures, triggers, data warehousing, principals of normalization and Access form integration.

Included in this course will be extensive documentation and verbal communication skills required to succeed in the development process.

Note: Students who have received credit for CISY 2300 will not receive further credit by taking CSIS 2300.
Course content
  1. Overview: Concept of information systems - entities, attributes, values
  2. Data model overview
  3. Database development and systems life-cycle
  4. Database integrity, privacy, data independence
  5. Indexed files, primary vs. foreign keys
  6. Data normalization: 1st, 2nd, 3rd and BCNF
  7. Understanding data requirements
  8. Conceptual, logical and physical design
  9. Queries/views using a database management system
  10. Database planning, design and administration
  11. Structured query language (SQL)
  12. Advanced SQL and problem solving
  13. Stored procedures and triggers
  14. Brief Introduction to data warehousing
  15. Report design using MS Access
  16. Form design and integration using MS Access
Learning outcomes
The student will be able to:
  1. Describe the database approach, its environment, and database application life cycle;
  2. Explain the functions of a relational database model;
  3. Understand and apply data modeling techniques;
  4. Apply techniques of database design, including:
    • Enhanced entity-relationship modeling;
    • Functional dependencies and normalization;
    • Derivation of relational schema from EER model;
  5. Recognize different roles in data administration;
  6. Apply techniques of data organization in a database environment employing the host language facility of a database management system (e.g. SQL Server);
  7. Demonstrate an understanding of stored procedures and triggers;
  8. Demonstrate an understanding of SQL from the basic commands to more advanced commands using Group By, Having:
    • Work with MS Access to demonstrate the integration of data and forms;
    • Demonstrate the documentation process of turning requirements into a data model;
    • Understand apply report design and data integration;
    • Explain the uses and purpose of work related documentation;
    • Work with team members and understand the communication process that occurs during the database design process.
Means of assessment
Assignments/Projects (Minimum: 3) 25% - 45%
Participation    0% - 5%
Tests/Quizzes (Minimum: 2) 10% - 40%
Final Examination     25% - 30%
Total       100%
Textbook materials

Textbooks and Materials to be Purchased by Students

Connolly and Begg. Database Systems. Latest Edition. Addison-Wesley.

OR

Garcia-Molina, Ullman, Widom. Database Systems: The Complete Book. Latest Edition. Prentice Hall.

OR

Kroenke. Database Processing: Fundamentals, Design, and Implementation. Latest Edition. Prentice Hall.

OR  Instructor preference

Prerequisites

CSIS 2200 or CISY 2200

Which prerequisite

CSIS 3540