Design Basic database from some csv data
$10-30 AUD
Paid on delivery
Here is the scenario
The client has been accessing the information via a flat .csv file, reading the information, processing
it and then closing it down. It has been decided they would like to keep the information in a
database so it can be accessed without the need to re-import the file each time.
The client has decided to allow Skillage I.T. to design the data table in whatever structure and using
whichever database we deem suitable.
Please generate the following items to create a successful resolution for our client.
1. Choose which database you will use to hold the data, and write a document of 200 words or
less explaining your choice and the benefits and possible downfalls.
2. Create the table(s) required in the database ensuring the correct schema is applied.
3. Import the data from the .csv file into the database.
4. Produce a collection of documents and diagrams that outline the database design.
The deliverables include:
a. An Entity Relationship or Object diagram
b. Data Structure
i. Primary and Foreign keys
ii. Indexes
iii. Data dictionary (meta data)
iv. Normalisation profile
c. An outline detailing your design choices and reason (250 – 500 words)
d. Submission of final database to instructor for assessment
I already have done write ups based on my attempt at it but for some reason my database isnt working properly so ill need someone to help me out with this as im time deprived at the moment.. Happy to chat about it too ive uploaded my write ups as well as the project files
Thanks Anthony
Project ID: #14540013
About the project
12 freelancers are bidding on average $32 for this job
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More
I have read your add about making a db from CSV file. We have skilled db developers. Relevant Skills and Experience We have commands in C/C#/Java/AndroidSDK/SQL/PHP/ASP/HTML5. Proposed Milestones $10 AUD - Fee
data base development Relevant Skills and Experience Database Proposed Milestones $111 AUD - complete
I'm experienced well on SQL mantain and developement. i assure you to provide good quality service