Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
20 Cards in this Set
- Front
- Back
Intellectual Property |
Form of creative endeavour that can be protected through a trademark, patent, copyright, industrial design, or integrated circuit topography |
|
What is the purpose of a Database? |
to keep track of things that involve more than one theme |
|
Content Management Systems (CMS) |
-an information system that tracks org. documents, webpages, graphics, and related materials |
|
Database Application System
|
-applications that make database data more accessible and useful
-consists of forms, formatted reports, queries, and app. programs |
|
Database Management Systems (DBMS) -Diff. between database and a DBMS |
-program used to create, process, and administer a database **companies license DBMS products from vendors such as IBM, Access, etc. -DBMS is a software program; a database is a collection of tables, relationships, and metadata |
|
Database |
-Self-describing collection of integrated records -Collection of tables plus relationships among the rows in tables, plus special data (called metadata), that describe the structure of the database |
|
Data Heirarchy |
1) Bit 2) Byte 3) Columns/ Fields 4) Row/ Records 5) Tables/ Files 6) Data |
|
-Master Record -Transaction Record |
-A record representing the status of a business entity -A record representing and event (change) in the business |
|
Key |
A column or group that identifies a unique row in a table |
|
Foreign Key |
Keys of a different table form the one in which they reside |
|
Relational Databases
|
Database that carry their data in the form of tables that represent relationships using foreign keys
|
|
Metadata |
Data that describes data; ALWAYS a part of the database |
|
Three functions of the DBMS: |
1) Create the database and its structures 2) Process the database 3) Administer the database |
|
Applications use the DBMS for 4 operations: |
1) read 2) insert 3) modify 4) delete ... data |
|
Structured Query Language (SQL) |
International standard language for processing a database -a QUERY can be thought of as a question -a SQL can be thought of as a formal way of putting a question to a database |
|
Database Application
|
-A collection of forms, reports, queries, and application programs that process a database
-A database may have more than one app, and each app. may have one or more users |
|
-Multiuser Processing
-Lost-update Problem |
-When multiple users process the database at the same time -Problem in which two users accessing the same data, updates at different times causing incorrect information |
|
Transaction Processing Concepts |
Entity: thing whose status is relevant to the operation and management of the organization
Event: a change (transaction) in the status of at least one entity |
|
Managerial Data Issues |
Content: What data should be collected Access: What data should be given to what users Logical Structure: How will the data be organized Physical Organization: Location of the data |
|
Enterprise DBMS Personal DBMS -Diff. between the 2 |
-products process large organizational and workgroup databases; support many users and many different database apps. -products designed for smaller, simpler database apps; for personal or workgroup apps. that involve fewer than 100 users (normally less than 15) |