Exam 3: Database Systems,data Warehouses,and Data Marts

The "integrity rules" component of a data model defines the boundaries of a database,constraints,and access methods.

Which of the following is true of a flat file system?

What type of files might a college database have?

The term CRUD stands for copy,revise,undo,and define.

What is a random access file structure?

In a(n)____________________ model,the relationships among records form a treelike structure.

The ____ approach to setting up a distributed DBMS combines fragmentation and replication.

The data ____ component is used to add,delete,modify,and retrieve records from a database.

In a(n)____________________ access file structure,records can be accessed in any order,regardless of their physical location in storage media.

What tasks are performed when normalizing a database in the 1NF stage?

Which of the following is a source of external data?

Describe the loading process of ETL.

____________________ is used to facilitate and manage transaction-oriented applications,such as point-of-sale,data entry,and retrieval transaction processing.

The use of OR operator means that only one of the conditions must be met.

The ____ view involves how information appears to users and how it can be organized and retrieved.

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

In a relational database,every record must be uniquely identified by a(n)____________________ key.

Any changes to a database's structure,such as adding a field,deleting a field,changing a field's size,or changing the data type stored in a field,are made with the data manipulation component.

In a relational model,the rows are called attributes and the columns are called tuples.

In the ____ model,each record can have multiple parent and child records.