(Solved) : Lab 2 Structured Query Language Student Firstname Lastname Student Number Date Birth Addre Q35003241 . . . .

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 andgrades

You must use the fields describedabove.

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

2. Create the SQL INSERT statements for the following:

Create 5 students records.

An address should be stored for eachstudent.

Each student should have 5 grades fordifferent modules.

The data provided below should be usedto 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
   OR

    

   PayPal Gateway not configured

   OR

    

   PayPal Gateway not configured