lecture1-Quiz

How many percent for Independent Study in your grade distribution?

• 10

• 25

• 30

• 35

True or False. You need to present your project proposal.

• True

• False

Choose all of data visualization Python libraries/modules.

• matplotlib

• numpy

• Duckdb

• seaborn

What is database?

• A collection of data

• Not a collection of data

True or False. CSV file is an example of databases.

• True

• False

What is database management system (DBMS)?

• Database

• Collection of data

• System that manages databases

• Organization that defines the term "database"

What is a collection of concepts for describing databases?

• DBMS

• Data model

• Database

• Schema

What are two main concepts of relational model?

• Access data through high-level languages

• All data must be numbers

• Data are stored as relations (i.e., tables)

• Data cannot be in a single table.

Suppose attribute X is a primary key of relation Y.

True or False. Each value in attribute X doesn't need to be unique.

• True

• False

What is true about primary and foreign key constraints?

• Values in the attribute that is marked as foreign key must be unique

• Values in the attribute that is marked as foreign key can be NULL

• Primary key and foreign key can form a concept of domain

• DBMS implements primary and foreign keys as constraints