The ADA shop at jl. Mataram, semarang city, held an employee selection as an appreciation for the

Fantastic news! We've Found the answer you've been seeking!

Question:

The ADA shop at jl. Mataram, semarang city, held an employee selection as an appreciation for the work given by employees. If you know the business process as follows:

Admin can manage employees, employee level and criteria

Managers see the results of employee appraisals carried out by supervisors of their subordinates.

Supervisors provide an assessment of their subordinates.

The criterion defined as an assessment is Character (C1) with a weight of 0.2

Discipline (C2) with a weight of 0.25 Responsibility (C3) with a weight of 0.25 Ethics (C4) with a weight of 0.3

Employee name and rating

Employee name C1 C2 C3 C4 Henox Claudian 70 80 75 85

Sumanto 75 80 85 85

Triyanti 60 70 80 80

Pasiran 50 60 70 80

Elda Yunita 80 80 85 85 Sari

Problem 1: (10 Points)

From the above problems, how to approach the database, especially the advantages and disadvantages of using databases!

Problem 2: (15 Points)

Describe the Entity Relational Model

may be described in the form of a class diagram or Entity Relational Diagram

Problem 3: (20 Points)

Prove that the ER Model described is normal, there are no redundancies or anomalies!

Problem 4: (15 Points)

Write SQL to create databases and tables that you have created!

Problem 5: (15 Points)

Write SQL for Managers in getting the best employees!

Problem 6: (15 Points)

Write a PHP or XML script to create a dashboard for managers to get the best employee assessment reports for each event!

Problem 7: (10 Points)

Give a further picture if you want to develop into data mining or data warehouse from the order transaction data owned by the bank! including the method that should be used and provide reasons why to use that method!