Ditutup

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

Keahlian Administrasi Basis Data, SQL

Lihat lebih lanjut: 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, create database music

Tentang Pemberi kerja:
( 0 ulasan ) Morocco

ID Proyek: #6131095

22 freelancer menawar pada rata-rata $43 untuk pekerjaan ini

paris2785

Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Lollipop (video demonstration) [url removed, login to view] and feedback a Lagi

$80 USD dalam 5 hari
(31 Ulasan)
5.7
pivn

let expert do this .......................................................................................................

$40 USD dalam 1 hari
(20 Ulasan)
5.4
manhpham

Hi there. I am senior developer. I have been working on this site for 3 years. I am interested in your [url removed, login to view] let's me help you.

$25 USD dalam 1 hari
(42 Ulasan)
5.5
it2051229

Hi I am placing my bid because I have read the partial requirements and I am confident enough with my database skills. I would like to do this project if you would give me the opportunity. I haven't found any attached Lagi

$30 USD dalam 1 hari
(62 Ulasan)
5.2
Reza2012

Hi I have more than 10 years experience in database administration and SQL query writing. Please check my profile. Thanks.

$40 USD dalam 1 hari
(33 Ulasan)
4.9
dobreiiita

Hi, I am SQL expert and can surely help you here with this project. I have a lot of experience in helping students with their assignments and tutoring. Please communicate to discuss further. I will start as soon as you Lagi

$30 USD dalam 1 hari
(46 Ulasan)
4.8
abdellatif81

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around databases and SQL de Lagi

$54 USD dalam 1 hari
(14 Ulasan)
4.5
acronymsolutions

Hi, I have gone through your requirements and attachment as well, I am a DBA at CMMI--5 Level company since August 2008.I am working on MySql,SQL ,SQl Server,Oracle database, I can do your job confidently. I am very mu Lagi

$54 USD dalam 2 hari
(33 Ulasan)
5.4
goswamiarpit475

Hi i am a postgraduate in Computer science and i can help you for sure to do this assignment. please visit my profile i have done many assignments related to this. Please visit my profile once to know about my past w Lagi

$45 USD dalam 1 hari
(9 Ulasan)
4.3
BhargavaB

Hi This is bhargava expert in sql/pl/sql . i am ready to provide quick and efficient solution . i had done similar kind f projects successfully .

$20 USD dalam 1 hari
(19 Ulasan)
3.8
yubor

A proposal has not yet been provided

$222 USD dalam 1 hari
(18 Ulasan)
3.7
webNeat

Hello ( or shall I say Salamo 3alaykom :) ) I am web programmer and have strong knowleadge of SQL; Let me help you with this assignment ;)

$25 USD dalam 1 hari
(1 Ulasan)
1.5
alagappanr

I have 6 + years of experience in Microsoft SQL and worked on different type of projects. Have good knowledge on administration and scripting.

$30 USD dalam 1 hari
(0 Ulasan)
0.0
dhamnesandesh12

Vast experience in writing complex queries with a good experience. Can easily finish this task within a day or two.

$20 USD dalam 1 hari
(0 Ulasan)
0.0
banualexandru

Hello, I'm a certified Oracle SQL Expert Professional with more than 6 years of experience. I will deliver the project in 3-4 hours after it will be assigned to me. Thank you, Alex.

$30 USD dalam 1 hari
(0 Ulasan)
0.0
TechStormTeam

Hi, I've read through your requirement. I know you need to do SQL ASSIGNMENT. We can discuss more about your project to clear requirement. With 100% completion rate, I will satisfy your need with my services. Looking f Lagi

$30 USD dalam 1 hari
(0 Ulasan)
0.0
caprodinco

thinking at the queryes..... Cd ----------- ID title number_of_tracks # can be obtained from count(tracks table joined with cd), but it is useful for speed-up queryes. Functional de-normalization record_compan Lagi

$29 USD dalam 2 hari
(0 Ulasan)
0.0
Alphaseekers

A proposal has not yet been provided

$30 USD dalam 1 hari
(0 Ulasan)
0.0
utpal90

Hi, I am a DBA by profession and I can do this within a day. Just give some information more on the relations. I can assure you the most perfect and best architectural queries. It will definitely be the most tuned one, Lagi

$25 USD dalam 1 hari
(0 Ulasan)
0.0
vworkerteam

Hi, I would like to submit my proposal for the project posted by you: 1. We are a team of 3 people who work together towards achieving goal 2. Being working in team increases enables to deliver fast and within timel Lagi

$35 USD dalam 1 hari
(0 Ulasan)
0.0