Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
MIS chapter 5
| Question | Answer |
|---|---|
| what is content? | property |
| Intellectual property | a form of creative endeavor that can be protected through a trademark, patent, copywrite, industrial design or integrated circuit topography |
| what is the challenge for employees today regarding content? | presenting info appropriately for various stakeholders inside and outside of an organization |
| what are computer systems represented as? | bytes |
| data base management system (DBMS) | handles management of different types of data. central to the management of content |
| content management systems (CMS) | developed to help companies organize process of presentation of content. helps manage each step of this process and enables a company to standardize the look and feel of a website |
| what does a database do? | keeps track of things that involve more than one theme |
| data base | self-describing collection of integrated records |
| byte | a character of data |
| columns | bytes grouped into these; ex. student number/ student name; fields |
| rows (records) | columns grouped into these; the collection of data of all columns |
| table (file) | group of similar rows or records |
| key | a column or group of columns that identifies a unique row in a table; every table must have one |
| foreign keys | columns that fulfill a role like that of SN in the email |
| relational databases | databases that carry their data in the form of tables and that represent relationships using foreign keys |
| metadata | data that describes data |
| what does the format of metadata depend on? | software product that is processing the data |
| what does the presence of metadata do? | makes databases more useful than spreadsheets or data in other lists |
| how do we find out what a database contains? | we look at the metadata inside |
| is a data base useful by itself? | no |
| pure databases | are correct but in raw form, aren't useful |
| database application system | applications make database data more accessible and useful |
| database management system (DBMS) | a program used to create, process, and administer a database |
| do organizations develop their own DBMS? | rarely |
| what are some popular DBMS products? | DB2 from IBM; Access and SQL from Microsoft |
| How is DBMS different from databases? | DBMS: software program; databases: collection of tables, relationships and metadata |
| what 4 operations do applications use the DBMS for? | 1. read 2. insert 3. modify 4. delete data |
| structured query language (SQL) | international standard language for processing a database; only language that relational databases use when communicating data from a database |
| database application | a collection of forms, reports, queries, and application programs that pocess a database |
| form | a typical application data entry form shows a typical report |
| what are data entry forms used for? | read, insert, modify, delete data |
| what do reports show? | data in a structured context |
| query form | where someone typed in the keyword for what their looking for |
| multiuser processing | poses problems that managers need to be aware of |
| lost-update problem | exemplifies on of the special characteristics of multiuser database processing; |
| how do you prevent the lost-update problem? | some type of locking must be used to coordinate the activities of users who are unaware of eachother |
| what 2 categories do DBMS products fall under? | Enterprise DBMS; personal DBMS |
| Enterprise DBMS | products process large organizational and workgroup databases ; support many users and many database applications |
| Personal DBMS | products are designed for smaller, simpler database applications; products used for personal or small workgroup applications that involve fewer than 100 users |
Created by:
alyshabennett