BookShop Management System

Create a MySQL Database

DataBase Name : Management

And Tables :

Books

int id			// Primary Key
string name
string auth
int price
int qty

suppliers

int id				//Primary Key
string name
long int phn
string addr_line1
string addr_line2
string addr_city
string addr_state

purchases

int ord_id			//Primary Key
int book_id		    //FK ref (books)
int sup_id			//FK ref (suppliers)
int qty
date dt_ordered
int eta
char received		// Check(T or C or F) def (F)
int inv

employees

int id				//Primary Key
string name
string addr_line1
string addr_line2
string addr_city
string addr_state
long int phn
date date_of_joining
long int salary
string mgr_status	//check(T or F) def f

members

int id				//Primary Key
string name
string addr_line1
string addr_line2
string addr_city
string addr_state
long int phn
date beg_date
date end_date
string valid

sales

int invoice_id		//Primary key
int member_id		//FK ref member(id)
int book_id		//FK ref books(id)
int qty
int amount
date date_s