Question: Table Name Column Name Data type PK/FK Is Null Person PersonID Integer (Auto Increment) PK NOT NULL PersonName Varchar(40) NOT NULL PersonAddress Varchar(100) NOT NULL
| Table Name | Column Name | Data type | PK/FK | Is Null |
| Person | PersonID | Integer (Auto Increment) | PK | NOT NULL |
|
| PersonName | Varchar(40) |
| NOT NULL |
|
| PersonAddress | Varchar(100) |
| NOT NULL |
|
| PersonContact No | Varchar(12) |
| NOT NULL |
|
| PersonEmail | Varchar(50) |
|
|
|
| PersonSalary | Float |
|
|
| Client | ClientID | Integer (Auto Increment) | PK | NOT NULL |
|
| ClientName | Varchar(40) |
| NOT NULL |
|
| ClientAddress | Varchar(100) |
| NOT NULL |
|
| ClientContact No | Varchar(12) |
| NOT NULL |
|
| ClientEmail | Varchar(50) |
|
|
| Chores | ChoreID | Integer (Auto Increment) | PK | NOT NULL |
|
| ChoreDescription | Varchar(60) |
| NOT NULL |
|
| ChoreCategoryID | Integer |
| NOT NULL |
|
| ChoreFrequency | Varchar(20) |
| NOT NULL |
|
| ChoreEstimatedMinutes | Integer |
| NOT NULL |
|
| ChoreActualMinutes | Integer |
|
|
|
| ChoreAssignedPerson | Integer |
|
|
|
| ChoreAssociatedClient | Integer |
|
|
|
| ChoreStatus | Varchar(10) |
| NOT NULL |
| Profit | ProfitID | Integer (Auto Increment) | PK | NOT NULL |
|
| ProfitYear | Integer |
| NOT NULL |
|
| ProfitMonth | Integer |
| NOT NULL |
|
| ProfitAmount | Float |
| NOT NULL |
| Chore Categories | CategoryID | Integer (Auto Increment) | PK | NOT NULL |
|
| CategoryDescription | Varchar(60) |
| NOT NULL |
|
| CategoryCostperhour | Float |
| NOT NULL |
ER Diagram from the above information.
Design a 3NF
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
