🪑 Информационная система мебельного производства: практическое задание

📋 **Information system design is the art of transforming business requirements into a clear structure of data and processes.**
This guide is a structured practical assignment for designing an information system for furniture manufacturing. It will help you approach the analysis of the subject area in a systematic way, design a database in 3NF, and properly describe use cases.

---

📦 **What’s inside the guide (strictly 11 pages in the Nebulae style):**

• **Page 1:** Title page with academic design and abstract visualization in purple and turquoise.
• **Page 2:** Task introduction: description of the subject area, key business processes (from order acceptance to shipment) and 5 roles of system users.
• **Page 3:** Data Dictionary: A table of basic entities (Product, Order, User, Material, Accessories, etc.) with primary keys and relationships.
• **Page 4:** 👤 User data analysis: statistics from the `Users.csv` file, role distribution, and strict password security requirements.
• **Page 5:** 🪵 Material data analysis: statistics from `Materials.xlsx` (240+ items), material types, price ranges, and units of measurement.
• **Page 6:** 🔩 Hardware data analysis: statistics from `Hardware.xlsx` (800+ items), types of fasteners, color palette of plugs, and pricing.
• **Page 7:** ✍️ Task 1: Structure and 5 ready‑made options for a textual description of a use case (Use Case) based on a sample.
• **Page 8:** 🎨 Task 2: Graphical description of a use case. Ready‑made PlantUML syntax, relationship types, and a prompt for AI code generation.
• **Page 9:** ✅ 4 detailed checklists for self‑checking: domain analysis, textual Use Case, graphical Use Case (PlantUML), and compliance with database requirements (3NF).
• **Page 10:** 🎯 Evaluation criteria: transparent score table (max. 100), bonus points for AI and visualization, penalty sanctions.
• **Page 11:** Final, step‑by‑step action plan, and legal block.

---

👤 **Who this guide is for:**
• 🎓 Students of the specialty 09.02.07 “Information Systems and Programming” who are completing coursework or competitive assignments.
• 💼 Beginner system and business analysts who want to practice their skills in gathering requirements and designing databases using a real‑world case.
• 🚀 1C developers who need to quickly structure a technical specification before starting configuration.

---

✓ **What you will get:**
• **Clear structure:** A step‑by‑step plan for completing the task, from data analysis to final verification.
• **Ready‑made templates:** The structure of a textual Use Case and basic PlantUML code, which you just need to adapt to your own version.
• **In‑depth data analysis:** Already conducted statistics for CSV and XLSX files, saving you hours of work on studying raw data.
• **Control tools:**4 checklists that guarantee you won’t miss a single requirement of the task (from 3NF to alternative flows).
• **Aesthetics and usability:** a PDF designed in a strict academic minimalist style (Nebulae theme), which is pleasant to read and convenient to use as a reference guide.

---

⚙️ **Technical details:**
• **Format:** PDF (strictly 11 pages, academic minimalist style, plenty of space).
• **Design:** Nebulae theme. Primary: #6C4CF1, accent: #14B8A6, background: #F8F5FF, text: #2D1B4E. Fonts: Unbounded (headings), Inter (text).
• **Language:** Russian.
• **Delivery:** Instant auto‑delivery of the `.rar` archive to the email and to the personal account (PLATI.RU) / Link in the chat or to the email immediately after payment (Yandex Business).
• **Compatibility: Opens on any device (PC, smartphone, tablet).

⚖️ **INTELLECTUAL PROPERTY:**
All materials in the guide (structure, data analysis, Use Case templates, checklists, evaluation criteria) are the original copyrighted work of Keeperlink, 2026. The guide was created based on a training competition task for designing an information system for furniture production. All data (data dictionary, ER diagram, CSV/XLSX files) were provided and adapted as part of the training task. The mention of PlantUML and AI tools is purely nominal in nature and is intended to describe compatibility; it does not imply affiliation with the rights holders (Article 1484 of the Civil Code of the Russian Federation). © Keeperlink, 2026. All rights reserved.

---

🚀 **Start by analyzing the data — open the CSV/XLSX files and find the patterns. This is the key to successful design!** Click “Buy” to get a structured practical guide and complete the task for the maximum score.