This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: MIS 235 Fall 2010 Section F, G, L Group Exercise SQL Objectives: • Work with Oracle database and use SQL to retrieve data • Better understand the role of data in business decision-making Description Northwinds has hired you to the position of Senior Oracle Reports Developer. In this position, you are responsible for creating reports from their Oracle database that help support the firm’s field consultants and analysts. The database that is being used by NorthWind has the following data model: The tables all use the prefix mis235. So if you want to retrieve all the suppliers for example, you would use select * from mis235.suppliers John Doe, a Senior Analyst with Northwinds, has sent an e-mail asking for the information below. John is on the way to a meeting and needs these answers in 75 minutes. Your team’s task is to answer the questions for John. You should create a Word file that provides the following for each question: a) the SQL query that you wrote, b) a copy (partial if appropriate) of the table results of your query, and c) unless...
View Full Document
- Fall '08
- Microsoft SQL Server, Northwinds, Current list price