Design Basic database from some csv data

In Progress Posted 6 years ago Paid on delivery
In Progress 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

Database Development Microsoft SQL Server SQL

Project ID: #14540013

About the project

12 proposals Remote project Active 6 years ago

12 freelancers are bidding on average $32 for this job

schoudhary1553

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

$50 AUD in 1 day
(31 Reviews)
6.2
usman1493

Hey A database expert is here I have good advanced expertise in database development Feel Free to message me I can do the database task for you Regards Relevant Skills and Experience Database development SQL mysql Pr More

$15 AUD in 0 days
(27 Reviews)
5.1
sanutv

Hi, I would like to take up this project. I gone through the requirement and would like to discuss more about the project. Relevant Skills and Experience SQL, MYSQL, SQLITE AND ORACLE. Proposed Milestones $25 AUD - More

$25 AUD in 1 day
(10 Reviews)
3.4
MaWareAndTech

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

$10 AUD in 1 day
(1 Review)
0.8
giritech

GRAPHIC DESIGN I WILL DO EXCELLENT DESIGN WITH UNLIMITED REVISIONS + CHANGES TILL HAPPY:) Hello, Please allow me to introduce myself. My name is GIRISHA, And I have been a graphic designer for the past 7+ More

$11 AUD in 1 day
(0 Reviews)
0.0
jitesh445

A proposal has not yet been provided

$25 AUD in 1 day
(0 Reviews)
0.0
altafunic

data base development Relevant Skills and Experience Database Proposed Milestones $111 AUD - complete

$111 AUD in 3 days
(0 Reviews)
0.0
paweostrowski

I'm experienced well on SQL mantain and developement. i assure you to provide good quality service

$20 AUD in 2 days
(0 Reviews)
0.0
udfirewolf

A proposal has not yet been provided

$25 AUD in 1 day
(0 Reviews)
0.0