Home » Web News Digest » What Is Logical Database Design and Physical Database Design?

What Is Logical Database Design and Physical Database Design?

Elena Rostova • • 6 min read
What Is Logical Database Design and Physical Database Design?
Logical database modeling includes; ERD, businessprocess diagrams, and user feedback documentation; whereasphysical database modeling includes; server model diagram,database design documentation, and user feedbackdocumentation.

.

Also asked, what is a logical database design?

Logical database design is the process ofdeciding how to arrange the attributes of the entities in a givenbusiness environment into database structures, such as thetables of a relational database.

Secondly, what is meant by database design? Database design is the organization of dataaccording to a database model. The designerdetermines what data must be stored and how the data elementsinterrelate. Database design involves classifying data andidentifying interrelationships. This theoretical representation ofthe data is called an ontology.

Also Know, what is logical design and physical design?

Logical design deals with the logicalrelationships between objects. Entity-relationship (ER) modelingtechnique can be used for logical design of data warehouse.ER modeling involves identifying the entities (important objects),attributes (properties about objects) and the relationship amongthem.

How do you design a database?

The design process consists of the followingsteps:

  1. Determine the purpose of your database.
  2. Find and organize the information required.
  3. Divide the information into tables.
  4. Turn information items into columns.
  5. Specify primary keys.
  6. Set up the table relationships.
  7. Refine your design.
  8. Apply the normalization rules.
Related Question Answers

What is the role of logical database designer?

The database designer is responsible for definingthe detailed database design, including tables, indexes,views, constraints, triggers, stored procedures, and otherdatabase-specific constructs needed to store, retrieve, anddelete persistent objects.

What is logical diagram?

logic diagram (plural logic diagrams) Adiagram in the field of logic. Any non-spatial,abstract diagram. Any schematic display of thelogical relationships of project activities. A graphicalrepresentation of a program using formal logic.
Elena Rostova
Author

Elena Rostova

Elena Rostova holds a Master's degree in Public Health Journalism. She covers groundbreaking medical research, holistic wellness trends, mental health awareness, and nutritional science.