20471065
Description
Flashcards by Adriana Vincelli-Joma, updated more than 1 year ago
|
Created by Adriana Vincelli-Joma
almost 5 years ago
|
|
| Question | Answer |
| What is content? Why can it be challenging to manage? | Content: -something of value that can be considered an asset -closely related to intellectual property -varies by industry Managing challenges: -processing and storing right content -getting right content to right person in right format at right time |
| What is purpose of database? What does it contain? | Purpose: -keep track of things Contain: -bytes -columns/fields -rows/records -tables/files Structure: -tables/files + relationships among rows in tables + metadata |
| What is a DBMS? What does it do? | DBMS: -program that creates, processes, and administers a database What does it do: *creating database: -create tables, relationships, and other structures -define new table or modify table *processing database -read, insert, modify, or delete data *administering database: -set up security system -back up data -add structure to improve performance -remove data |
| Components of database application | -forms: used to read insert, modify, and delete data -reports: show data in structured context and may compute values -queries: means of getting answers from database data -database application program: process logic specific to business need; enables database processing over Internet |
| Database application system | 1. user 2. database application 3. DBMS 4. database |
| Enterprise vs Personal DBMS | Enterprise: -process large organizational workgroup databases -support many users and many different database applications Personal: -designed for smaller, simpler database applications -supports fewer than 100 users |
Want to create your own Flashcards for free with GoConqr? Learn more.