Automobile Dealership DBMS

Automobile Dealership DBMS

Streamline Your Automobile Dealership - Get Your Cars On The Road Faster!
Documentation »

About The Project

A Database Management System using SQL for an Automobile Dealership. Keeps track of active inventory, customers, repairs, work orders, and much more. Ideal for a small sized dealership - simple & lightweight.

Built With

Built with C, using SQLite3 database.

Database Design (ERD)

Useful links: ERD Documentation, Schema Documentation.

Features

• Fully manipulatable using built-in CRUD functions.
• Serverless.
• Complete Error Handling.
• 12 built-in queries, with the ability to run any custom SQL query.
• Uses Dynamic Memory Allocation.
• Streamlined compilation using Shell.
• Documentation

Setup

Here's how to setup this database for personal use.

Prerequisites

You need to setup C and SQLite3 library for C. Use the following commands to configure both:

• C

  sudo apt install GCC

• SQLite3

  sudo apt-get install libsqlite3-dev 
  

Installation & Usage

Use gcc --version and sqlite3 --version to verify that both C and SQLite3 are setup properly.

1. Clone this repository:

   git clone https://github.com/Afrokk/Automobile-Dealership-DBMS

The repository already comes with a blank database AutomobileDatabase.db which you can use as a foundation.

2. Compile/Build the program by running this command in the root directory of the clone:

   make

3. Run the Automobile Dealership DBMS by running this command:

   ./RunDBMS

4. For more help, read the usage documentation and query documentation.

Note: If you would like to change the name of the default database file (AutomobileDatabase.db), you can do so. However, don't forget to change the name of the database file in AutomobileDealershipDBMS.c file too, or the database will fail to load or load the wrong database file.

e.g. Change the line#20 in AutomobileDealershipDBMS.c file from:

  *ErrMsg = (int)sqlite3_open_v2("AutomobileDatabase.db", &db, SQLITE_OPEN_READWRITE, NULL) * sizeof(int);

To:

  *ErrMsg = (int)sqlite3_open_v2("YourFileName.db", &db, SQLITE_OPEN_READWRITE, NULL) * sizeof(int);

Design

The program runs via the console:

The user can navigate using the menu.

To-Do

Some of the things I'd like to do with this project, as I work on it:

• Setup database schema and ERD.
• Setup SQLite.
• Add Basic CRUD Functions.
• Add Custom Queries.
• Optimize. - PROJECT COMPLETED.

Contact

Afrasiyab (Afrokk) Khan - @afrokk_ - afrokk.design - afrokk.dev - LinkedIn - [email protected]

Project Link: https://github.com/Afrokk/Automobile-Dealership-DBMS