|
Home
|
Sign up!
|
Projects
|
Seminars
|
Research Notes
|
Today's Lecture
|
About
|
Update Project Form
Course:
Project Topic:
Project Description:
This is going to be a joint project with Prateeti Raj. We will create a MySQL database on "Cricket" and then create a web page as a front end.
The SQL syntax for creating the database is--
mysql>create database cricketplus;
mysql>use database cricketplus;
mysql>create table countries(country_name char(40) not null, uniform_color char(40), cricket_board char(40), famous_playgrounds char(40), world_cups_won integer);
mysql>create table cricket_players(player_id integer not null, player_name char(40), highest_score integer, average integer, no_of_centuries integer, no_of half_centuries integer, bowling_average integer, wickets_taken integer);
mysql>create table country_players(player_id char(40) not null, country_name char(40) not null, name char(40) not null, primary key(player_id, country_name), foreign key (country_name) references countries);
Your Password:
Prof. Ashay Dharwadker