Skylar

Skylar is web-base application for programming practice designed to help with coding assessments and interviews. Skylar focuses on SQL queries and databases. The program starts with a preloaded database with randomly generated data but can be added to by the user.

Getting Started

To get started with Skylar, follow these steps:

1. Clone the Repository:

   git clone https://github.com/AuricFox/Skylar.git
   

2. Navigate to the Project Directory:

   cd Skylar
   

3. Setup Environment:

   pip install virtualenv  
   virtualenv env
   
   .\env\Scripts\activate      # Windows
   source env/bin/activate     # Mac OS
   

4. Install Dependencies:

   (env) pip install flask tabulate python-dotenv
   

5. Run Server:

   (env) python app.py
   

   The server will start running, and you can access the application by navigating to http://localhost:5000 in your web browser.

Database Schema

Below is the default schema of the database used for Skylar:

Customer

cid	cname	address	city	state

• PK: cid

ContactInfo

cid	type	value

• PK: cid, type, value
• FK: ContactInfo.cid TO Customer.cid
• type examples: cell, home, email

Restaurant

rid	rname	city	state	rating	ownerID

• PK: rid
• FK: Restaurant.ownerID TO Owner.oid

Reservation

cid	rid	date	num_adults	num_child

• PK: cid, rid
• FK: Reservation.cid TO Customer.cid
• FK: Reservation.rid TO Restaurant.rid

Owner

Oid	oname

• PK: Oid

License

This project is licensed under the MIT License - see the LICENSE file for details.