100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
INF3703 WATER-REFILLING- SYSTEM. $3.00
Add to cart

Exam (elaborations)

INF3703 WATER-REFILLING- SYSTEM.

 5 views  0 purchase
  • Course
  • Institution

INF3703 WATER-REFILLING- SYSTEM. 1 AQUA WATER REFILLING MANAGEMENT SYSTEM A Database Design In Database Management System 1 Presented to the Faculty of CHMSC ITE Department In Partial Fulfillment Of the Requirements for the Bachelor of Science in information Technology 1 GLADYS T. ELIVER ...

[Show more]

Preview 4 out of 35  pages

  • October 29, 2022
  • 35
  • 2022/2023
  • Exam (elaborations)
  • Questions & answers
avatar-seller
INF3703 WATER-REFILLING-
SYSTEM.

,AQUA WATER REFILLING MANAGEMENT SYSTEM




A Database Design

In Database Management System 1

Presented to the Faculty of CHMSC ITE Department




In Partial Fulfillment

Of the Requirements for the

Bachelor of Science in information Technology 1




GLADYS T. ELIVER




March 2019




1

, TABLE OF CONTENTS

Title Page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .i

Table of contents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .ii

System Description . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1

Entity Relationship Diagram .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2

Database Dictionaries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . .3-5

Select Statements using Different Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . .6-11

Select Statements using Sub Query . . . . .. . . . . . . . .. . . . . . . . . . . . . . . . . . . . . 12

Select Statements using Count and Group Functions . . . . . . . . . . . . . . . . . . . . . 13

Select Statements using Different Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14-16

Insert Statement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . 17-21

Update Statement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .22-26

Delete Statement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .27-28

Sample Records. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .29-31




2

, SYSTEM DESCRIPTION

One of the fastest and expanding businesses today is water refilling station. Water
refilling station is small water system that has its own water purification facility producing a
portable drinking water. The aqua water refilling system has their own water tank and
equipment that intend on their business.

So, we design a system in this kind of business in order to be on top and align on the
fast-growing business that is demand now a day.

The purpose of water refilling management system is to overcome difficulties in manual
operation in refilling station. The difficulty in manual system are one of the reasons why the
efficiency in availing services of the clients is not satisfying and keeping of records is often
misplaced and not secure.

This system will be programmed to java that can enable the user to record things that
are being purchased by the clients and it be created using MySQL database.

This system manages to display the data to be filled by the user according to the
information of the customer in organize manner, such that their personal details, and the
services they want to avail as well as the payment on the transaction they purchased. The
system keeps the information of the customer and the details of what they purchased.

The system coordinates the arrangement on delivery of products. It consists all the
records for the location of the clients, date of transaction, schedule of delivery, contact number
and the person assign to deliver and the payment of customer to the quantity of product that
about to deliver.

The system also views the information about the availability of the products as well as
the containers. The system views the available containers to provide stocks again.

This system also manages the information of the employees that a refilling station must
have just like front liner, cashier, technical assistant, and delivery an. It stores the information in
organize so that it easy to the owner to access on the detail of his/her employee.

Upon having this system, it will provide the capacity to the owner and clients to transact
without spending time and effort.

Basic features:

• Manage user (add, list updates)
• Delivery (confirm, cancel)
• Products (add, delete, update).



3

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller Excellentstudyresources001. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $3.00. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

52355 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$3.00
  • (0)
Add to cart
Added