Crowdly

Add to Chrome

Universities
softserve.academy
DataBase Fundamentals new

DataBase Fundamentals new

Looking for DataBase Fundamentals new test answers and solutions? Browse our comprehensive collection of verified answers for DataBase Fundamentals new at softserve.academy.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

What is a primary key?

A unique identifier for a record in a table

✅

Any key in a table

❌

A field that can store atomic values

❌

A not null unique column in a table

❌

View this question

Which of these columns can be defined as a Primary Key?

FirstName

❌

RegistrationDate

❌

ProductID

✅

VIN (Vehicle Identification Number)

✅

OrderNumber

✅

View this question

A relationship is ...

a column in a table that refers to the primary key in another table

❌

the way in which two columns in two different tables are related

a list of keys or keywords which identify a unique record and can be used to search and sort records more quickly

the degree to which a database has to be normalized

View this question

Define the appropriate type of relationships.

Tables hold data about employees and the projects to which they are assigned. Each project can involve more than one employee and each employee is able to be occupied on more than one project

Each record in Table A relates to one, and only one, record in Table B, and each record in Table B relates to one, and only one, record in Table A.

Record in Table A can relate to zero, one, or many records in Table B. Many records in Table B can relate to one record in Table A.

View this question

Match the appropriate definition and description

A key that consists of two or more table columns that together uniquely identify a table row.

A column whose values match a Primary Key in another table

A value of this column will uniquely identify the record in the table

View this question

Primary Key is defined

to identify any table in the database

❌

to identify any column of data in the table in unique way