Using two examples, explain the term field properties as used in database design.
(b) Below is an extract from a hospital database table.
(i) State with reasons the most suitable data types for the following fields:
(iii) What is the purpose of a primary key field in database design?
(iv) Describe how information about patients who registered after 09/08/06 can be extracted from the database.
(ii) Appropriate primary key on the table
Related Searches on database, Form 2 Level