TASK A: DATABASE MANAGEMENT
This business/management problem is solved step by step below, with detailed explanations to help you understand the method and arrive at the correct answer.
ScanSolve AI Answer
Here are the solutions to the database and spreadsheet management tasks.
TASK A: DATABASE MANAGEMENT
1. Database Design
a) Create the tblMember table structure, showing field names and data types.
| Field Name | Data Type | Description |
| :------------- | :---------- | :---------------------------------------- |
| MemberID | Short Text | Unique identifier for each member |
| MemberName | Short Text | Full name of the member |
| BranchLocation | Short Text | Branch where the member is registered |
b) State the PRIMARY KEY for each of the three tables:
tblMember: MemberID
`tblTransaction
