Question

A club is setting up a database to store the details of its members
a) Complete the table by identifying the most appropriate data type for each field.
[3]
Field name
Data type
Membership_number
Membership fee paid
Expiry date_of-membership
b) Which database object can be used to view, change and analyse the data of
members?please answer it correct and fast ​

Answer 1

a) Membership_number - int(Integer)

  Memership_fee_paid - money(money)

  Expiry_date_of_membership - date(date)

b) Queries, reports and tables are all methods to invoke the database to do certain functionalities