CS – Database

contactwahyu on March 21st, 2015

CitaHati Christian Senior School Formal Assessment, March 2015 Topic: Database   Student’s name: _________________________   Class: ____________   Date: 19th March, 2015 Subject:  ___ Computer Science___                           Level: HL / SL   Time: 1 hour 30 minutes     OTA SYSTEM MANDARA Inc. is one of the biggest OTA (Online Travel Agent) in India. It […]

Continue reading about Computer Science: Database Case Study

contactwahyu on March 18th, 2015

Get all employee details from the employee table Get First_Name,Last_Name from employee table Get First_Name from employee table using alias name “Employee Name” Get First_Name from employee table in upper case Get First_Name from employee table in lower case Get unique DEPARTMENT from employee table Select first 3 characters of FIRST_NAME from EMPLOYEE Get position […]

Continue reading about Computer Science: MySQL Query Example

contactwahyu on March 12th, 2015

A-BEAUTY SPA Corp is a Mobile Spa Company based in Surabaya. It just opened its operation and want to develop a system. Customers can do a reservation to have a service and its staff/therapist will come to customer’s place to do the service. The company has more than 20 therapist and they earned a monthly […]

Continue reading about Computer Science: DFD (Data Flow Diagram)

contactwahyu on February 25th, 2015

A small restaurant called “PaPa Burger” needs to hire programmer to build the system for the restaurant. They need to record all the transaction everyday. The Cash Receipt will be given to their customer with the following layout ************************************ “PaPa Burger Restaurant” Inv No: _______________ Inv Date: ______________ 2pcs Small Burger $4.90 … $9.80 2pcs […]

Continue reading about Computer Science Database Project

contactwahyu on January 21st, 2015

Create simple database project for small retail book shop You need to create the following tables: 1. Customer id_customer, customer_name, address, phone, city 2. Sales id_sales, id_customer, transaction_date, book_name, qty, total Create CRUD function for customers, using your own interface, add at least 5 records into customer table Create an interface for sales, customer need […]

Continue reading about Database CRUD Project: Small Retail Book Shop

contactwahyu on January 7th, 2015

For learning Option Database, we will try to learn to develop a Web Application. For this purpose, we will use PHP for side server script, JavaScript for client side script and MySQL for the database There are lots of PHP IDE, you can even use a notepad++ for the IDE or other software such as Dreamweaver, […]

Continue reading about CRUD – PHP + MySQL