How sonjoy209164/dtabaseproject1907073 works
Project type and purpose
• This is a pure database‐centric project (“Furniture Management System”) built entirely in SQL/PL-SQL.
• It contains scripts to define schema (DDL.sql), load and manipulate data (various DML*.sql), define triggers (tigger.sql), PL/SQL procedures (plsql.sql), and test or prep scripts (labtestprep, lab9.sql, labtestprep).
File structure
• Top‐level artifacts:
• DDL.sql → schema definition (tables, constraints, indexes)
• DMLinsertvalues.sql → initial data load
• DMLSearchupdatedelete.sql → CRUD operation scripts
• DMLjoinandview.sql → join queries and view definitions
• DMLAll.sql → a consolidated DML script
• tigger.sql → trigger definitions for enforcing business rules or auditing
• plsql.sql → stored procedures, functions, packages
• lab9.sql, labtestprep, plsql.sql → test/study scripts
• There is no “frontend” or “backend” code—everything runs inside the RDBMS.
README for additional insights
• Title: “DatabaseProject1907073”
• Subtitle: “Furniture Management System”
• No further architectural notes, so we infer domain entities from the DDL (e.g., Furniture, Customers, Orders, Inventory).