Database (Normalization and Entity Relationship Diagram)

DATABASE
Normalization and Entity Relationship Diagram

A. NORMALIZATION

1. Renter Table

2. Movie Table

3. RenterRentMovie Table

B. SQL,SELECT,JOIN AND PROCEDURE

1. Analyze Database

2. Input Record to All Table 

a. Create, Insert and Result Jenis Semester Table

b. Create, Insert and Result Periode Perkuliahan Table

c. Create, Insert and Result Dosen Table

d. Create, Insert and Result Mata Kuliah Table

e. Create, Insert and Result Kelas Table

f. Create, Insert and Result Jenis Nilai Table

g. Create, Insert and Result Fakultas Table

h. Create, Insert and Result Jurusan Table

i. Create, Insert and Result Mahasiswa Table

j. Create, Insert and Result krs Table

k. Create, Insert and Result Nilai Table

3. SELECT and JOIN SQL Query

a. Total mahasiswa in 1 classroom

b. Total class in 1 semester

c. Total class that thought by 1 lecture

d. Total mahasiswa / jurusan

e. Jurusan that have the biggest number of mahasiswa

f. Jurusan that have the smallest number of mahasiswa

g. Mahasiswa that have the highest score in 1 class

h. Mahasiswa that have the lowest score in 1 class

4. Make Procedure 

a. Total_one_room @classID

b. Total_class @periodeperkuliahan @jenis_semester

c. Total_class_lecture @dosenID