联系我们： 手动添加方式: 微信>添加朋友>企业微信联系人>13262280223 或者 QQ: 1483266981

DATABASES FOR BUSINESS ANALYTICS: ASSIGNMENT 1 Kristen Sosulski 9/3/2024 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. 1. 10-points Identify and explain two problems that can occur when using spreadsheets to organize data. 2. 60-points Review the Art Classes example below. Create a relational design for the data using multiple tables. Hint: This is similar to the Adviser/Student example. 3. 30-points 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 1 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, Project- Manager) 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.