Chapter 5

Question 1

What is content?

Answer 1

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.

Question 2

What does content management include?

Answer 2

Management of content data(Database Management Systems), Presentation of content(Content management systems).

Question 3

What is the content management challenge?

Answer 3

Processing and storing the right content, getting right content to the right person in the right format at the right time.

Question 4

What is the difference between spreadsheets and databases?

Answer 4

Spreadsheets keep lists involving a single important thing(concept), databases keep multiple lists of related things(themes)

Question 5

What is a character?

Answer 5

the most basic logical data element - single alphabetic, numeric or symbol, typically Byte.

Question 6

What is a field(or a column)?

Answer 6

Typically a group of characters(could be one) -represnets an attribute of an entry.

Question 7

What is a record(or a row)?

Answer 7

Logically related fields of data grouped together can be either fixed or variable length.

Question 8

What is a table(also called file)?

Answer 8

a group of related records-frequently classified by application or use.

Question 9

What is database?

Answer 9

An integrated collection of logically related records or objects-usually shared between applications.

Question 10

What is a master record?

Answer 10

A record representing the status of a business entry.

Question 11

What is a transaction record?

Answer 11

A record representing an event(change) in business.

Question 12

What does the database consist of?

Answer 12

Database is a collection of tables+relationships+metadata.

Question 13

What is a primary key?

Answer 13

Column that identify unique row in table

Question 14

What are foreign keys?

Answer 14

A keys in a different table than the one in which they reside.

Question 15

What kind of relationships are there?

Answer 15

One to one, One to many, Many to many.

Question 16

What is metadata?

Answer 16

Data that describes data.

Question 17

What is a database management system(DBMS)?

Answer 17

DBMS is a program that creates, process, and administers database.

Question 18

What is a database application?

Answer 18

A database application is a collection of forms, reports, queries, and application programs that process a database, and make database more accessible and useful.

Question 19

What is an enterprise DBMS?

Answer 19

Process large organizational and workgroup databases, support multi-users.

Question 20

What is the personal DBMS?

Answer 20

Designed for smaller, simpler database applications.

Question 21

What can you do with content?

Answer 21

Retrieve(locate and obtain required data), store(save new data so it can be found), modify(change existing data), delete(delete existing data).

Question 22

What is transaction processing?

Answer 22

It involves the use of human procedures and/or computer programs to store, retrieve, and manipulate records of events.

Question 23

What is an entity?

Answer 23

A thing whose status is relevant to the operation and managent of the organisation.

Question 24

What is an event?

Answer 24

A change in the status of at least one entity.