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. 2 51作业君版权所有