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 ) Gurgaon, India

ID Proyek: #6140649