The requirements for the members of a library:
For each member, the library keeps a card number (no two members have the same one), a first and a last name, an address (street and city), one or more phone numbers, a birth date, and the member's age.
The member table already holds some of these attributes.
- Which attribute identifies each member?
- Which attribute is multivalued?
- Which attribute is derived?
nameis composite. The table stores its parts. Returnmember_id, then the whole name as one value: first name, a space, last name.
ageis not stored. Returnmember_id, then the age that each member reaches this year.