The History of the Relational Data Model Quiz
14 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

Which term refers to the total number of tuples or rows present in a relation?

  • Cardinality (correct)
  • Relation state
  • Relational database schema
  • Degree

What does a relational database schema consist of?

  • Tuples and rows
  • Relation states and relation instances
  • Relation schemas and integrity constraints (correct)
  • Relation states and integrity constraints

What is a relation instance or relation state?

  • The set of integrity constraints in a database
  • A set of tuples at a given moment of time (correct)
  • A collection of relation schemas
  • The total number of tuples or rows in a relation

Which company first implemented the relational model commercially?

<p>IBM (B)</p> Signup and view all the answers

Who is credited with inventing the relational data model?

<p>Ted Codd (D)</p> Signup and view all the answers

What is a tuple in the context of a relational database?

<p>A row (B)</p> Signup and view all the answers

What is the degree or arity of a relation?

<p>The number of attributes in a relation schema (A)</p> Signup and view all the answers

The degree of this relation student is ______

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

The cardinality of this student relation is ______

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

A relational database schema is a set of ______ and a set of integrity constraints

<p>relation schemas</p> Signup and view all the answers

Ted Cord invented the ______ data model in 1970

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

The first commercial implementations of the relational model were by ______ and IBM

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

A ______ is a set of possible values that you can input for an attribute

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

A relation schema is made up of a relation name and a list of ______

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

More Like This

Use Quizgecko on...
Browser
Browser