Closed

Assigment Sql db Queries

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

Skills: Database Administration, SQL

See more: singer 22, rock singer available, create music mix, sql r, sql in r, r sql, cd album, Sql Database administration, rock band, email administration, music album database, album database, create band name, title number, database system sql, artist band, trace email address, create rock band name, create music database, music database sql, trace email, database music rock, phone shop database, database keep track customers, shop sql

About the Employer:
( 0 reviews ) hyderabad, India

Project ID: #6137842

14 freelancers are bidding on average $41 for this job

riskypathak

The scenario looks fine. But what i need to do? Develop database, design it, ER diagram, query it or what?? Also there is no attachment

$34 USD in 1 day
(23 Reviews)
4.4
yubor

A proposal has not yet been provided

$222 USD in 1 day
(17 Reviews)
3.7
mamoonraza

Hello, Will be done within 3-4 hours. Payment after you get the SQL. If you have any questions feel free to ask!!

$30 USD in 1 day
(1 Review)
1.7
ajitdeswal

I have 5+ year of experience in Java/J2EE development.I have good hands on experience in making web application using Struts 2.0 and Spring 3.0 with Hibernate as ORM . I have also developed a web based reporting server More

$30 USD in 1 day
(1 Review)
0.0
vidhyapathy

Dear SIr, I would like to do this task. Please provide me requirements. I have 4+ year exp in software development.

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

A proposal has not yet been provided

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

hello................message me ..............i can do this assignment in 1 hr............i am waiting for your response....Thank You....Regards

$30 USD in 0 days
(0 Reviews)
0.0
seventechworld

We have working on PHP, WordPress, Code-igniter, WebDesign (PSD To HTML, PSD to Wordpress Template) Ajax, JavaScript, CSS HTML5 since last two year with our experience developer team. Our team have interesting to do th More

$35 USD in 2 days
(0 Reviews)
0.0
tuvu82

Hello, I'm a senior software developer but I'm new freelancer so I will make free for you, contact me and I can help you.

$10 USD in 5 days
(0 Reviews)
0.0
masoud17

Dear employer, I cannot find your attachment, but I am able to do any SQL queries. I'm working wit Database design and SQL queries for many years in different projects include: one of my country national banks, KDD More

$15 USD in 1 day
(0 Reviews)
0.0
vanpham

A proposal has not yet been provided

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

Hi, I am interested in this project. Experience working into Oracle 11g , Postgres Writing complex queries, optimizing DB etc Regards, Vishal

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

Dear, For the lest 10 years, I have experience of working with Microsoft SQL Server 2005 / 2008, databases, T-SQL, stored procedures and views, using cursors where necessary, database normalization and optimization, More

$30 USD in 1 day
(0 Reviews)
0.0
samyu115

I have more than 3 years of experience in writing SQL queries.i believe i will be able to do this assignment.

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

I am a professional with over 5 years experience in databases and software development at an advanced level. I recently undertook a similar project though it was assignment based and would be happy to help you on this. More

$45 USD in 1 day
(0 Reviews)
0.0