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, 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, email database music

Tentang Pemberi kerja:
( 0 ulasan ) Delhi, India

ID Proyek: #6139579

17 freelancer menawar pada rata-rata $65 untuk pekerjaan ini

mainpoint

A proposal has not yet been provided

$111 USD dalam 1 hari
(5 Ulasan)
4.9
yubor

A proposal has not yet been provided

$222 USD dalam 1 hari
(17 Ulasan)
3.7
joseluiselp

Let me know if you are interested. Jose luis mendoza .

$35 USD dalam 3 hari
(2 Ulasan)
3.0
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 Lagi

$30 USD dalam 1 hari
(2 Ulasan)
1.8
derley

Hi, More than 4 years 'speaking' SQL Server and MySQL and 3 SQL certifications :) I think I can help, and have some SQL fun.. Hope to collaborate! Regards, Derley

$30 USD dalam 1 hari
(3 Ulasan)
1.2
bhawin91

A proposal has not yet been provided

$54 USD dalam 1 hari
(0 Ulasan)
0.0
IRStech

Hi I am Dr. Asad Have been teaching database design and analysis to undergrads for the past 10 years. I can do this for you very easily let me know Asad

$29 USD dalam 1 hari
(0 Ulasan)
0.0
raskolnnikov

3+ years of experience as a DBA / BI Developer. Fluent in MySQL, MSSQL and postgreSQL. Can provide clean, plagiarism-free and well documented code.

$40 USD dalam 1 hari
(0 Ulasan)
0.0
maddykumar

hi this are the basic quires . i can do this project with in 2 days .so whan i will start this project

$23 USD dalam 1 hari
(0 Ulasan)
0.0
dar5han111

A proposal has not yet been provided

$35 USD dalam 1 hari
(0 Ulasan)
0.0
pointblank25

I am currently a Data Integration Specialist. Have been using Oracle database for 3years, other database like MySQL Postgre Ingres/Vector SQL Server and other columnar database. Data Migration and Data Warehouse were s Lagi

$150 USD dalam 1 hari
(0 Ulasan)
0.0
maheshmadushanka

Hi I'm a DB and Warehousing Engineer. The requirement is directly base on a DB modle so i can provided a script with Required DDL for creating the Mysql DB with all the relationship and required condition

$30 USD dalam 4 hari
(0 Ulasan)
0.0
rainmanhhh

Hi, I need more information about this project. Which language do you prefer to implement this CD shop management application? If you do not care, I plan to use java. There should be several tables to store CD/t Lagi

$25 USD dalam 3 hari
(0 Ulasan)
0.0
ashacm

I do have 10+ years of experience. Has been part of database design of few major projects. I do have experience in MYSQL and POSTGRESQL. I would like to hear from you.

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

Hello Dear, How complex it could be, more complex I done. An expert for SQL SERVER is here. Front end will be in VB.NET or else. I can do it for your pleasure. Can give me a chance. Thank you

$111 USD dalam 1 hari
(0 Ulasan)
0.0
anujak999

Dear Sir I am 7+years experienced developer and can do this task at low cost and short span. Kindly grant me the opportunity to work with you. Regards

$45 USD dalam 3 hari
(0 Ulasan)
0.0
DeadC0der

Hi there , I'm delphi coder I used to do similar jobs just like the one you have mentioned I mean writing database driven application using the latest technologies like FireDac,ADO,Zeos and so forth with the latest RDB Lagi

$150 USD dalam 7 hari
(0 Ulasan)
0.0
caprodinco

don't see any attachment! I think this could be the model: 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 Lagi

$24 USD dalam 3 hari
(0 Ulasan)
0.0
vganeshbabu

Hi, I am working professional in the database space for more than 10 years.. I will be your best guy to get this job done. let me know if you want to discuss this further and accept my bid. regards, ganesh

$25 USD dalam 1 hari
(0 Ulasan)
0.0