Concept explainers
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...
Want to see the full answer?
Check out a sample textbook solutionChapter 1 Solutions
Database Concepts (7th Edition)