OPERATING SYSTEM CMD WINDOWS

OPERATING SYSTEM
Command Prompt in Windows

1. Open Command Prompt

2. Change color to green

3. Move to D

4. Make folder "YourName"

5. Make folder FinalExam

6. Go to FinalExam directory

7. Make text file Final_Exam.txt and write your name inside

8. Copy Final_Exam.txt to (your NIM) directory

9. Delete Final_Exam.txt in FinalExam directory

10. Rename the remaining Final_Exam.txt to (Your First Name).txt

11. Your pc network information

12. Make connection test to www.esaunggul.ac.id

13. Show all ip that connected to same network as yours

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