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. Data modeling history 2. Dynamic storage management and compression techniques 3. Relational data model 5. Query languages 6.