Data Process and Structure

Catalog description

This course examines database models from a managerial perspective with an in-depth focus on business data requirements, operational rules, procedures, and logical structure. The course covers relational algebra and calculus, SQL queries, and business rules; database applications and Internet applications; indexing, disks and files; query evaluation; external sorting, evaluating relational operators; the query optimizer; transactional management and concurrency control; and data recovery. Students research and present real-world scenarios; develop automated business process solutions through evaluation and discussion to gain a comprehensive knowledge and understanding of data process and structures, database design, and database management.