🚗 Car Dealership Database Management System - Demo

🌐 Dive into a state-of-the-art database system tailored for car dealerships, streamlining operations and amplifying business insights.

📌 Table of Contents

• 🌟 Overview
• 🛠 Features
• 🤔 How to Use
• ✍ Authors
• 🙏 Acknowledgments

🌟 Overview

https://youtu.be/uYsPCK9h3r0?feature=shared Our dealership solution comes with a plethora of add-on packages alongside a comprehensive inventory of cars for customer perusal. Central to our design are four pivotal tables: Cars, Sales, Owners, and Add-on Packages. The 'Sales' table stands as the linchpin, weaving these tables into a cohesive network.

🛠 Features

1. 🖥 Homepage:

• 🖼 Showcases a ladder-style layout that paints a vivid image of the dealership.
• 🌍 Encompasses a global navigation bar for swift access.
• 📋 Main records are a click away with a user-friendly popover menu.

2. 🚗 Car Models Table:

• 📈 Provides an exhaustive list and details of every car in our inventory.

3. 🧑 Clients Table:

• 📝 Hosts essential data fields: owner ID, name, email, and more.
• 🔽 Simplifies gender input with a drop-down list.
• 💳 Payment method? We've got a popover menu for that!

4. 📦 Add-on Packages:

• 🎨 A vivid display of packages, costs, and their respective features.
• ✅ Flexibility reigns with an easy-to-use system to modify package features.

5. 💰 Sales Records:

• 🤝 Merges car ID, owner ID, and add-on ID for seamless data integration.
• 🧮 Cost calculation gets dynamic; adjust car and package options, and watch the magic!

6. 📘 Car Specs & Owners Layout:

• 🚘 Zoom into car specs and the proud owners.
• 🌎 A global view awaits with an interactive data viewer and map directions for car shows.

7. 📊 Numerical Summaries:

• 🔍 Dive deep with comprehensive summaries: models, customers, and revenue insights.
• 🔡 Efficiently sort and filter data as needed.

8. 🚀 Shortcuts & Automation:

• ⚡ Turbo-charge your tasks with a platform menu.
• 🧠 Smart scripts to save time and boost accuracy.

🤔 How to Use

1️⃣ Jump to the desired table via the global navigation bar.
2️⃣ Utilize drop-down lists, popover menus, and fields for data input.
3️⃣ Harness the power of shortcuts for a breezy database experience.

✍ Authors

• Dhruv Trivedi
• Sharjeel Jafri 🌍

🙏 Acknowledgments

• Course: CS 200
• Instructor: Barbara Daly

💌 A heartfelt thank you to Barbara Daly for her unwavering support and sage advice throughout this journey.

---

📞 For queries or feedback, the authors are just a message away. Reach out! 🤝