bartleby
search
close search
Hit Return to see all results
close solutoin list

Chapter 2, Problem 2.1RQ

BuyFindarrow_forward

Database Concepts (8th Edition)

8th Edition
David M. Kroenke + 3 others
ISBN: 9780134601533
BuyFindarrow_forward

Database Concepts (8th Edition)

8th Edition
David M. Kroenke + 3 others
ISBN: 9780134601533
Program Plan Intro

Relational model:

  • In the relational model, data are organized in tables, which consist of rows and columns.
    • A data in a row or column of a table are called fields.
    • Fields in a database table are also referred as attributes of a database object.
      • A group of related fields is called as record, which is also as called database object or entity.
      • A group of records is called a table.
      • Keys in a relational database table refer to a key field.
        • To identify each record in a table, there must be at least one data field that should be unique. That is, a corresponding data field of every record should be unique.
        • So, key field is used to identify the unique record from a collection of records.
  • For example,
    • Consider a database table named “Student” contains the student details such as “StudentID”, “StudentName”, “Marks”, which are the fields of the table, and they are together called as records.
      • The “StudentID” contains the registration number of students, “StudentName” contains name of students, and Marks contain the computer science marks of each student.

Explanation

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Answers to Your Study Problems

Solve them all with bartleby. Boost your grades with guidance from subject experts covering thousands of textbooks. All for just $2.99 for your first month and only $4.99/month after? Done and done.

Get A's ASAP

Additional Computer Science Solutions

Find more solutions based on key concepts

Show solutions add

Sorry about that. What wasn’t helpful?

Q & A

Ask our subject matter experts virtually any homework help question and they’ll send you an answer within 48 hours.

0 / 5,000

We deeply value honesty and integrity. Learn about our honor code arrow_forward