Reference no: EM133335373

Databases for Business Analytics Assignment

For this assignment, please create a GoogleDoc in your .nyu.edu account. Include your name and clearly label the answers to each question. Then, upload your document from your GoogleDrive to Content > Lesson 1 > Assignment 1 in Brightspace.

Question 1. Briefly describe two problems that can occur when using spreadsheets to organize data.

Question 2. Review the Art Classes example. Then, create a relational design for the data using multiple tables. Hint: This is similar to the Adviser/Student example.

Question 3. The following are column headings found in spreadsheets with the indicated names. Use the spreadsheets in answering questions 3a, 3b, and 3c.

Spreadsheet 1
• Name of the spreadsheet: EQUIPMENT
• Column headings: (Number, Description, AcquisitionDate, AcquisitionPrice)

Spreadsheet 2
• Name of the spreadsheet: COMPANY
• Column headings: (Name, IndustryCode, GrossSales, OfficerName, OfficerTitle)

Spreadsheet 3
• Name of the spreadsheet: COMPANY
• Column headings: (Name, IndustryCode, GrossSales, NameOfPresident)

Spreadsheet 4
• Name of the spreadsheet: COMPUTER
• Column headings: (SerialNumber, Make, Model, DiskType, DiskCapacity)

Spreadsheet 5
• Name of the spreadsheet: PERSON
• Column headings: (Name, DateOfHire, DeptName, DeptManager, ProjectID, NumHours, ProjectManager)

3a) 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, it depends on the assumptions you make. In these cases, state your assumptions.

3b) For the spreadsheets with more than one theme, break up the columns into sets, so each set has a single theme. Add a column (or columns) to maintain the relationship between the themes.

3c) For the spreadsheets with more than one theme, show at least one problem when inserting, updating, and deleting data.

Note: Need only answer question 2 and 3