WVU Bcor 330 exam #2 (all solved)

database management system differs from a tradition file system in that a database management system correct answers -can centralize data database application correct answers is a collection of forms, reports, queries and programs that processes a database. true of the components of an entity(object)-relationship data model? correct answers -attributes describe the characteristics of entities database correct answers is a collection of data organized to serve many applications efficiently by centralizing the data and controlling redundant (unnecessary) data -keeping track of data is the primary reason metadata correct answers -describes the structure of a database tables that are not normalized will likely have problems related to... correct answers data integrity (problems) -incorrect or inconsistent information -users lose confidence information -system gets a poor reputation -can only occur if data are duplicated reports correct answers -can be used to compute values as they present data -structured presentation of data using sorting, grouping, filtering, and other operations forms correct answers views data, insert new, update existing, delete existing data provides security, data consistency, special purpose processing ex. handle out of stock situations steps required in transforming a data model into a relationship database- correct answers -normalize tables as necessary so easy has one theme. -represent each entity with a table -represent relationships primary key: correct answers -a column or group of columns that identifies a UNIQUE row in a table Query