Term
|
Definition
|
|
Term
|
Definition
originally called "file" is an entity --> something you want to keep track of
each table has a single theme
used in DB |
|
|
Term
|
Definition
| single theme (topic/subject) |
|
|
Term
|
Definition
| has to have a primary key (sometimes 2, b/c if you use just one, there could be multiple matches) |
|
|
Term
| Why is a database said to be a "self-describing collection of integrated recods"? |
|
Definition
|
|
Term
|
Definition
| data that describes data (the type of datay - data type: string; text, memo, dat/time, currency, Yes/No, etc.) |
|
|
Term
|
Definition
| listed under tables (what makes up a table) - describes an entity |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| achieving goals & objectives |
|
|
Term
|
Definition
| right product, right price @ right time |
|
|
Term
|
Definition
| transaction processing system - (day-to-day) feeds data to other information systems |
|
|
Term
|
Definition
| what you want to test is what you're testing |
|
|
Term
|
Definition
|
|
Term
|
Definition
| recorded facts and figures |
|
|
Term
|
Definition
|
|
Term
|
Definition
| local area network (same geographical boundaries; ex: on campus) |
|
|
Term
|
Definition
| wide area network (crosses geographical boundaries) |
|
|
Term
|
Definition
|
|
Term
|
Definition
| has to be unique - it's the identifier used to relate to the other tables |
|
|
Term
|
Definition
| computers process numbers faster than anything |
|
|
Term
|
Definition
| collection of tables, relationships, metadata |
|
|
Term
|
Definition
| representation of how you see your business |
|
|
Term
|
Definition
| copied from another table, creates a relationship with another table |
|
|
Term
|
Definition
|
|
Term
| best way to identify attributes |
|
Definition
|
|
Term
| problem with creating another table |
|
Definition
|
|
Term
|
Definition
| maintaining and assuring accuracy and consistency of data |
|
|
Term
|
Definition
getting rid of dirty data - each table has 1 (single) theme
AKA transforming - said to go into normal form |
|
|
Term
| when would you use a non-normalized table? |
|
Definition
| if it's a simple business (ex: video rental) trying to run on low cost (one table) |
|
|
Term
| what type of DB would a small business most likely use? |
|
Definition
| Access, MySQL, XML --> all free |
|
|
Term
| What type of DB would a large business use? |
|
Definition
|
|
Term
|
Definition
person or group that administers DB - should never be a user of the DB b/c they can modify it to work best for their needs - not the good of the whole - has to be someone people feel comfortable to talk to;
help business acheive goals & objectives |
|
|
