CPSC 3220 File and Database Processing
COURSE DESCRIPTIONProcessing of sequential, direct, indexed and hashed files. File sorting and searching techniques. Database concepts using the relational model, relational algebra and relational calculus. Database design with E-R modeling techniques, SQL programming. Prerequisite: CPSC 2100 with a minimum grade of C or department head approval. Differential course fee will be assessed.
COURSE OUTCOMESAfter completing this course students should be able to:
1. Implement file reading and writing programs using PHP.
2. Identify file access schemes, including sequential, direct and indexed sequential file access.
3. Describe file-sorting and file-searching techniques.
4. Describe data compression and encryption techniques.
5. Design a rational database using E-R modeling techniques.
6. Build a relational database.
7. Write database queries using SQL.
8. Implement a web-based relational database using MySQL.
(Required) Murach, Joel and Ray Harris. Murach’s PHP and MySQL. Murach, ISBN-13 978-1-890774-56-1
(Required) Rockoff, Larry. Language of SQL. Cengage, ISBN 978-1-435457-51-5
Lecture 1: Course Overview and File Storage Basics
Lecture 2: Introduction to web development and PHP
Lecture 4: How to work with form data
Lecture 5: How to code control statements
Lecture 6: How to work with strings and numbers
Lecture 7: How to work with dates
Lecture 8: How to create and use arrays
Lecture 10: How to create and use objects
Lecture 13: Indexed Files
Lecture 14: Hashing
Lecture 17: How to use the MVC pattern to organize your code
Lecture 19: Creating a database
Lecture 20: Designing a database
Lecture 21: Professional PHP for working with MySQL
Lecture 22: HTML, PHP, MySQL Exercises