Describe the purpose of the main steps in the physical design methodology presented in this chapter.
What will be an ideal response?
Step 3 Produces a relational database schema from the logical data model. This includes
integrity rules.
Step 4 Determines the file organizations for the base relations. This takes account of the nature
of the transactions to be carried out, which also determine where secondary indexes will
be of use. As a result of analyzing the transactions, the design may be altered by
incorporating controlled redundancy into it.
Step 5 Designs the user views for the database implementation.
Step 6 Designs the security measures for the database implementation.
You might also like to view...
You can customize the Quick Access Toolbar
Indicate whether the statement is true or false
The ________ command removes text or an object from one location and adds it to the Office Clipboard
Fill in the blank(s) with correct word