Question

1. What are the four components of a database system?

2. Briefly describe the function of the DBMS in a database system.

3. Describe the requirements that a table must meet to qualify as a relation.

4. Identify functional dependency in the table below and justify your answer.

Number	Color
1	Red
2	Blue
3	White
4	Green
5	Green
6	Green

Answer 1

Solution:

1)

Four components of Database Systems are:

1. Users
2. Database Management Systems
3. Database
4. Database application

2)

A database management system (DBMS) serves as an intermediary between database applications and the database.

3)

A table must have a foreign key attribute defined in it to qualify as a relation.

4)

The functional dependency in the given table is Many to one

because

there are many Numbers(4, 5, and 6) which are referring to same Color (Green).

Hit the thumbs up if you liked the answer. :)