Periodic Table Lookup

This Bash script retrieves information about elements from a PostgreSQL database. The user can input an atomic number, element name, or symbol, and the script will return details such as atomic mass, type, melting point, and boiling point.

Features

• Input Options: Search by atomic number, name, or symbol.
• Detailed Element Info: Returns atomic mass, type, melting point, and boiling point.
• Error Handling: Displays errors for invalid inputs or missing elements.

---

Number Guessing Game

This project is a command-line number guessing game implemented in Bash, with PostgreSQL used to store player information and game statistics. Players guess a random number between 1 and 1000, and their game history is saved to the database, including the number of games played and their best result.

Features

• User Management:

  • New users are welcomed, and their information is saved in the database.
  • Returning users are greeted with their game history, including the number of games played and their best score (fewest guesses).

• Game Play:

  • The game generates a random number between 1 and 1000.
  • Players continue guessing until they guess the correct number.
  • Feedback is provided after each guess, indicating whether the guess was too high or too low.

• Database Interaction:

  • Player data (username, games played, best game) is stored in a PostgreSQL database.
  • The game updates the number of games played and the best game (if the current game was completed with fewer guesses than the previous best).

---

Salon Appointment Scheduler

This project is a command-line appointment scheduler for a salon, built using Bash and PostgreSQL. The script allows users to book services, save customer information, and schedule appointments. It interacts with a PostgreSQL database that stores details about customers, services, and appointments.

Features

• Service Selection: Users can select from a list of available salon services.
• Customer Management: If the customer is new, their information (name and phone number) is saved in the database. Returning customers are recognized based on their phone number.
• Appointment Scheduling: After selecting a service, the customer can specify a preferred time for the appointment.
• Error Handling: If a user selects an invalid service or provides incorrect information, the script prompts them to try again.

---

World Cup Database Analysis

This project involves querying a PostgreSQL database with historical data from World Cup tournaments. It includes Bash scripts that handle data import from CSV files and execute queries to retrieve statistics, such as the number of goals, teams, and match results.

Features

• Data Import: The script reads data from a CSV file (games.csv) and populates the teams and games tables in the PostgreSQL database.
• Data Queries:
  • Total goals scored by winning teams.
  • Total goals scored by both teams in all games.
  • Average goals per game (for both winning teams and overall).
  • Most goals scored by a team in a single game.
  • Winner of the 2018 tournament.
  • Teams that participated in the 2014 Eighth-Final.
  • List of unique teams that won at least one game.
  • Year and team name of all World Cup champions.
  • Teams whose names start with "Co".

---

Universe Database

This project is a PostgreSQL database that contains detailed information about the universe, including galaxies, stars, planets, moons, and asteroids. The database structure allows you to store and retrieve data related to various celestial bodies and their properties, such as their distance from Earth, age, type, and other characteristics.

Features

• Galaxy Data: Information about galaxies, including their type, distance from Earth, and whether they support life.
• Star Data: Details about stars, including their type, age, and whether they are spherical.
• Planet Data: Data about planets, including their type, whether they support life, and their associated stars.
• Moon Data: Information about moons, including their age, shape, and the planets they orbit.
• Asteroid Data: Includes asteroids' names, distance from Earth, and whether they are spherical.
• Relational Structure:
  • Moons are linked to planets via foreign keys.
  • Planets are linked to stars, and stars are linked to galaxies, allowing for a hierarchical structure of the universe.

Usage

1. Setup the Database:
   • Use the provided SQL dump to set up the universe database. You can run the following command to import the data:

     psql --username=freecodecamp --dbname=universe < universe.sql

---