Concept explainers
Match the following terms and definitions:
________data
________database application
________constraint
________repository
________metadata
________data warehouse
________information
________user view
________database management system
________data independence
________database
________enterprise resource planning (ERP)
________systems development life cycle (SDLC)
________prototyping
________enterprise data model
________conceptual schema
________internal schema
________external schema
a. data placed in context or summarized
b. application
c. facts, text, graphics, images, etc.
d. a graphical model that shows the high-level entities for the organization and the relationships among those entities
e. organized collection of related data
f. includes data definitions and constraints
g. centralized storehouse for all data definitions
h. separation of data description from programs
i a business management system that integrates all functions of the enterprise
j. logical description of portion of
k. a software application that is used to create, maintain, and provide controlled access to user databases
I. a rule that cannot be violated by database users
m. integrated decision support database
n. consist of the enterprise data model and multiple user views
o. a rapid approach to systems development
p. consists of two data models: a logical model and a physical model
q. a comprehensive description of business data
r. a structured, step-by-step approach to systems development
Want to see the full answer?
Check out a sample textbook solutionChapter 1 Solutions
Modern Database Management (12th Edition)
- An in-memory database (IMDB) is a database management system that stores the entire data-base in ____________ a. random access memory b. read only memory c. distributed servers d. virtual memoryarrow_forward8. _____________ is a classical approach to database design? a. Left – Right approach b. Right – Left approach c. Top – Down approach d. Bottom – Up approacharrow_forwardWhat are the key considerations when designing a database for scalability and high availability in a distributed environment?arrow_forward
- Currently, what is our understanding of the designs and schemas of database systems? What is the rationale behind initiating the procedure of database creation?arrow_forwardWhat are the requirements for designing a physical database?arrow_forwardWhat are the main considerations and trade-offs involved in choosing between a relational database management system (RDBMS) and a NoSQL database for a specific application's data storage needs?arrow_forward
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
- Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningFundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningEnhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage Learning