LinkedIn Profile Database

A PostgreSQL relational database modeling a LinkedIn profile.

Schema

Table	Description
User	Core profile (name, headline, email, location, summary)
Education	Academic background (institution, degree, grades)
Skills	Skills with proficiency levels (Beginner to Expert)
Experience	Work/internship history with descriptions
Projects	Project portfolio with tech stacks
Project_Skills	Junction table linking projects to skills (M:N)

Files

File	Contents
schema.sql	DDL - CREATE TABLE statements, constraints, indexes
seed.sql	DML - realistic sample data for a KIIT student
queries.sql	10 analytical queries - JOINs, aggregates, UNION, transaction demo

Usage

psql -U postgres -d yourdb -f schema.sql
psql -U postgres -d yourdb -f seed.sql
psql -U postgres -d yourdb -f queries.sql

Design Highlights

• UUID primary keys - safe for public-facing IDs
• TIMESTAMPTZ - timezone-aware timestamps
• FK with ON DELETE CASCADE - clean referential integrity
• CHECK constraint - restricts proficiency values
• Unique constraint - (user_id, skill_name) prevents duplicate skills
• Junction table (Project_Skills) - proper M:N relationship
• Transaction demo - atomic INSERT with BEGIN/COMMIT