Database Design involves designing, developing, implementing, and maintaining enterprise data management systems. Well-designed databases are easy to maintain, improve data consistency, and are cost-effective in terms of storage.
The logical model focuses on data requirements and storage without considering physical storage details.
The physical data design model translates the logical database design onto physical media using hardware and DBMS software.
Testing identifies errors in the new system by checking the database against requirement specifications.
Data conversion and loading involve importing and converting data from the old system into the new database.
The main objectives of database design in DBMS are to create logical and physical design models of the proposed database system.