Michael needs to create a database that contains a table with information about each car produced,a table with information about the line in which each car was produced,and a table with information about the experience of workers on the line in which each car was produced.Which type of database would allow him to enter this information only once,but also create three separate tables with information on the car,the line,and the workers?
A) Single-table database
B) Flat file database
C) Relational database
D) Web database

Question

Quizplus · Accepted Answer

Relational databases allow for the creation of multiple tables that can be linked through common identifiers, allowing for efficient data entry and retrieval. In this case, Michael can create a table for the cars with a unique identifier, and then create separate tables for the lines and workers that include that identifier to create the necessary relationships. This means that he only needs to enter the car information once, but can still access the line and worker data as needed.

Michael Needs to Create a Database That Contains a Table