Database Organization and Management I

An introductory class in databases, explaining what a database is and how to use one. Topics include database design, ER modeling, database normalization, relational algebra, SQL, physical organization of records and blocks, heap files, sorted files, hashing, extensible hashing, linear hashing and B trees. Each student will design, load, query and update a nontrivial database using the Oracle DBMS.