A SQL Server database that is meant to be like Steam (the gaming program). The goal was to build a large scale database with multiple tables and design the database on paper. This is the resulting database. This includes tables for the following...
- Game User
- Game Category
- Purchase Order
- Vendor
- Games
- DLC
- Promotion
- Achievements
- Community
- News
- Payment Info
- Confirmation
- Denial
- Chat Room
- Talk Message
- Technician
- Ticket
- Belong to Community
- Promote
- Participate in Chatroom
- Resposible for Ticket
- Achieve
- Game Resides In
- DLC Resides In
These are the tables used in this database. They handle the fictional company data. Steam's database could have a similar design and layout of tables.