Normalisasi & Entiti Relasi Database buat Belajar

 

Saya butuh normalisasi database dari sebuah tabel service ac, masalahnya saya gagal paham normalisasi database hohoho... maklum kebanyakan maen game online 

tabel terlampir di attachment.

yang saya butuhkan normalisasi database beserta relasinya primary key dan foreign key, dibuat dalam tabel erd (diagram dan entitinya), terus sintax mysql lengkap untuk mengisi tabel2nya, serta menguji dan menampilkan hasil relasi tabelnya.

terima kasih buat kk yang mau bantu saya, budget apa adanya maklum buat belajaran.







Database Programming MySQL PHP

Project Class: Micro (Under 500rb)
Published Budget: Rp 65,000
Finish Days: 7
Published Date: 02/04/2016 17:43:26 WIB
Start Date: 02/04/2016 18:58:16 WIB
Project Status: Closed
Accepted Worker: Iswanto (Iswanto)
Accepted Budget: Rp 70,000
Project Ending: Completed
Finish Date: 09/04/2016 14:00:09 WIB

Project Owner

saitamakun
Kota Denpasar
    
10.00/10.00
8 Point
#3,779 dari 121,925
Rated Worker: 10.00/10.00 Hasil pekerjaan super fast, very recommended, very professional and lancar jaya,  sesuai dengan kebutuhan saya, komunikasi lancar, walau saya sedang sakit di 2 hari terakhir hehehe......

Accepted Worker

Iswanto
Kota Jakarta Barat
    
9.62/10.00
12,326 Point
#3 dari 121,925
Rated Owner: 10.00/10.00 good job...
thanks ya gan..

  User Bids

RGSolutions
    
9.73/10.00

Iswanto
    
9.62/10.00

Syahlevi
    
8.94/10.00

fiiqramadhan
    
0.00/10.00

Recommended Workers

Iswanto

12,326 points
249 projects
    
9.62/10.00

bl4ck4nt

10,972 points
85 projects
    
9.28/10.00

imzers

5,926 points
38 projects
    
9.86/10.00

steven.comptia

11,653 points
335 projects
    
9.93/10.00

irvanseptian.com

5,885 points
22 projects
    
9.68/10.00

Recommended Services

Pembuatan bot line

Rp 1,500,000
5 sales
    
10.00/10.00

Jasa Pembuatan Website Streaming Film (Isis 3500+ Film)

Rp 1,000,000
3 sales
    
9.33/10.00

Jasa Pembuatan Website Cepat dan Murah

Rp 500,000
1 sales
    
10.00/10.00

[JASA] Pembuatan Website Membership + Program Afiliasi

Rp 1,100,000
1 sales
    
9.00/10.00

Open Projects

membuat aplikasi marketplace

Open to SuggestionsOwner: Grapadi
Deadline: 20 days

Custom Order flow woocommerce untuk penjualan jasa

Open to SuggestionsOwner: xdesain
Deadline: 5 days

Project Website SSO

Open to SuggestionsOwner: JakartaWebFisrt
Deadline: 14 days

Website Company Profile

Open to SuggestionsOwner: JakartaWebFisrt
Deadline: 30 days

Rombak Ulang Website

Open to SuggestionsOwner: dardapritama
Deadline: 14 days