INSY 3432- Midterm Exam Guide - Comprehensive Notes for the exam ( 14 pages long!)

• School: Fordham University
• Department: Information and Communications Systems
• Course: INSY 3432
• Professor: Kamesam

Document Summary

If a (b,c), then a b & a c. Database examples: single-user database applications, multiuser database applications, ex: customer relationship management (crm), enterprise resource planning (erp, e-commerce database applications, reporting & data mining database applications. The components of a database system: database system: info system composed of users, database applications, database management system (dbms), & database, database. Personal vs. enterprise-class database systems: personal database system: dbms product intended for use by individual/small workgroup (ex: microsoft access, enterprise-class database system: dbms product capable of supporting operating requirement of large organizations. Integrate 2+ databases: reverse engineer & design new databases using normalization principles & data model transformation. Bcnf (step-by-step method)/designing tables so that every determinant is candidate key (straight-to-bcnf/general normalization method: steps. Chapter 5: data model: model of users" data requirements usually expressed in terms of entity- relationship model, generalized, non-dbms specific design.