University Student Database Quiz
30 Questions
2 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

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?

    <p>A specific value of an attribute (A)</p> Signup and view all the answers

    What is the relationship between an entity and an attribute?

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

    What is the purpose of a key in a database?

    <p>To establish relationships between tables (A)</p> Signup and view all the answers

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

    <p>Inconsistent data between files (A)</p> Signup and view all the answers

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

    <p>To store student enrollment data (A)</p> Signup and view all the answers

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

    <p>Items A, B, and C (D)</p> Signup and view all the answers

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

    <p>Foreign key (A)</p> Signup and view all the answers

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

    <p>Compound Primary Key (D)</p> Signup and view all the answers

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

    <p>Difficulty in integrating data and obtaining an organization-wide view (B)</p> 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?

    <p>Foreign key (C)</p> Signup and view all the answers

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

    <p>To store financial aid information (D)</p> Signup and view all the answers

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

    <p>Step 4 (D)</p> Signup and view all the answers

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

    <p>Composite key (B)</p> 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?

    <p>Database keys (C)</p> Signup and view all the answers

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

    <p>Compound key (D)</p> Signup and view all the answers

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

    <p>All of the above (D)</p> Signup and view all the answers

    What is the main characteristic of the File Approach?

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

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

    <p>Wastage of valuable storage space (A)</p> Signup and view all the answers

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

    <p>All of the above (D)</p> Signup and view all the answers

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

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

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

    <p>Data is standardized across the organization (B)</p> Signup and view all the answers

    What is a major limitation of the File Processing Approach?

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

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

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

    What is a disadvantage of the Database Approach?

    <p>Require significant resources to maintain the DBMS (B)</p> Signup and view all the answers

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

    <p>Data and program independence (C)</p> Signup and view all the answers

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

    <p>Sequential tapes or files (D)</p> 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?

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

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser