Microsoft Access can be used to build a prototype database,which allows users ________.
A) to draw a crow's foot E-R diagram themselves
B) to normalize the tables in the E-R diagram
C) to validate the data model by demonstrating the consequences of data modeling decisions
D) to determine the functional dependencies in the data model
E) to determine the appropriate primary and foreign keys in the data model

Question

Quizplus · Accepted Answer

Microsoft Access allows users to easily build a prototype database, which can include tables, forms, queries, and reports. This prototype can then be used to validate the data model by demonstrating the consequences of data modeling decisions. Users can effectively test different scenarios and make changes as needed before implementing the final database. While Access can assist with table normalization, determining functional dependencies, and selecting appropriate primary and foreign keys, it is up to the user to have a good understanding of database design principles. Drawing a crow's foot E-R diagram requires a separate tool.

Microsoft Access Can Be Used to Build a Prototype Database,which