Chapter 1, Problem 1.33E

Explanation of Solution

Name of spreadsheet: COMPANY

Column names:

Name	IndustryCode	Gross Sales	OfficerName	OfficerTitle

The above spreadsheet contains Name, IndustryCode, Gross Sales, OfficerName, and OfficerTitle.

Divide the columns into tables with single theme:

Industry details:

Industry_id	Name	IndustryCode
1	SUN	352-765
2	Anime	654-123

Officer details:

Officer_id	OfficerName	OfficerTitle
1	Ram Kumar	ceo
2	Rajesh	Project Head

Sales details:

Industry_id	Officer_id	Gross Sales
1	1	23000000
2	2	45000000
1	2	50000000

• Number of themes: Three
• Name of the theme: Industry details, officer details, and Sales

Assumptions:

In the above spreadsheet, there are three themes. One of the themes is about industry which is specified through the heading of Name and IndustryCode. The other theme is about officer who is specified through the heading of OfficerName and OfficerTitle. The final theme is about sales which are specified through the heading of Gross Sales.

• Industry – It contains Industry_id, Name and IndustryCode attributes. The Industry_id is the primary key of the Industry table.
• Officer – It contains Officer_id, OfficerName, and OfficerTitle attributes. The Officer_id is the primary key of the Officer table.
• Sales – It contains Industry_id, Officer_id, and Gross Sales attributes.

Name of spreadsheet: COMPANY

Column names:

Name	IndustryCode	Gross Sales	NameOfOwner

The above spreadsheet contains Name, IndustryCode, Gross Sales and NameOfOwner.

Divide the columns into tables with single theme:

Industry details:

Industry_id	Name	IndustryCode	NameOfOwner
1	SUN	352-765	XXX
2	Anime	654-123	YYY

Sales:

Industry_id	Gross Sales
1	23000000
2	45000000
1	50000000

• Number of themes: Three
• Name of the theme: Industry details and Sales

Assumptions:

In the above spreadsheet, there are three themes. One theme is about industry which is specified through the heading of Name and IndustryCode. The other theme is about president which is specified through the heading of NameOfPresident. The final theme is about a sale which is specified with the heading of Gross Sales.

• Industry – It contains Industry_id, Name, IndustryCode, and NameOfOwner attributes. The Industry_id is the primary key of the Industry table.
• Sales – It contains Industry_id, and Gross Sales attributes.

Name of spreadsheet: COMPUTER

Column names:

SerialNumber	Make	Model	DiskType	DiskCapacity

The above spreadsheet contains SerialNumber, Make, Model, DiskType and DiskCapacity...