Database- converting access to sql
Place a Bid
Amount you will charge($) A 10% transaction fee will be added to your bid
Submit
Bids Placed by Scholars
No Bids Placed Yet, Consider Upgrading Your Project
Actions
Bookmark Project
Details
Posted By View Student Profile
Subject Computer
Deadline (Pacific Time) 04/28/2017 12:00 am
Budget $30-$100
I need an excel file (6 access tables) converted to a executable sql script that I can copy and paste into developer. In addition to the tables, I need the primary keys and foreign keys that are assigned in access to also be included in the script that i can exectute in sql developer. I have loaded the excel file which shows all 6 tables and data. I also loaded a word document detailing the primary keys and foreign keys.
Proposed tables:
1. VISIT INFO: STING ID (PK), DATE, RETAILER, TIME IN, TIME OUT, UNDERCOVER (FK to name), INVESTIGATOR (FK to name)
2. TICKET: STING ID (PK), TICKET, TIME STAMP, COMMENTS
3. PSR: PSR # (PK), RESULT
4. RETAILER: Retailer ID (PK), retailer name, retailer address, retailer city
5. TRANS INFO: TRAN ID (PK), DATE, RETAILER ID (FK), MONEY SPENT
6. PERSON STATUS TABLE: PERSON ID (PK), NAME (FK), STATUS
