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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!