Chapter 2, Problem 2.1RQ

Database Concepts (8th Edition)

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

Chapter
Section

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

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