30 Questions
What is an entity in the context of a database?
A general class of people, places, or things for which data is collected
What is the purpose of a primary key in a database table?
To uniquely identify records in a table
What is an attribute in the context of a database?
A piece of information about an entity
What is a data item in the context of a database?
A specific value of an attribute
What is the relationship between an entity and an attribute?
An attribute is a piece of information about an entity
What is the purpose of a key in a database?
To establish relationships between tables
What is a major issue with storing the same information in multiple master files?
Inconsistent data between files
What is the purpose of the Enrollment Program in the 16 File Approach to Storing Data?
To store student enrollment data
In the 16 File Approach to Storing Data, which items are used to generate the Enrollment Report?
Items A, B, and C
A column in a table that points to the primary key of another table is known as a?
Foreign key
What is a unique combination of attribute types used to identify a single instance of an entity?
Compound Primary Key
What is the outcome of having the same information in multiple master files?
Difficulty in integrating data and obtaining an organization-wide view
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
What is the purpose of the Fin.Aid Program in the 16 File Approach to Storing Data?
To store financial aid information
Which step involves inputting items A, B, D, and F in the 16 File Approach to Storing Data?
Step 4
What is composed of two or more attributes that together uniquely identify a record?
Composite key
What is used to identify, select, and maintain one or more records using an application program, query, or report?
Database keys
What type of key consists of two or more simple (foreign) keys?
Compound key
What is the primary criterion for a student to be included in the Aid/Grades Report?
All of the above
What is the main characteristic of the File Approach?
Each application has its own set of files
What is a consequence of Uncontrolled Redundancy in the File Approach?
Wastage of valuable storage space
What is the main limitation of the File Approach in terms of data management?
All of the above
What is the purpose of the Integrated Enrollment/Fin.Aid/Grades Report?
To integrate data from Enrollment, Financial Aid, and Grades Programs
What is the advantage of the Database Approach over the File Approach?
Data is standardized across the organization
What is a major limitation of the File Processing Approach?
Updates require multiple updates in many files
What is the primary advantage of the Database Approach in terms of data management?
Centralized data storage in a large conceptual repository
What is a disadvantage of the Database Approach?
Require significant resources to maintain the DBMS
What is the primary benefit of using a Database Management System (DBMS)?
Data and program independence
What is a characteristic of the File Processing Approach in terms of storage media?
Sequential tapes or files
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
Test your knowledge of a university student database, including student information, addresses, majors, and course enrolments. Review the table data and answer questions about the students and their details.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
