Lab 2 Structured Query Language.

Student Firstname Lastname Student Number Date of birth

Address Street City State Zipcode County Country

Grades Module Attempt (1,2,3 etc..) DateExam DateEntered GradeAchieved

Description:

A student has one address.

A student can have many grades for different modules.

Requirements:

1. Create three database tables for students, addresses and grades

You must use the fields described above.

The relationships should be defined using primary and foreign keys. (30%)

2. Create the SQL INSERT statements for the following:

Create 5 students records.

An address should be stored for each student.

Each student should have 5 grades for different modules.

The data provided below should be used to populate the database tables. (45%)

Queries:

1. List all students with a surname of Bassett. (5%)
2. List all Grade entries that achieved a pass grade or better for database systems. (5%)
3. List the address for student Susanna Dundendale (5%)
4. What City is Kristofor Phebey from? (5%)
5. List all grade details for Thelma O'Audenis. (5%)

Submission Details:

1. Create a word document with a filename in the following format:

StudentNumber_StudentName_Lab2.pdf

2. You must include all your SQL used to create the tables and query the database.
3. A screenshot of the query results must be included in the document.

Note: The screenshot must be readable.

Student Details

Name: Kristofor Phebey

Student Number: DIT563366

Date of Birth: 09/19/1975

Address: 8 Fieldstone Lane, Guarda Nova, Portugal

Name: Barbara-anne Bassett

Student Number: DIT746437

Date of Birth: 03/18/1974

Address: 8432 Graceland Pass, Uto, Japan

Name: Thelma O'Audenis

Student Number: DIT059102

Date of Birth: 07/17/1995

Address: 2670 Morning Center, Gteborg, Sweden

Name: Susanna Dundendale

Student Number: DIT591133

Date of Birth: 12/20/1991

Address: 54018 Green Crossing, Leuburi, Indonesia

Name: Raphael Blomefield

Student Number: DIT344089

Date of Birth: 08/31/1978

Address: 4666 1st Avenue, Ochr, Russia

Student Grades Details:

Student	Module	Attempt	DateExam	GradeAchieved
Kristofor Phebey	Computer Comms & Networking	2	26/06/2015 10:50	67
Kristofor Phebey	Prog Paradigms & Data Struct	1	11/02/2017 20:36	84
Barbara-anne Bassett	Database Systems	1	19/11/2014 13:16	10
Thelma O'Audenis	Database Systems	1	22/10/2015 22:36	81
Thelma O'Audenis	Prog Paradigms & Data Struct	2	21/09/2017 02:06	20
Kristofor Phebey	Computer Technology 2	2	12/04/2016 19:03	96
Barbara-anne Bassett	Computing Fundamentals 2	2	27/01/2017 09:32	11
Barbara-anne Bassett	Prog Paradigms & Data Struct	1	24/08/2014 15:34	53
Barbara-anne Bassett	Computer Technology 2	1	14/08/2017 06:39	17
Susanna Dundendale	Database Systems	2	24/01/2017 11:47	89
Thelma O'Audenis	Computing Fundamentals 2	2	15/09/2016 14:04	35
Thelma O'Audenis	Computer Technology 2	1	06/12/2015 22:12	81
Thelma O'Audenis	Object Oriented Programming	2	23/07/2014 14:04	62
Susanna Dundendale	Computing Fundamentals 2	1	07/01/2015 15:26	65
Kristofor Phebey	Computing Fundamentals 2	2	06/07/2016 07:10	74
Raphael Blomefield	Computing Fundamentals 2	1	18/10/2014 04:38	14
Susanna Dundendale	Prog Paradigms & Data Struct	2	03/10/2015 21:17	70
Susanna Dundendale	Computing Fundamentals 2	1	30/04/2015 22:12	77
Susanna Dundendale	Prog Paradigms & Data Struct	2	25/09/2014 10:54	32
Raphael Blomefield	Computing Fundamentals 2	2	03/12/2017 00:55	56
Kristofor Phebey	Object Oriented Programming	2	14/04/2014 05:38	62
Barbara-anne Bassett	Object Oriented Programming	1	03/06/2017 03:00	10
Raphael Blomefield	Computer Technology 2	1	10/02/2016 22:47	6
Raphael Blomefield	Computing Fundamentals 2	1	10/09/2015 12:42	75
Raphael Blomefield	Computer Technology 2	1	26/07/2016 10:23	88