Course
Discontinued
No
Course Code
CSIS 2300
Descriptive
Database I
Department
Computing Studies & Information Systems
Faculty
Commerce & Business Administration
Credits
3.00
Start Date
End Term
201820
PLAR
Yes
Semester Length
15 Weeks
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 database design, development and querying using DBMS installed on both LAN and cloud environments. Concepts covered include ER modelling, normalization, and database design theory. Hands on activities will allow students to create, maintain and query various databases. An introduction and overview of stored procedures, triggers and data warehousing will also be covered.
Note: Students who have received credit for CISY 2300 will not receive further credit by taking CSIS 2300.
Note: Students who have received credit for CISY 2300 will not receive further credit by taking CSIS 2300.
Course Content
- Overview: Concept of information systems - entities, attributes, values
- Data model overview
- Database development and systems life-cycle
- Database integrity, privacy, data independence
- Indexed files, primary vs. foreign keys
- Data normalization: 1st, 2nd, 3rd and BCNF
- Understanding data requirements
- Conceptual, logical and physical design
- Queries/views using a database management system
- Database planning, design and administration
- Structured query language (SQL)
- Advanced SQL and problem solving
- Brief introduction to stored procedures and triggers
- Brief introduction to data warehousing
- Report design techniques
Learning Outcomes
The student will be able to:
- Describe the database approach, its environment, database application life cycle and roles in data administration;
- Explain the functions of a relational database model;
- Explain and apply data modeling techniques;
- Apply techniques of database design, including:
- Enhanced entity-relationship modeling;
- Functional dependencies and normalization;
- Derivation of relational schema from EER model;
- Explain and apply the necessary commands to create, maintain and query a database within a DBMS;
- Apply SQL statements from the basic commands to more advanced commands;
- Apply simple report design techniques to present query data results for users;
- Demonstrate an understanding of stored procedures and triggers;
- Demonstrate an understanding of data warehousing.
Means of Assessment
| Assignments/Projects (Minimum: 3) | 25% - 45% |
| Participation | 0% - 5% |
| Tests/Quizzes (Minimum: 2) | 10% - 40% |
| Final Examination | 20% - 30% |
| Total | 100% |
Textbook Materials
Textbooks and Materials to be Purchased by Students
Kroenke. Database Concepts. Latest Edition. Prentice Hall.
or other textbooks as approved by the department.
Prerequisites
CSIS 2200 or CISY 2200