|
|
This is only a preview of the paper
Click here to register and get the full text.
Existing members click here to login
|
|
|
Files There is a database (mdb) file necessary for this assignment. You must make a copy of the Assign2.mdb file for your own use. The file is located in: P:Commerce Finance & Management ScienceCIS225Fall2004AssignsAssign2 Reading The reference material needed to complete this assignment is drawn from both the text (see syllabus) and classroom lectures. Requirements Please read the instructions and questions thoroughly and carefully to ensure that you understand the requirements and understand what you are to submit for grading. Part 1 – Assign2.mdb Requirement 1: Tables 1. In your copy of Assign2.mdb, create a new table named “Products”. In this table enter the following field names: Product ID, Product Name, and Unit Price. Choose appropriate data types for each field and designate an appropriate primary key for this table. 2. Enter the following 5 records into the table you have just created. Product ID Product Name Unit Price HB056 Using Netscape Communicator 4.79 $69.95 HB163 Windows XP $324.95 HG058 Encyclopedia for Windows XP $29.95 HS049 Introduction to SQL $49.95 HW052 Office 2003 for Students $224.95 3. Add a new field named ‘Quantity in Stock’ after the Product ID and enter the following values representing quantities in stock for each product: 12, 13, 15, 18 and 22. 4. Designate a primary key for the Customer table. 5. Add the following as a new record to the Customers table: Customer ID Name Saint Mary’s University Address Robie Street City Halifax Province NS Pcode B3H 3C3 Phone (902) 420-4242 Lname Fname Last Contact Credit Limit $5000 Sales Region East Comments Please make a note of the Customer ID that is allocated by Access.
Approximate Word count = 1031
Approximate Pages = 4.1
(250 words per page double spaced)
|
|
|
|
|
|