ISTM 4121 Midterm: ISTM4121 2015 Winter Solution

• School: GWU
• Department: Information Systems Technology Management
• Course: ISTM 4121
• Professor: All

Document Summary

Find a real world multi-table (relational) dataset which contains business-related data. Or choose one of the following pre-selected open datasets: Washington dc transit data (agree and submit to reveal the data download) Import the data into a spreadsheet, if necessary and/or possible, to get a feel for dataset properties like number of rows (size), and number, name and nature of attributes. Import the data into a database using the dbms of your choice. Describe the dataset entities and relationships, including your reaction to and assessment of the logical dataset design. Write sql queries to ask questions of the data and process the data into information. Use the join and left join clauses demonstrated in class, as well as other previously- demonstrated single-table clauses and functions. Tell a story based on the knowledge you were able to acquire as a result of your data processing and analysis. Write 2-5 paragraphs in english describing what you learned.