{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}


database-assignment - TIM 50 Database Assignment(Deadline...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
TIM 50: Database Assignment (Deadline: Nov 28, 2010) Background The purpose of this database assignment is to give you an idea of what a database is, as well as give you some hands-on experience with Database Management Systems (DBMS). As you have learned in class, the main goal of a DBMS is to enable people to store, access, and manipulate large amounts of data. To give you a rough idea of a “large amount of data”, you are provided with a dataset consisting of more than 5900 records. The dataset can be downloaded from here . We will use Microsoft Access 2003 as the DBMS for this assignment (a later version of Access should also work). The data set is adopted from Damodarn 1 who records data from all publicly traded firms with a market capitalization of more than $10 million dollars. Some of the columns are discarded for the sake of simplicity (you can find the original data set by following the link in footnote [1]). The data set is in Microsoft Excel Spreadsheet format (.xls), and you need to convert it into Microsoft Access database format. To do this, please refer to the URL below for instructions of how to import Excel data into Access: http://office.microsoft.com/en-us/access/HP010950951033.aspx Once you have a working database (a table, to be precise), you can then analyze the data, and you can start answering interesting questions. You will need to use queries to extract information from the table. So, create queries in Access to answer the following questions (provide us only the query for your answer unless specifically asked to do otherwise, but you will also have to execute the query in order to answer some of the multi-part questions): Question 1 1 A. Damodarn. Available online at: http://www.stern.nyu.edu/~adamodar/pc/datasets/compfirm.xls
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
a) Make a list with all the columns but group (sort) records by
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}