Search our Repository

Order a high quality custom written paper

This revision paper should be used as a source of ideas / reasoning / inspiration for your own research. You should never submit it as your own work. Need something custom and original? Choose from a wide range of academic writing tasks and get the one you need.

Price $11

Pay with paypal

* 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

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

Do you need an affordable high quality custom written 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