Introduction to BI & BM

5 important questions on Introduction to BI & BM

A database systems allows users to:

- Organize (CREATE) - Store (INSERT) - Update (UPDATE) - Delete (DELETE) - Retrieve their data (SELECT)

What is a table?

structured list of data of a specific type. Each table has a name, and is divided into fields (columns) and records (rows)

What is a relational database?

-Data to be grouped into tables
- Sets relationships between tables
  • Higher grades + faster learning
  • Never study anything twice
  • 100% sure, 100% understanding
Discover Study Smart

What is a primary key?

fields that uniquely identifies each record in a table. Null value is not allowed. It consists of 1 or more attributes that determine other attributes. When a primary key contains multiple values, it is called a composite primary key. Key’s role is based on determinations: A  B, C, D o If you know A, you can lookup B, C, D o B, C, D are functionally dependent on A Textual representation of the database tables. Primary keys are underlined

What is a superkey?

any key that uniquely identifies each row (potential primary key)

The question on the page originate from the summary of the following study material:

  • A unique study and practice tool
  • Never study anything twice again
  • Get the grades you hope for
  • 100% sure, 100% understanding
Remember faster, study better. Scientifically proven.
Trustpilot Logo