Access tables and relationships
Assignment 3 – Access Tables and Relationships IDS 200 BBA- Spring 2024 Due on Thursday, 3/24/2024, at 11:59 pm 50 points Instructions A. You must create an Access database which contain six tables: Vendor, SalesRep, Buyer, Item, Transaction, and TransactionElement. Design the tables with the by fulfilling all the requirements specified below: No. Grading Point Table Field Data Type Primary Key Foreign Key 1. [6 points] Vendor Code Name AutoNumber Short Text, Field Size 20 Code – Address State Short Text, Field Size 25 Short Text, Field Size 2 Zipcode ID Short Text with 00000 Input Mask Number ID VendorId LastName FirstName Short Text, Field Size 15 Short Text, Field Size 15 VendorId Number Phone Short Text Fax ID Short Text Number ID – LastName FirstName Short Text, Field Size 15 Short Text, Field Size 15 Phone Short Text Fax ID Short Text AutoNumber ID VendorId Name VendorId Short Text, Field Size 15 Number UnitPrice Number InvoiceNumber VendorId AutoNumber Number InvoiceNumber VendorId SalesRepId SalesRepId Number BuyerId Date Amount Received Number Date/Time, Format Short Date Number Yes/No, Default Value No Paid Yes/No, Default Value No ItemId InvoiceNumber Number Number Quantity Number Amount Number 2. 3. 4. 5. 6. [7 points] [6 points] [5 points] [10 points] [6 points] SalesRep Buyer Item Transaction TransactionElement BuyerId ItemId InvoiceNumber InvoiceNumber B. [4 points] Enter two data items into the Buyer table. The first data item should have your information (use your real first name and last name but you can enter any number for phone and fax numbers). The second data item can be random. Page 1 of 2 Assignment 3 – Access Tables and Relationships IDS 200 BBA- Spring 2024 C. [6 points] Build relationships between the following tables by linking the foreign key fields to their original tables: • SalesRep.VendorId to Vendor.Code • Item.VendorId to Vendor.Code • Transaction.VendorId to Vendor.Code • Transaction.SalesRepId to SalesRep.ID • Transaction.BuyerId to Buyer.ID • TransactionElement.InvoiceNumber to Transaction.InvoiceNumber D. Save the Access file as Assignment3-YourNetID, for example Assignment3-jdoe2 if your NetID is jdoe2. E. Submit the file using the designated link in Week 3 folder on Blackboard by the due date. Page 2 of 2
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
