What is the purpose of database design? Compare logical design with physical design.

Question

Bipin Tiwari · Accepted Answer

Database Design is a collection of processes that facilitate the designing, development, implementation and maintenance of enterprise data management systems. Properly designed database are easy to maintain, improves data consistency and are cost effective in terms of disk storage space. The database designer decides how the data elements correlate and what data must be stored. The main objectives of database design in DBMS are to produce logical and physical designs models of the proposed database system. It helps produce database systems That meet the requirements of the users Have high performance. Database design process in DBMS is crucial for high performance database system. Difference between physical design and logical design given below: Physical Design Logical Design Physical design is highly detailed. Logical design is a high-level design and doesn’t provide any detail. Physical design is more graphical than textual; however, it can comprise both. Logical design can be textual, graphic, or both. A physical design focuses on specific solutions explaining how they are assembled or configured. A logical design focuses on satisfying the design factors, including risks, requirements, constraints, and assumptions.

What is the purpose of database design? Compare logical design with physical design.

Leave your Answer:

Hits Counter

Question

What is the purpose of database design? Compare logical design with physical design.

Leave your Answer: