Chapter 5 Flashcards
(24 cards)
What is content?
Content is related to intellectual property, a form of creative endeavour that can be protected through trademark, patent, copyright, industrial design or integrated circuit topography.
What does content management include?
Management of content data(Database Management Systems), Presentation of content(Content management systems).
What is the content management challenge?
Processing and storing the right content, getting right content to the right person in the right format at the right time.
What is the difference between spreadsheets and databases?
Spreadsheets keep lists involving a single important thing(concept), databases keep multiple lists of related things(themes)
What is a character?
the most basic logical data element - single alphabetic, numeric or symbol, typically Byte.
What is a field(or a column)?
Typically a group of characters(could be one) -represnets an attribute of an entry.
What is a record(or a row)?
Logically related fields of data grouped together can be either fixed or variable length.
What is a table(also called file)?
a group of related records-frequently classified by application or use.
What is database?
An integrated collection of logically related records or objects-usually shared between applications.
What is a master record?
A record representing the status of a business entry.
What is a transaction record?
A record representing an event(change) in business.
What does the database consist of?
Database is a collection of tables+relationships+metadata.
What is a primary key?
Column that identify unique row in table
What are foreign keys?
A keys in a different table than the one in which they reside.
What kind of relationships are there?
One to one, One to many, Many to many.
What is metadata?
Data that describes data.
What is a database management system(DBMS)?
DBMS is a program that creates, process, and administers database.
What is a database application?
A database application is a collection of forms, reports, queries, and application programs that process a database, and make database more accessible and useful.
What is an enterprise DBMS?
Process large organizational and workgroup databases, support multi-users.
What is the personal DBMS?
Designed for smaller, simpler database applications.
What can you do with content?
Retrieve(locate and obtain required data), store(save new data so it can be found), modify(change existing data), delete(delete existing data).
What is transaction processing?
It involves the use of human procedures and/or computer programs to store, retrieve, and manipulate records of events.
What is an entity?
A thing whose status is relevant to the operation and managent of the organisation.
What is an event?
A change in the status of at least one entity.
