Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

QUESTION 15 If, during the use of the database system, it becomes apparent that

ID: 3698637 • Letter: Q

Question

QUESTION 15 If, during the use of the database system, it becomes apparent that a new relation needs to be added to t the database, the decision to add the new relation to the database vnill rest with the O Database developer O End user ODBMS software developer O DBA QUESTION 16 What is a data dictionary? of the tabies, names and types of O A data dictionary is a repository of the filds. The data dictionary also sometimes called the metadata reposieory, contains information such as the names on. The metadata showing che structure of the functioning columns in them, the primary keys referential integrity constraints, and so the data dictionary metadata repository,centains informasen such as the showing the structure of the functioning databne someemes called the metadata repository, names of the tables, names and types of columns in them the candidate keys, referential integrity constraints, and so on. The metadats system is automatically stored by the DBeMS in the data dictionary A data dictionary is a repository of the metadata (data about the data) of the database. The data dictionary, also somesimes called the A data dictionary is a repository of the metadata (data about the data) of the database. The data dictionary also sometimes called the metadata repesitory, contains information such as the names of the tables, names and types of columns in them, the primary keys referential integrity constraints, and so on The metadata showng the structure of the functioning databace aystem is automatically stored by the DeMs in the data dictionary none of these answers

Explanation / Answer

Question 15:

Answer - Option A

Database developer - focus on improving the existing database according to the requirements of project or application.

End user - he just uses the data in the database does not do any modifications at the database level i.e., like adding tables, removing tables etc.,

DBMS software developer - he works on the improvement of DBMS software i.e., like adding new features to the existing DBMS software

DBA - do regular maintenance and support for existing database.

so Database Developer is responsible for adding the new relation to the database or not.

Question 16:

Answer - Option B/C because both are same

A data dictionary is a repository of the metadata (data about data) of the database. the data dictionary also sometimes called the metadata repository, contains information such as the names of tables, names and types of columns in them, the primary keys, referential integrity constraints and so on. The metadata showing the structure of the functioning database system is automatically stored by the DBMS in the data dictionary.

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote