Show at least one modification problem that will occur

Assignment Help Database Management System

Reference no: EM132610362

1. For each of the spreadsheets provided, indicate the number of themes you think the spreadsheet includes and give an appropriate name for each theme. For some of them, the answer may depend on the assumptions you make. In these cases, state your assumptions.

2. For any spreadsheet that has more than one theme, show at least one modification problem that will occur when inserting, updating, or deleting data.

3. For any spreadsheet that has more than one theme, break up the columns into tables such that each table has a single theme. Add ID columns if necessary, and add a linking column (or columns) to maintain the relationship between the themes.

The following spreadsheets form a set of named spreadsheets with the indicated column headings. Use these spreadsheets to answer exercises

1.37 through 1.39.
A. Name of spreadsheet: EQUIPMENT
Column headings:
Number, Description, AcquisitionDate, AcquisitionPrice
B. Name of spreadsheet: COMPANY
Column headings:
Name, IndustryCode, Gross Sales, OfficerName, OfficerTitle
C. Name of spreadsheet: COMPANY
Column headings:
Name, IndustryCode, Gross Sales, NameOfPresident
D. Name of spreadsheet: COMPUTER
Column headings:
SerialNumber, Make, Model, DiskType, DiskCapacity
E. Name of spreadsheet: PERSON
Column headings:
Name, DateOfHire, DeptName, DeptManager, ProjectlD, NumHours, ProjectManager

Reference no: EM132610362

Questions Cloud

How models can use real data to create forecasts : Some challenges to policy making in developing countries. The idea is to focus on how models can use real data to create forecasts.

Calculate Oriole net income : Oriole Corporation has outstanding at December 31, 2020, 50,000 shares of $22 par value, Calculate Oriole net income

What are unicellular organisms : What are unicellular organisms

Produce definition of data visualization : Discuss emerging ICT tools and technologies presenting the potential to enhance policy making. Produce a definition of data visualization.

Show at least one modification problem that will occur : Show at least one modification problem that will occur when inserting, updating, or deleting data - break up the columns into tables such that each table

Domain services are used to manage centralized network : Domain Services are used to manage a centralized network architecture. Each platform has its own set of Domain Services.

What would be Katydid before-tax component cost of debt : KatyDid Clothes has a $170 million (face value) 30-year bond issue selling for 102 percent of par. What would be Katydid before-tax component cost of debt

Several methods to attack and defeat crysysptotems : Malicious individuals have discovered several methods to attack and defeat crysysptotems.

What is blood plasma : 1) What is blood plasma,and what is its functions?

User Account

All Pages