
drop database if exists sskulrat_college;
create database sskulrat_college;

use sskulrat_college;

create table student ( 
	Student_ID int not null auto_increment primary key, 
	First_Name varchar(25) not null, 
	Middle_Name varchar(2), 
	Last_Name varchar(25) not null, 
	BirthDate date, 
	OnProbation int);

create table home_address ( 
	Student_ID int not null references student(Student_ID), 
	Street varchar(100), 
	City varchar(25), 
	State varchar(25), 
	Country varchar(25), 
	PostCode varchar(10)); 

insert into student values (12345678, 'Adam', 'A', 'Ant', '1990-07-12', 0),
                           (34566789, 'Bill', '$', 'Gates', '1955-10-28', 1),
			   (87654321, 'Christopher', 'MB', 'Computer', '1945-11-07', 0);
			   
insert into home_address values (12345678, '100 West Elm', 'St. Peter', 'Minnesota', 'USA', '56082'),
				(34566789, 'One Microsoft Way', 'Redmond', 'Washington', 'USA', '98052'),
				(87654321, '1108 South Fourth Street', 'Thief River Falls', 'Minnesota', 'USA', '56701');
