Databases Flashcards Preview

MIS Test 1 > Databases > Flashcards

Flashcards in Databases Deck (18):
1

What is the most important asset of modern companies

information

2

What are 3 reasons to use a Database

preserve data integrity, eliminate redundancy, limit data view

3

What are the 3 components of a database

tables and files, relationships among rows in tables, metadata

4

each table in a database should be organized around a theme

true

5

each table will have at least one column called what

a primary key

6

def of primary key

column or group of columns that identifes a unique row in a table

7

def of foreign key

a non-key column in one table that links to a primary key in another table

8

What doe Relational Databases do

store data in tables that represent relationships using foreign keys

9

What is MetaData

data describing data; makes databases a lot easier to use

10

What are the 3 main functions of a DBMS

create, process, administer

11

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

12

What do database applications do specifically

CRUD create, read, update, delete

13

What is the language that DBMS speak

SQL structured query language

14

How do Databases create competitive advantage

they connect activities across the value chain by improving connections in the steps

15

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

16

what is EDI

electronic data intechange

17

relationship between bandwidth and throughput

bandwidth is what the ISP promises you and is a theoretical max but in reality you get throughput and throughput

18

What is the relationship between TCP and IP

TCP is only on the end computers and checks for missign packets and ensures complete delivery. IP is in the middle between two TCPs and is just the internet postman and is connectionless