Question

Explain te database design process in detail​

Answer 1

A database system should be a repository of the data needed for an organization's data processing.

Different application programmers and different end users will have different views of the data which may be derived from common overall data structure.

To design a database :-

• Database should be like this that it can secure the data and data cannot be accessed by any wrong authority.
• A number of different application programs are written to extract records from and add records to the appropriate files.
• It should be organized so that diverse applications with different data requirements can employ the data.
• database should be made that it keep the data accurate, private, and protected from damage.
• it should be easily accessible to others.

Database should minimize these limitations :-

• Data redundancy
• Data inconsistency
• Unshrable data
• Unstandardized data
• Insecure data
• Incorrect data