MISY 261 Exam 1 verified to pass

MISY 261 Exam 1Transactional Database - correct answer take the form of a relational database which is made of data organized in tables 3 database requirements - correct answer 1.Must Guarantee data integrity, which avoids all duplication or redundant data must be modified (deleted, added, changed) easily 3. it must be easy to extract all necessary information primary key - correct answer a field in which each value has a unique record compound primary key - correct answer a table which does not have a single field where values are all different, but the combination of the fields' values are unique data type - correct answer Text, integer, double (#s that have decimals), date/time, currency, yes/no database - correct answer group of related objects saved in one file object - correct answer could be a table, query, form or report record - correct answer row of data field - correct answer column of data join operation - correct answer something that links the tables cardinality of a relationship - correct answer to one to many to many entity - correct answer a thing or event that the database will contain. for example a band could be the name of a table (entity) attribute - correct answer characteristics and data within the entity One to many relationship - correct answer relationship between course and section. There is one ACCT352 class but many sections (010,011, 080) Many to many relationship - correct answer relationship between student and section. A student can take more than one section because they take multiple courses, and each section has many students. *you would probably need a compound key here, and in any many to many relationship One to One relationship - correct answer person ID to credit card number. Each person has one credit card and each credit card has one owner. business processes - correct answer the heart of how organizations work, how a business goes about doing its work Real Added Value (RAV) - correct answer an activity for which the customer is willing to pay Business Added Value (BAV) - correct answer does not add value to the end consumer but adds value to the business achieving its goals Non-Added Value (NAV) - correct answer no value, just a source of cost, and should be System - correct answer a set of detailed steps to accomplish a specific task