Home
Social Network Status Updates – Database Schema
Here’s a simple database schema which can be used in cases where you want to take user status input. The entities available are users, updates, comments & likes. Additional entities can be added as required. Also, for simple user registration and status updates it will be more than enough. Schema derived by studying popular social […]
Online Shopping System–Database Design
Database design of Online Shopping System. Schema represents minimal information required to store information of a shop and products to sell. Cart information can be stored in session or if wishlist / watchlist is needed, the schema can be simply extended. Enjoy. Entities: users – shop admin, owner and customers products – products to sell […]
Quiz System–Database Schema Design
MySQL Database Schema design for quiz system. Schema Diagram: MySQL Create Script: — phpMyAdmin SQL Dump — version 3.2.0.1 — http://www.phpmyadmin.net — — Host: localhost — Generation Time: Apr 01, 2013 at 08:27 PM — Server version: 5.1.37 — PHP Version: 5.3.0 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION […]
Photo Video Gallery–Database Design
Database design for photo video gallery website / app. Enjoy. Schema Diagram: MySQL Create script: — phpMyAdmin SQL Dump — version 3.2.0.1 — http://www.phpmyadmin.net — — Host: localhost — Generation Time: Apr 03, 2013 at 10:25 PM — Server version: 5.1.37 — PHP Version: 5.3.0 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; […]
Marksheet Generation System–Database Design
Schema for Marksheet Generation System useful for school, colleges and institutes to store student’s information, exam marks etc. Extend at your will. Schema Diagram: MySQL Create Script phpMyAdminDump: — phpMyAdmin SQL Dump — version 3.2.0.1 — http://www.phpmyadmin.net — — Host: localhost — Generation Time: Apr 02, 2013 at 07:28 PM — Server version: 5.1.37 — […]
Simple CMS (Content Management System) – database design
Schema design of simple content management system. Schema and tables itself speak about the type of information indented to be stored by the system. Schema Diagram: MySQL Create Script phpMyAdmin dump: — phpMyAdmin SQL Dump — version 3.2.0.1 — http://www.phpmyadmin.net — — Host: localhost — Generation Time: Mar 30, 2013 at 10:20 PM — Server […]
Online Vehicle Ticketing System Database Design Sample
Online Bus/Vehicle Ticketing System Database Design Sample – MySQL. With minor modifications or further generalization this database schema can be used to implement any kind of ticket booking system. eg. movie ticket booking system, events/show ticket booking etc. Entities: users – user details user_type – type of users in system vendors – providers’ information, in […]
Social Network Database Design Sample – MySQL
what?—— sample database for a social network project – a mysql database schema Database Engine: InnoDB (edit the mwb file if you need to change it to MyISAM or any other.) the aspects of a social network i tried to cover in this database:– user profile – friends– friends list – status updates– thumbs up/down […]