SQL Mystery Challenge: The Case of the Vanishing Artifacts

Project Overview

A renowned museum, Heritage Haven, has reported the mysterious disappearance of several valuable artifacts from its exhibits. The museum’s management has provided access to their comprehensive database, which includes information about artifacts, exhibits, staff, visitors, security logs, and inventory records. Your mission is to analyze the data to uncover the culprit behind the vanishing artifacts and understand how the thefts occurred.

---

Objective

• Identify the thief responsible for the vanishing artifacts.
• Determine the method and timeline of the thefts.
• Provide insights into how to prevent future incidents.

Tasks

Complete the below tasks using the SQL query editor at the bottom.

1. List all artifacts currently missing from the museum.
   • Query Tip: Compare the inventory actions to determine missing artifacts.
2. Identify staff members with access to the Vault during the time artifacts went missing.
   • Query Tip: Analyze security_logs around the dates of theft.
3. Find patterns in artifact removal from the inventory logs.
   • Query Tip: Look for recurring actions or staff involved in removal.
4. Determine which exhibit had the most activity during the theft period.
   • Query Tip: Use timestamps to correlate exhibit access.
5. Cross-reference visitor activities with staff access logs to find potential suspects.
   • Query Tip: Identify visitors who had access to restricted areas or interacted with suspicious staff.
6. Predict the next likely target based on current patterns.
   • Query Tip: Analyze trends in artifact value and exhibit security.