Database Design and Implementation: Wholesale Management System

This assignment details the design and implementation of a database for a wholesale management system. It begins with a scenario analysis of Premium Furnitures, a furniture company, outlining its operational needs and database requirements. The project then moves into conceptual database design, including the definition of enterprise rules and the creation of an Entity Relationship Diagram (ERD). The logical database design is presented, detailing table structures and key fields. The core of the assignment involves creating tables in an Oracle database using SQL, including defining primary and foreign keys. Useful indexes are created to optimize query performance. Sample data is populated into the tables, followed by the creation and execution of various SQL queries to extract information such as furniture details, employee information, and financial data, demonstrating the practical application of SQL for data manipulation and retrieval. The assignment concludes by summarizing the work done to create the database and the data manipulation techniques applied to the tables.