Chapter 5 Flashcards
Content management includes (2)
- Database management systems (DBMS)
- Content management systems (CMS)
Spreadsheets
Lists involving a single important thing. ex: list of songs
Databases
Multiple lists of related things. ex: artists, albums, songs
Master record
Status of a business entity. ex: a customer account, an inventory item record
Transaction record
An event (change) in the business. ex: payments, invoice issued, inventory reduction
Primary key
A field that uniquely identifies records
Relational database
Use foreign keys to relate multiple tables to each other
Foreign key
Relational key that refers to the primary key of another table
Database
Tables or files + Relationships among rows in tables + metadata
Are self-describing
– contains, within itself, a description of its contents
Metadata
Data about the data. ex: supplier city
Types of relationships
- One to one (person and shoe size)
- One to many (person name and friends names)
- Many to many (students and courses)
Database management system (DBMS)
Program used to create, process, and administer database. ex: Microsoft Access
Used to create tables, relationships, other structure in databases
Structured query language (SQL)
International standard for processing a database
Database application
Collection of forms, reports, queries and application programs that process a database and make its contents more accessible
Forms
User interface. Used to read, insert, modify and delete data
