Professional Memo



MemorandumDepartment of AccountancyEast Tennessee State UniversityTo:4310 StudentsFrom:Gary G. BergDate: TIME \@ "MMMM d, yyyy" September 19, 2013Re:Assignment 2 – Importing Data from an Excel worksheetThis assignment will require you to create a database containing 9 tables. You will be required to import nine worksheets from the XYZ Excel file (2k7 or later format) that I have place on the web site. The nine tables you will create will be for:SalesCustomerInventorySales-InventoryEmployeeCashCash ReceiptEmployee CategorySale Cash ReceiptEach table has an attribute(s) which will serve as the primary key in the table you create. For each table you create from importing the worksheet, you will need to set a primary key using one or more of the data attributes you import .(I will not tell you what that key is)Do not add any additional attributes. Two tables will require a concatenated primary key. You will need to establish all necessary relationships making sure you Enforce referential integrityI have a video demo & pdf file on the class web site on importing data from an Excel workbook.Submit the completed file via the D2L dropbox.:Files submitted to the wrong dropbox will receive a grade of 0If you have an issue and need me to take a look at what you have done, send the file as an email attachment to Acct4310@bergg.etsu.edu.I will not tell you the answer, but I will try to point you in the right directionDue on Friday, September 27th.. (missing this deadline will result in grade of zero)Remember, file must be virus free. (assignment received containing a Virus receives a grade of 0) ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download