click below
click below
Normal Size Small Size show me how
CMIS U4
| Question | Answer |
|---|---|
| What is content? | Something of value that can be considered an asset |
| Why is content difficult to manage? | Organizations deal with huge volumes of content, many formats, and rapidly growing amounts of digital data |
| What is an example of content in advertising? | Commercials and pictures |
| What is an example of content in banking? | Customer account information |
| What is a database? | A collection of related data used to keep track of things involving more than one theme |
| What is the purpose of a database? | To keep track of things involving more than one theme |
| Why are databases better than spreadsheets for complex information? | Databases can manage large amounts of related information more efficiently |
| What does a database contain? | Tables, relationships, and metadata |
| What is metadata? | Data about data |
| Examples of metadata | Data sources, formatting details, and descriptions of data |
| What does DBMS stand for? | Database Management System |
| What is a DBMS? | Software used to create, process, and administer databases |
| Examples of DBMS software | Microsoft Access and Oracle |
| What are the 3 main functions of a DBMS? | Create database structures, process databases, and administer databases |
| What database structures does a DBMS create? | Tables, relationships, and other database structures |
| How does a DBMS process a database? | It allows users and applications to read, insert, modify, and delete data |
| What does SQL stand for? | Structured Query Language |
| What is SQL? | The international standard language used to process databases |
| How does a DBMS administer a database? | By managing security systems, user accounts, passwords, and permissions |
| What is a database application? | A collection of forms, reports, queries, and application programs used to process a database |
| What are forms in a database application used for? | Data entry, modifying data, and viewing data |
| Example of a form in a database application | A customer registration form |
| What are reports in a database application? | Structured presentations of data |
| Example of a report in a database application | A report card calculating weighted grades |
| What are queries in a database application used for? | Searching, retrieving, and filtering data |
| Example of a query in a database application | Searching customers by name |
| What are application programs in a database application? | Programs containing specialized logic for business needs |
| Examples of application programs | Automatic calculations and grading systems |
| What is multiuser processing? | Allowing multiple users to access and modify data simultaneously |
| What problem can occur during multiuser processing? | The lost-update problem where users overwrite each other’s changes |
| Example of the lost-update problem | Two employees updating inventory at the same time |
| What is an enterprise DBMS? | A DBMS used for large organizational databases with many users |
| Example of an enterprise DBMS | Oracle |
| What is a personal DBMS? | A DBMS used for smaller databases and fewer users |
| Example of a personal DBMS | Microsoft Access |
| How many users does a personal DBMS typically support? | Fewer than 100 users |
| Why are databases important to organizations? | They organize and manage information efficiently |
| What is the difference between a spreadsheet and a database? | Spreadsheets track single themes while databases manage multiple related themes |
| Example of a spreadsheet use | Tracking grades for one class |
| Example of a database use | Managing students, courses, instructors, and grades together |
| What is the role of a DBMS in security? | It manages passwords, permissions, and user accounts |
| Why is digital content management important? | Organizations must manage and present growing amounts of digital information effectively |