Soal LKS Nasional 2018 [PDF]

Citation preview

LKS SMK Tingkat Nasional Ke-XXVI Tahun 2018



Tingkat Nasional XXVI 2018



Soal BIDANG LOMBA



IT-Software Application



KEMENTERIAN PENDIDIKAN DAN KEBUDAYAAN DIREKTORAT JENDERAL PENDIDIKAN MENENGAH DIREKTORAT PEMBINAAN SEKOLAH MENENGAH KEJURUAN Kompleks Kemdiknas Gedung E Lantai 12-13 Jalan Jenderal Sudirman Senayan Jakarta 10270 Telepon (021) 5725477 (hunting), 5725466-69, 5725471-75 Fax. 5725467, 5725469, 5725049 Site: www.ditpsmk.net



PROJECT OVERVIEW



In this Test Project, you are required to develop an information system following the requirement given on the Test Project. In general, there will be 4 project resources given to you, which is: 1. ERD and Data Dictionary for Test Project This will be used to guide you to create the database files. Ensure that all entities created on the database are related with the given ERD, following the relationship and also the criteria in Data Dictionary for each entity! 2. Navigation Diagram for the Application Use the Navigation Diagram to develop the form interaction inside the application. You are free to add new interaction between forms, without neglecting the defined interaction in this diagram. 3. Example Design (Wireframe) of desired Information System This file is used to give you design guidelines of all required forms. Please note that your form designs are not limited to these examples! 4. Data files (if any) The data files will be used to support you test and develop the information system on each module. Please use this data files in the development, you are allowed to use another resources outside the given data files only if instructed in the module.



Soal LKS SMK XXVI Tahun 2018



Hal 2 dari 27



TESTING ENVIRONMENT Your work will not be tested on your development machine. Use the following instructions to make sure that your project can be moved to the testing computer. FILE/FOLDER STRUCTURE File picture images are stored in the database as filenames (string), not as images (binary data). This means that you will need to use the filenames stored in the database to access the files that are stored elsewhere on the computer. The testing computer will have the following folders set up on it with the relevant images inside: • bin/Debug/ of Your project folder. All file picture images as provided in images.zip Create these folder on your development machine to make sure that your project can be tested on the testing computer. DATABASE CONNECTION Use the following details when connecting to your database. SQL SERVER



FILES TO SUBMIT AFTER EACH SESSION For module 1 - 5 , please submit the following items on Drive E:\COMPXX\MODULYY (XX is computer number and YY is modul number) to make sure that your work can be tested: •



SQL script to recreate your database (must create all tables, insert data, define relationships and create any other objects such as stored procedures and views)



• All source code • A compiled executable of your application (EXE file or APK file) • Any other relevant files



Soal LKS SMK XXVI Tahun 2018



Hal 3 dari 27



SMK NUSANTARA INFORMATION SYSTEM ENTITY RELATIONSHIP DIAGRAM



Soal LKS SMK XXVI Tahun 2018



Hal 4 dari 27



SMK NUSANTARA INFORMATION SYSTEM DATA DICTIONARY



Tabel



KEY PK



Required?



integer



Y



Name Price Photo Carbo Protein



nvarchar(50) integer nvarchar(100) integer integer



Y Y Y Y Y



Id



integer



Y



Name Email Handphone JoinDate Id Name Email Password Handphone Position



nvarchar(50) varchar(50) varchar(13) date char(6) nvarchar(100) varchar(50) char(128) varchar(13) nvarchar(50)



Y Y Y Y Y Y Y Y Y Y



PK



Id



char(12)



Y



FK FK



Employeeid Memberid Date PaymentType CardNumber Bank



char(6) integer date varchar(20) varchar(16) nvarchar(50)



Y Y Y



PK



Id



integer



Y



FK FK



Orderid Menuid Qty Status



nchar(10) integer integer varchar(10)



Y Y Y Y



PK MsMember



PK MsEmployee



OrderDetail



Tipe Data



Id



MsMenu



OrderHeader



Kolom



Soal LKS SMK XXVI Tahun 2018



Notes Auto Increment



Auto Increment



Auto Increment FK to employee FK to member



Auto Increment FK to order FK to menu



Hal 5 dari 27



SMK NUSANTARA INFORMATION SYSTEM WIREFRAME



01 Login Form



02 Admin Navigation Form



Soal LKS SMK XXVI Tahun 2018



Hal 6 dari 27



03 Chef Navigation Form



04 Cashier Navigation Form



Soal LKS SMK XXVI Tahun 2018



Hal 7 dari 27



05 Manage Employee Form



06 Manage Menu Form



Soal LKS SMK XXVI Tahun 2018



Hal 8 dari 27



07 Manage Member Form



08 Change Password Form



Soal LKS SMK XXVI Tahun 2018



Hal 9 dari 27



Soal LKS SMK XXVI Tahun 2018



Hal 10 dari 27



09 Order Form



10 View Order Form



Soal LKS SMK XXVI Tahun 2018



Hal 11 dari 27



Soal LKS SMK XXVI Tahun 2018



Hal 12 dari 27



11 Payment Form



12 Report Form Soal LKS SMK XXVI Tahun 2018



Hal 13 dari 27



Soal LKS SMK XXVI Tahun 2018



Hal 14 dari 27



THE DEVELOPMENT OF SMK Restaurant INFORMATION SYSTEM



SMK Restaurant is one of Indonesia famous vocational restaurant located in Malang, East Java. As the school growth, the Headmaster thinks it is the time to use Information System to support their business process for transaction process. After hiring famous consultant to analyze and design the system, it is the time to develop the system. Based on the system design given to you, you’re required to develop Information system to support the business process of transaction for SMK Restaurant. Ensure your developed solutions can accommodate SMK Restaurant business process properly, following the instruction on the project!



Soal LKS SMK XXVI Tahun 2018



Hal 15 dari 27



Module 1: Database Creation and Main Form Development 1. Create the Database Create a database using your MS SQL Server on the local database server following the ERD and Data Dictionary given to you. 2. Insert the Data Insert the master data given to you on file “master-data.xlsx” to the related table on your newly created database. 3. Create Application Create an application using your preferred platform (C# or Visual Basic .NET). 4. Create “01 Login Form” Create the main menu of the application as outlined in “01 Login Form” in the wireframe. 



Ensure all field must be filled.







Ensure Email and password must be existed in database



5. Create “02 Admin Navigation Form” Create the main menu of the application as outlined in “02 Admin Navigation Form” in the wireframe. 



Ensure this form just can be accessed by Admin



Soal LKS SMK XXVI Tahun 2018



Hal 16 dari 27



6. Create “03 Chef Navigation Form” Create the main menu of the application as outlined in “03 Chef Navigation Form” in the wireframe. 



Ensure this form just can be accessed by Chef



7. Create “04 Cashier Navigation Form” Create the main menu of the application as outlined in “04 Cashier Navigation Form” in the wireframe. 



Ensure this form just can be accessed by Cashier



8. Create “08 Change Password Form” Create the main menu of the application as outlined in “08 Change Password Form” in the wireframe. 



Ensure old password input correctly







Ensure confirm password must be same with new password







Store password with SHA512 algorithm







Ensure new password must contains uppercase, lowercase and number.



Soal LKS SMK XXVI Tahun 2018



Hal 17 dari 27



Module 2: Master Form Development 1. Create “05 Manage Employee Form” Create the main menu of the application as outlined in “05 Manage Employee Form” in the wireframe. 



Ensure display all Employee data stored inside the database







Ensure all data are filled before adding or updating the data







Generate Id







The Add New, Edit Data, and Delete Data button are functioned correctly







As for Save and Cancel button, it only enabled when the user choose to Edit the Data, and should be on the proper state, if the user are editing the data cancel button should cancel the edited data



2. Create “06 Manage Menu Form” Create the main menu of the application as outlined in “06 Manage Menu Form” in the wireframe. 



Ensure the form can display all Menu data stored inside the database







Ensure all data are filled before adding or updating the data







The Add Data, Edit Data, and Delete Data button are functioned correctly







As for Save and Cancel button, it only enabled when the user chooses to Edit the Data, and should be on the proper state, if the user are editing the data cancel button should cancel the edited data



Soal LKS SMK XXVI Tahun 2018



Hal 18 dari 27



3. Create “07 Manage Member Form” Create the main menu of the application as outlined in “07 Manage Member Form” in the wireframe. 



Ensure the form can list all Member data stored inside the database







Ensure all data are filled before adding or updating the data







The Add Data, Edit Data, and Delete Data button are functioned correctly







As for Save and Cancel button, it only enabled when the user chooses to Edit the Data, and should be on the proper state, if the user is editing the data cancel button should cancel the edited data.



Soal LKS SMK XXVI Tahun 2018



Hal 19 dari 27



Module 3: Transaction Form Development 1. Create “09 Order Form” Create the main menu of the application as outlined in “09 Order Form” in the wireframe. 



Ensure all menu display in this form.







Ensure user can add and remove selected menu.







Generate Id with format {year:4 digit}{month:2 digit}{date: 2 digit}{number:4 digit}



2. Create “10 View Order Form” Create the main menu of the application as outlined in “10 View Order Form” in the wireframe. 



Ensure the form can list all order that not paid yet







Status can be filled with preparation, cooking, delivered







The default status for new order is preparation







Ensure chef can change status every menu



3. Create “11 Payment Form” Create the main menu of the application as outlined in “11 Payment Form” in the wireframe. Requirements for order tab: 



Ensure the form can list all order that not paid yet







Payment type consists of “cash” and “credit”







If “cash” method is selected for payment, ask user to input amount of money, and show amount of change after save.



Soal LKS SMK XXVI Tahun 2018



Hal 20 dari 27







Ensure all data inputted correctly before saving the data.



Requirements for overview tab: 



Show menu which have not delivered order and the total quantity







When user click menu, show order detail and allow user to change status directly on the form







When status change to “delivered”, menu and order detail will disappear from form



4. Create “12 Report Form” Create the main menu of the application as outlined in “12 Report Form” in the wireframe.



Soal LKS SMK XXVI Tahun 2018



Hal 21 dari 27



Module 4: Database Development



SMK Restaurant is going to continue the development of their Information System to support another business process of the Restaurant. This new feature is used to give more information to people about food in this restaurant. Every guest can give their review and rating about food that they ordered. In this feature, people also can upload their picture about their ordered food. Every user can see menu picture, rating and review that made by user before. Another thing to analyze, SMK Restaurant want to make party package that consist of some menu that already existed. For example, silver package consist of 2 meat menu and 2 vegetables menu. gold package is consist of 2 meat menu and 3 vegetables. Diamond package is consist of 3 meat menu and 3 vegetables. Every package have different price and have minimum order of 100 portions. As an analyst, you are asked for create table and give example data minimum 5 data per table in SQL Server 2014, and data dictionary to support all system that needed in SMK Restaurant Review.



Soal LKS SMK XXVI Tahun 2018



Hal 22 dari 27



Module 5: Application Development 1. Create “Booking Menu” application at Android Studio as new project 2. Make sure your application is based on this wireframe



Soal LKS SMK XXVI Tahun 2018



Hal 23 dari 27



3. Create list of menu that available at restaurant from the provided data. ● ● ●



User can click the menu item and the application will display the detail page of menu. Each item menu contains photo, name, price, carbohydrate and protein info. There is cart button at right-top application layout, if user click the cart icon, application will display the list of menu in cart.



Soal LKS SMK XXVI Tahun 2018



Hal 24 dari 27



4. The detail page of menu that display details info of menu. ● ● ●



There is “Add to Cart” button which can be used for user to add a menu into cart. Detail page contains photo, name, price, carbohydrate and protein info. There is cart button at right-top application layout, if user click the cart icon, application will display the list of menu in cart.



Soal LKS SMK XXVI Tahun 2018



Hal 25 dari 27



5. Create cart page that contains the menu that has already booked by user ● ● ● ●



User can edit the quantity of menu User can delete item menu from cart from delete button at right-top item layout Application can calculate the total price of all the menu in cart list When “checkout” button is clicked, application will display popup dialog that contains



●



share by email and share by sms The content of email or sms is the price total and list of menu that has been booked by user at cart list



Soal LKS SMK XXVI Tahun 2018



Hal 26 dari 27



Soal LKS SMK XXVI Tahun 2018



Hal 27 dari 27