Physical database design issues, Database Management System

Assignment Help:

Physical Database Design Issues

The database design includes the process of logical design with the use of E-R diagram, normalisation, etc., followed by the physical design.

The Key issues in the Physical Database Design are:

  • The use of physical database design is to alter the logical description of data into the technical specifications for retrieving and storing data for the DBMS.
  • The aim is to create a design for storing data that will give adequate performance and make sure database integrity, recoverability and security.

Some of the basic inputs needed for Physical Database Design are:

  • Normalised relations
  • Attribute definitions
  • Data usage: retrieved, entered, deleted, updated
  • Requirements for security, recovery, backup, retention, integrity
  • DBMS characteristics.
  • Performance criterion such as response time necessity with respect to volume estimates.

Though, for this type of data some of the Physical Database Design Decisions that are to be taken are:

  • Modifying the logical design.
  • Optimising attribute data types.
  • Specifying the file Organisation.
  • Choosing indexes.

Related Discussions:- Physical database design issues

Relational database implementation, You must implement the entity relations...

You must implement the entity relationship model provided in the model solution to Assignment 1. The model solution will be released on the course website approximately TWO (2) we

Define lock, Define lock? Lock is the most common used to execute the r...

Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.

Graphical user interface tools, These are interactive interfaces, graphical...

These are interactive interfaces, graphical that hide the difficulty of the DBMS and query language behind an intuitive, simple to understand, and convenient interface. This permit

Example for while until, Assume you are given a uniprocessor system with on...

Assume you are given a uniprocessor system with one gigabyte of memory and a 300 gigabyte disk. The OS on the machine has a demand paged virtual memory system with a local page rep

Create an er diagram completely with attributes, A database is to be constr...

A database is to be constructed to remain track of the teams and games of a sport league. A team has a number of players, not all of whom participate in every game. It is desired

State about the activity diagram, State about the Activity Diagram Act...

State about the Activity Diagram Activity diagrams show flow from one activity to other. It is an ongoing non atomic execution within a state machine. Activity finally results

Define object-oriented database, Question : Object-Oriented Database (O...

Question : Object-Oriented Database (OODM) is defined as a logical data model that captures the semantics of objects supported in object-oriented programming. An Object-Oriente

Cartisian product, Explain the cartesian product in Database Management Sys...

Explain the cartesian product in Database Management System

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd