Undergraduate Information Systems Student Specializing in Business Intelligent at BINUS University
・
Indonesia
Project Link : https://drive.google.com/file/d/1KlwDXbbJSyjErENwdGPg8ZjsmD75boJE/view?usp=sharing
In this project, I've created a database named "BlueJacket Database Design" using Microsoft SQL Server. The database focuses on jacket store transactions and includes queries for ERD, creating tables, inserting data, simulating transactions, and addressing 10 specific scenarios. These scenarios involve retrieving information such as staff details, vendor details, and transaction summaries based on various conditions and criteria. The queries cover a range of scenarios, from analyzing sales by gender and month to calculating total purchases and sales for specific periods.