Loading, please wait ...
Open its course - Database Systems
Physical Database Design Methodology By Subject Expert Admin
Summary

Summary

12
Teachers with
Subject Expert Admin
326
Followers
For Learning
All
Visibility
Security Status
0
Contributions
By Teachers
Notes
  1. Students are auto-evaluated against related topics to ensure they learned it.

Detailed overview of the steps that you will take to physically design a database. Steps to cover are:

  • Overview of Physical Database Design Methodology 
  • Translate logical data model for target DBMS 
    • Step 3.1 Design base relations 
    • Step 3.2 Design representation of derived data 
    • Step 3.3 Design general constraints
  • Design file organizations and indexes 
    • Step 4.1 Analyze transactions 
    • Step 4.2 Choose file organizations 
    • Step 4.3 Choose indexes 
    • Step 4.4 Estimate disk space requirements 
    • Step 5 Design user views 
    • Step 6 Design security mechanisms 
    • Step 7 Consider the introduction of controlled redundancy 
    • Step 8 Monitor and tune the operational system

×

Physical Database Design Methodology Evaluation

To earn PASS status, system is about to evaluate you using multiple choice questions (MCQs) and True/False type questions.

  • CAREFULLY READ THE FOLLOWING INSTRUCTIONS!
  • Make sure you have learned this lecture along with its topics and tutorials.
  • On first evaluation you get 100% marks on correct answer, then on 2nd you get 95% marks and so on.
  • Answer the questions with a gap NOT MORE THAN A MINUTE, Otherwise it will re-start.

I have read above instrucitons and ready for evaluation.
Your's
Status
Not Registered
Teacher
Subject Expert Admin
Alert
Your performance monitoring will start when you register in a class of this course.

Questions on

Contact Us

support@subexpert.com
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn, Evaluate and Optimize

Follow Us
Facebook Switch Display Mode Enable Translation
© 2024 - Subject Expert