INMT 341 Exam 2 UPDATED Study Guide
QUESTIONS AND CORRECT ANSWERS
File-oriented Processing - CORRECT ANSWERS data redundancy;
siloed - departments didn't talk
Database-oriented Processing - CORRECT ANSWERS data sharing;
central database for company
What are the steps of the database analysis and design process? - CORRECT
ANSWERS 1. map reality into a conceptual model
2. map conceptual model into a logical design
3. create a physical database using DBMS software
What are the categories entities can fall into? - CORRECT ANSWERS
REAL
Resource, event, agent, location
What are the order to cash events that can be entities? - CORRECT ANSWERS
sales quote, sales order, sale (shipping and billing), cash receipt, make
deposit
What are the procure to pay events that can be entities? - CORRECT
ANSWERS purchase requests, purchase order, purchase (recognize
liability and receive goods), cash disbursement
What are the rules for relationships within a conceptual model? - CORRECT
ANSWERS 1. events are related chronologically
2. events are related to internal agents and resources
3. events where resources are exchanged involve external agents
QUESTIONS AND CORRECT ANSWERS
File-oriented Processing - CORRECT ANSWERS data redundancy;
siloed - departments didn't talk
Database-oriented Processing - CORRECT ANSWERS data sharing;
central database for company
What are the steps of the database analysis and design process? - CORRECT
ANSWERS 1. map reality into a conceptual model
2. map conceptual model into a logical design
3. create a physical database using DBMS software
What are the categories entities can fall into? - CORRECT ANSWERS
REAL
Resource, event, agent, location
What are the order to cash events that can be entities? - CORRECT ANSWERS
sales quote, sales order, sale (shipping and billing), cash receipt, make
deposit
What are the procure to pay events that can be entities? - CORRECT
ANSWERS purchase requests, purchase order, purchase (recognize
liability and receive goods), cash disbursement
What are the rules for relationships within a conceptual model? - CORRECT
ANSWERS 1. events are related chronologically
2. events are related to internal agents and resources
3. events where resources are exchanged involve external agents