Database Design


  • Collection of Processes

    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.
    01
  • Data Management

    The logical model concentrates on the data requirements and the data to be stored independent of physical considerations. It does not concern itself with how the data will be stored or where it will be stored physically.
    02
  • Management Systems

    The physical data design model involves translating the logical DB design of the database onto physical media using hardware resources and software systems such as database management systems (DBMS).
    03
  • Examination

    Testing – this stage is concerned with the identification of errors in the newly implemented system. It checks the database against requirement specifications.
    04
  • importing Database

    Data conversion and loading – this stage of relational databases design is concerned with importing and converting data from the old system into the new database.
    05
  • purposes

    The main objectives of database design in DBMS are to produce logical and physical designs models of the proposed database system.
    06