Databases Flashcards
What is the most important asset of modern companies
information
What are 3 reasons to use a Database
preserve data integrity, eliminate redundancy, limit data view
What are the 3 components of a database
tables and files, relationships among rows in tables, metadata
each table in a database should be organized around a theme
true
each table will have at least one column called what
a primary key
def of primary key
column or group of columns that identifes a unique row in a table
def of foreign key
a non-key column in one table that links to a primary key in another table
What doe Relational Databases do
store data in tables that represent relationships using foreign keys
What is MetaData
data describing data; makes databases a lot easier to use
What are the 3 main functions of a DBMS
create, process, administer
what are 4 diff examples of database application and what is a database application
forms, reports, queries, application programs (order entry, purchasing, warehouse mgmt)
a database application is a set of forms, reports, queries, application programs that process a database
What do database applications do specifically
CRUD create, read, update, delete
What is the language that DBMS speak
SQL structured query language
How do Databases create competitive advantage
they connect activities across the value chain by improving connections in the steps
What is the role of application programs in web surfing
Application programs serve at th cusion between the webserver and the DBMS and can be created to generate dynamic pages
