University Student Database Quiz

What is an entity in the context of a database?

A general class of people, places, or things for which data is collected (correct)
A type of key used in database relationships
A specific value of an attribute
A minimal set of attributes that uniquely identifies records in a table

What is the purpose of a primary key in a database table?

To store large amounts of data
To improve data retrieval speed
To establish relationships between tables
To uniquely identify records in a table (correct)

What is an attribute in the context of a database?

A database entity
A specific value of a data item
A type of database key
A piece of information about an entity (correct)

What is a data item in the context of a database?

A specific value of an attribute (A) Signup and view all the answers

What is the relationship between an entity and an attribute?

An attribute is a piece of information about an entity (C) Signup and view all the answers

What is the purpose of a key in a database?

To establish relationships between tables (A) Signup and view all the answers

What is a major issue with storing the same information in multiple master files?

Inconsistent data between files (A) Signup and view all the answers

What is the purpose of the Enrollment Program in the 16 File Approach to Storing Data?

To store student enrollment data (A) Signup and view all the answers

In the 16 File Approach to Storing Data, which items are used to generate the Enrollment Report?

Items A, B, and C (D) Signup and view all the answers

A column in a table that points to the primary key of another table is known as a?

Foreign key (A) Signup and view all the answers

What is a unique combination of attribute types used to identify a single instance of an entity?

Compound Primary Key (D) Signup and view all the answers

What is the outcome of having the same information in multiple master files?

Difficulty in integrating data and obtaining an organization-wide view (B) Signup and view all the answers

What is an attribute that appears as a non-primary key in one entity and as a primary key attribute in another entity?

Foreign key (C) Signup and view all the answers

What is the purpose of the Fin.Aid Program in the 16 File Approach to Storing Data?

To store financial aid information (D) Signup and view all the answers

Which step involves inputting items A, B, D, and F in the 16 File Approach to Storing Data?

Step 4 (D) Signup and view all the answers

What is composed of two or more attributes that together uniquely identify a record?

Composite key (B) Signup and view all the answers

What is used to identify, select, and maintain one or more records using an application program, query, or report?

Database keys (C) Signup and view all the answers

What type of key consists of two or more simple (foreign) keys?

Compound key (D) Signup and view all the answers

What is the primary criterion for a student to be included in the Aid/Grades Report?

All of the above (D) Signup and view all the answers

What is the main characteristic of the File Approach?

Each application has its own set of files (C) Signup and view all the answers

What is a consequence of Uncontrolled Redundancy in the File Approach?

Wastage of valuable storage space (A) Signup and view all the answers

What is the main limitation of the File Approach in terms of data management?

All of the above (D) Signup and view all the answers

What is the purpose of the Integrated Enrollment/Fin.Aid/Grades Report?

To integrate data from Enrollment, Financial Aid, and Grades Programs (B) Signup and view all the answers

What is the advantage of the Database Approach over the File Approach?

Data is standardized across the organization (B) Signup and view all the answers

What is a major limitation of the File Processing Approach?

Updates require multiple updates in many files (A) Signup and view all the answers

What is the primary advantage of the Database Approach in terms of data management?

Centralized data storage in a large conceptual repository (A) Signup and view all the answers

What is a disadvantage of the Database Approach?

Require significant resources to maintain the DBMS (B) Signup and view all the answers

What is the primary benefit of using a Database Management System (DBMS)?

Data and program independence (C) Signup and view all the answers

What is a characteristic of the File Processing Approach in terms of storage media?

Sequential tapes or files (D) Signup and view all the answers

What is the primary difference between the File Processing Approach and the Database Approach in terms of data organization?

Data is stored in long sequential files with no relationship with other files (B) Signup and view all the answers