Computer Science: Database Case Study

BY IN CS - Database, IB Computer Science Comments Off on Computer Science: Database Case Study ,

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 …

Computer Science: MySQL Query Example

BY IN CS - Database, IB Computer Science Comments Off on Computer Science: MySQL Query Example , ,

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 …

Computer Science: DFD (Data Flow Diagram)

BY IN CS - Database, IB Computer Science Comments Off on Computer Science: DFD (Data Flow Diagram) , , ,

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 …

Computer Science Database Project

BY IN CS - Database, IB Computer Science Comments Off on Computer Science Database Project , ,

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 …

Database CRUD Project: Small Retail Book Shop

BY IN CS - Database, IB Computer Science Comments Off on Database CRUD Project: Small Retail Book Shop , ,

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 …

CRUD – PHP + MySQL

BY IN CS - Database Comments Off on CRUD – PHP + MySQL ,

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 …