Price $11

Sql Student Database Creation

Question

Create a simple student database creation using SQL

Solution

Title: Sql Student Database Creation
Length: 4 pages (1000 Words)
Style: APA

Preview

Creating Students Table

CREATE TABLE IF NOT EXISTS  ‘Students’ ( ‘student_id’ int(11) NOT NULL AUTO_INCREMENT,

`first_name` varchar(50) NOT NULL, `surname` varchar(50) NOT NULL,`address` varchar(100)

NOT NULL, `start_date` date NOT NULL, `gender` varchar(20) NOT NULL,`birth_date` date NOT

NULL, PRIMARY KEY (`student_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1

AUTO_INCREMENT=1 ;

Creating  Grades Table

CREATE TABLE IF NOT EXISTS 'Grades' ( 'student_id' int(11) NOT NULL, 'course_id' int(11) NOT

NULL, 'grade' varchar(2) NOT NULL, PRIMARY KEY ('student_id','course_id'),CONSTRAINT fk

Foreign KEY(student_id) REFFERENCES Students(student_id));

$11.00

* Once your purchase is processed by paypal you will be redirected back to this page and you'll have the option to download the paper. We'll also send the paper to your paypal email address as proof of purchase.
Download Paper

Order a high quality custom written paper

With a team of proficient and enthusiastic writers, we are able to produce a compelling text on practically any topic.

Plagiarism Free

Excellent Quality

100% MONEYBACK