Get premium membership and access questions with answers, video lessons as well as revision papers.

What guidelines should a database designer consider before setting up a good database?

      

Give the main guidelines that a database designer should consider before setting up a good database.

  

Answers


Maurice
(i) The database should meet and provide the needs of the users in terms of inputs, processes and outputs.

(ii) Draft the design on a piece of paper first and avoid jumping to the computer immediately.

(iii) Identify the tables to work with, the fields and the records of each particular entry required. Remember to carry out the normalisation procedures. That is, First Normal Form (1NF), Second Normal Form (2NF) and Third Normal Form (3NF).

(iv) Identify the possible fields in each table that can be used to uniquely identify records (Primary Key).

(v) Design an interface screen for your data entries. This might call for use of appropriate controls for examples whether to use a combo box or list box.

(vi) The database should be shareable. That is, providing access to the same data in the database by different users at the same time.

(vii) The integrity of the data should be implemented to ensure only valid data is entered in the database. No user should be allowed to change data of other users.

(viii) The database should be capable of evolving in order to meet the future data processing needs of users besides meeting their current needs.
maurice.mutuku answered the question on April 11, 2018 at 08:40


Next: Starting with lead(ii)oxide, describe how you would prepare a solid sample of lead (ii)chloride
Previous: What is a "data type" as used in databases?

View More Computer Studies Questions and Answers | Return to Questions Index


Learn High School English on YouTube

Related Questions