Assigment Sql db Queries

Closed Posted Jul 1, 2014 Paid on delivery
Closed Paid on delivery

We will create an application to manage the system of a cd shop.

Firstly we have the CD that might be a mix of singles or an album and is identified by an id, title, number of tracks, record company and description. A track has title, length, and the singer/s or band. A CD has at least 5 tracks.

This cd might belong to one single artist or a band. If a singer it is identified by an id, name, surname, nickname (if any) and if band it is identified by id and name.

CDs have Category that is identified by an id and description that includes genres of music (ex. alternative, rock, r&b, pop etc).

We have also a branches that are identified by an id, name, address, contact phone number and contact email.

Our shop has its own customers that are identified by id, name, surname, birthday, email.

In the database all CDs available is a branch shop are stored and number of copies. Moreover, for each customer we keep trace of the CD and the branch where he/she bought it.

Requirements are attached

Database Administration SQL

Project ID: #6136385

About the project

17 proposals Remote project Active Aug 7, 2014

17 freelancers are bidding on average $48 for this job

eperfections

10+ years sQL experience. 600+ projects completed successfully. I am very interested in this project. No file attached. Please send details. Ready to start ASAP

$24 USD in 1 day
(107 Reviews)
6.5
abdellatif81

Aucune proposition n'a encore été fournie.

$64 USD in 3 days
(14 Reviews)
4.5
emmett25ro

Hello Sir, I have been working with SQL databases for 5 years (SQL Server and Oracle) and I can help you with this project. Please attach requirements so I can be sure that my bid is correct. Best regards, Alex More

$50 USD in 3 days
(5 Reviews)
4.3
yubor

A proposal has not yet been provided

$222 USD in 1 day
(18 Reviews)
3.7
oobretenov

Where is requirements . . . .

$55 USD in 1 day
(1 Review)
3.1
PHPsoldier

Lets do it. Many thanks.................................................................................................................

$25 USD in 1 day
(5 Reviews)
3.4
ryonkol

Experienced php/mysql programmer here, can provide exact what you need, can you please show me the existing site? also no docs are attached with this project post. Thanks

$100 USD in 3 days
(1 Review)
2.2
santosoftvw

Dear Customer, I have 7 years of experience as a software engineer. I am Oracle certified Database SQL Expert. I have experience in SQL dor DDL, DML and DCL. I have experience in developing data model. I am experienced More

$30 USD in 1 day
(2 Reviews)
1.8
powerbrij007

hi, please send me some of your ideas or any requirements so that I can understand your need in a better way... along with the file, waiting for your response ... thank you..

$30 USD in 7 days
(0 Reviews)
0.0
waqarven0

I have a real experience in this field. I have already developed a software similar to your requirement, on your request I will show you my developed software for your satisfaction. I will perform your job dedicatedly More

$25 USD in 2 days
(0 Reviews)
0.0
rviquez

I have plenty of experience designing databases and handling queries. I have designed databases for 50+ major projects.

$30 USD in 2 days
(0 Reviews)
0.0
mudassir93

Hi, I have read your requirements carefully and able to do it for you. I can do it on both MS SQL or My SQL on which you want. As I am new on freelancer and done few projects so my profile is not so much impressive More

$25 USD in 1 day
(0 Reviews)
0.0
jabeensafiasafia

i have understood your project needs, I have already worked on SQL. I have done projects using SQL during my engineering.

$25 USD in 1 day
(0 Reviews)
0.0
amilcarbg75

I have experience on mySQL, MicrosoftAccess, SQL-Server and PostgreSQL databases. All you need is to be available just in case I have any question.

$50 USD in 3 days
(0 Reviews)
0.0
sudhirbisht

• Around 11+ years of experience in software industry. • Last position as Tech Lead of Ops IT APAC Emerging Markets, working for UBS Hong Kong as a Consultant. • Experience is more towards designing and development i More

$25 USD in 1 day
(0 Reviews)
0.0
trihit88

I am having good experience as database developer. Here I am looking for my first project and will work for free.

$15 USD in 1 day
(0 Reviews)
0.0