click below
click below
Normal Size Small Size show me how
Exit - Info Systems
Information Systems
| Term | Definition |
|---|---|
| Database | Organized collection of structured data. |
| Table | Collection of related data entries (rows/columns). |
| Primary Key | Unique identifier for each record in table. |
| Foreign Key | Field linking data between tables. |
| SQL | Structured Query Language for managing databases. |
| SELECT Statement | Retrieves data from a database. |
| WHERE Clause | Filters results meeting specific condition. |
| Aggregate Function | Performs calculation on data set (SUM, AVG). |
| Data Warehouse | Central repository of integrated data. |
| Data Mining | Analyzing data for hidden patterns. |
| Business Intelligence (BI) | Systems for analyzing business information. |
| Referential Integrity | Ensures relationships between tables are consistent. |