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
#2,670 dari 96,983
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.55/10.00
9,721 Point
#3 dari 96,983
Rated Owner: 10.00/10.00 good job...
thanks ya gan..

  User Bids

RGSolutions
    
9.69/10.00

Iswanto
    
9.55/10.00

Syahlevi
    
8.82/10.00

fiiqramadhan
    
0.00/10.00

Recommended Workers

lexdorf17

13,608 points
53 projects
    
9.74/10.00

Iswanto

9,721 points
176 projects
    
9.55/10.00

rolldev

4,167 points
8 projects
    
8.67/10.00

mas.adi

4,414 points
19 projects
    
9.74/10.00

idlamalif

4,572 points
78 projects
    
9.86/10.00

Recommended Services

Pembuatan template website

Rp 300,000
8 sales
    
10.00/10.00

Pembuatan bot line

Rp 1,500,000
2 sales
    
10.00/10.00

Jasa Pembuatan Website Streaming Film

Rp 750,000
3 sales
    
9.33/10.00

Jasa pembuatan website portal berita auto content

Rp 950,000
2 sales
    
10.00/10.00

Open Projects

[Front-End & Wordpress] Smartphone Mockup Carousel/Slider

Open to SuggestionsOwner: paboss
Deadline: 3 days

Pembuatan Website dan Database Panel Like Instagram

Rp 5,000,000Owner: schmew
Deadline: 21 days

Membuat Freelance www. sxxxxxxxxxr. com Web Native php boostrap

Open to SuggestionsOwner: obet021
Deadline: 7 days

Buat aplikasi kasir berbasir PHP

Open to SuggestionsOwner: danudenny
Deadline: 5 days

Mau buat website sekolah

Rp 1,000,000Owner: mohd-F
Deadline: 7 days