Published on

Cat Stories Management System

Authors
  • avatar
    Name
    Putra Zakaria Muzaki
cat-stories-login

Cat Stories Management System

Cat Stories (originally titled Sistem Manajemen Cat Adopt) is a web-based application developed as an Advanced Database Final Project at Politeknik Negeri Malang. It is designed to assist pet shop owners in efficiently managing the complex tasks of cat adoption, inventory, and transaction recording.

Background & Problem

In the modern era, managing a pet shop involves handling complex data regarding inventory, transactions, and customer information. Many shop owners still rely on manual recording methods, which can be troublesome, confusing, and prone to errors.

This project provides a solution by implementing a comprehensive management system based on Microsoft SQL Server, ensuring that inventory data is always current, accurate, and protected.

System Features

The application implements full CRUD (Create, Read, Update, Delete) functionality supported by database functions, stored procedures, and triggers.

1. Cat Inventory Management

Owners can easily manage cat profiles. The system stores detailed information for every cat, including:

  • ID & Type: Unique identifier and breed type.
  • Details: Name, Photo, and Description.
  • Physical Stats: Age (in months) and Gender (Male/Female).
  • Status & Price: Date of entry, Adoption Cost (Biaya), and Availability Status ('Tersedia'/'Tidak Tersedia').

2. Transaction & Adoption

The system facilitates the adoption process by:

  • Recording transaction details including total cost, payment method, and shipping type.
  • Generating transaction receipts (Nomor Resi).
  • Calculating total adoption costs automatically using database functions.

3. Security & User Management

  • Authentication: A secure login mechanism ensures only authorized users can manage the inventory.
  • Data Integrity: The system protects data from unauthorized updates or deletions.

Database Design

The system is built upon a relational database structure consisting of six primary tables:

  1. Jenis: Categories or breeds of cats.
  2. Kucing: Main inventory table containing cat details.
  3. Pembeli: Data regarding the buyers/adopters.
  4. Jenis Pengiriman: Shipping methods.
  5. Metode Pembayaran: Payment options.
  6. Transaksi & Detail Transaksi: Records of adoption events.
ERD Diagram

Figure: Relational Diagram showing the One-to-Many relationships between entities.

Technical Implementation

The backend logic is robustly handled by SQL Server features:

  • Stored Procedures: Used for adding, updating, and deleting data across all tables (Cats, Buyers, Transactions).
  • Functions: Custom functions are used for searching data and calculating transaction totals.
  • Triggers: Implemented to handle automated actions and ensure data consistency.

The Team

This project was developed by the D-IV Informatics Engineering students at Politeknik Negeri Malang (2023/2024):

  • Achmad Raihan Fahrezi Effendy
  • Putra Zakaria Muzaki
  • Vunky Himawan