Lecture, seminar and hands-on exercises in the lab
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.
- 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
- Stored procedures and triggers
- Brief Introduction to data warehousing
- Report design using MS Access
- Form design and integration using MS Access
- Describe the database approach, its environment, and database application life cycle;
- Explain the functions of a relational database model;
- Understand 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;
- Recognize different roles in data administration;
- Apply techniques of data organization in a database environment employing the host language facility of a database management system (e.g. SQL Server);
- Demonstrate an understanding of stored procedures and triggers;
- 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.
|Assignments/Projects (Minimum: 3)||25% - 45%|
|Participation||0% - 5%|
|Tests/Quizzes (Minimum: 2)||10% - 40%|
|Final Examination||25% - 30%|
Textbooks and Materials to be Purchased by Students
Connolly and Begg. Database Systems. Latest Edition. Addison-Wesley.
Garcia-Molina, Ullman, Widom. Database Systems: The Complete Book. Latest Edition. Prentice Hall.
Kroenke. Database Processing: Fundamentals, Design, and Implementation. Latest Edition. Prentice Hall.
OR Instructor preference