Data Structure and Analysis
26 Questions
0 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

Which of the following is NOT one of the normal forms discussed in the text?

  • 3NF
  • 1NF
  • 2NF
  • 4NF (correct)

    • What is the purpose of normalization in the database design process?

  • To check ERD requirements
  • To generate information efficiently
  • To increase data redundancy
  • To minimize data redundancies (correct)

    • What does denormalization involve?

  • Reducing data anomalies
  • Assigning attributes to tables based on determination
  • Producing a lower normal form (correct)
  • Transforming normal forms from lower to higher

    • Which of the following is a recommended naming convention for entity names in data modeling?

    <p>Abbreviate entity names and use familiar nouns</p> Signup and view all the answers

    What should attribute names in data modeling be descriptive of?

    <p>The characteristic being represented</p> Signup and view all the answers

    What should each entity represent in data modeling?

    <p>A single subject</p> Signup and view all the answers

    Which of the following is NOT a goal of the normalization process?

    <p>Ensuring that all tables are in at least 3NF</p> Signup and view all the answers

    What does it mean for an attribute to be fully functionally dependent on another attribute?

    <p>The attribute can be determined by only one other attribute</p> Signup and view all the answers

    In the 'Employees' table, which attribute(s) is/are functionally dependent on 'EmployeeID'?

    <p>EmployeeName</p> Signup and view all the answers

    In the 'Students' table, which attribute(s) is/are functionally dependent on 'StudentID'?

    <p>StudentAdvisor</p> Signup and view all the answers

    Which normal form describes a tabular format in which all key attributes are defined, there are no multi-valued attributes, and all attributes are dependent on the primary key?

    <p>First Normal Form (1NF)</p> Signup and view all the answers

    Which normal form requires the elimination of partial dependencies and makes new tables to achieve this?

    <p>Second Normal Form (2NF)</p> Signup and view all the answers

    Which normal form requires the elimination of transitive dependencies and makes new tables to achieve this?

    <p>Third Normal Form (3NF)</p> Signup and view all the answers

    What is the purpose of creating separate tables in the process of achieving higher normal forms?

    <p>To improve data integrity and eliminate redundancies</p> Signup and view all the answers

    Which attribute represents the number of hours an employee worked on a specific project?

    <p>HOURS</p> Signup and view all the answers

    What does CHG_HOUR represent?

    <p>The amount charge per hour</p> Signup and view all the answers

    What is the purpose of normalization in database design?

    <p>To eliminate data redundancies</p> Signup and view all the answers

    What are surrogate keys used for in database design?

    <p>To create unique identifiers when the primary key is unsuitable</p> Signup and view all the answers

    Which normal form requires that there be no transitive dependencies?

    <p>Third normal form (3NF)</p> Signup and view all the answers

    Which attribute is known as the dependent attribute in functional dependence?

    <p>Attribute B</p> Signup and view all the answers

    Which attribute is fully functionally dependent on a composite key A but not on any subset of that composite key?

    <p>Attribute B</p> Signup and view all the answers

    What is the first step in the conversion to First Normal Form (1NF)?

    <p>Eliminate repeating groups</p> Signup and view all the answers

    Which of the following is an example of partial dependency?

    <p>The Grade in the table depends on both StudentID and CourseID, but the Professor only depends on the CourseID.</p> Signup and view all the answers

    Which of the following is an example of transitive dependency?

    <p>The MajorName in the table is dependent on the MajorID, and the Department is dependent on the MajorName.</p> Signup and view all the answers

    In the first example, why is 'StudentAdvisor' not fully functionally dependent on 'StudentID'?

    <p>'StudentAdvisor' can also be determined by the 'StudentMajor' attribute.</p> Signup and view all the answers

    In the second example, how did they ensure that 'StudentAdvisor' is fully functionally dependent on 'StudentID'?

    <p>They removed any other potential sources of dependency.</p> Signup and view all the answers

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser