This course is designed for undergraduate and graduate students with minimal background in data modeling. Students are introduced to dynamic file systems, clustering, index, and different compression techniques. They study data abstraction and review domains, sets, attributes, relational algebra and predicate calculus in relationship to relational database. SQL, QBE, and embedded SQL are utilized with different database operations. SQL command validations with grammar and ANSI standards are reviewed.
Students utilize CASE tools for logical and physical modeling of a database.
Final project with presentation involves modeling an SQL engine. Assignments will only be accepted if they are handed in prior to the due date or at the beginning of class on the due date. Format for submission of assignments and programs will be provided with the first assignment. Exams and quizzes should be taken during the scheduled class time. Quizzes will be given on Wednesdays at the end of the class.