Querry must be correct.
Refer the attach tables.
Extracted text: • Direction: Query Statements LAB REPORT 2 (NORMALIZATION) LAB ACTIVITIES Create three table under a database "LABREPORT2", TABLES MUST CONTAIN THE BELOW RECORDS. Students Table ID. Student John Smath Jane Bleggs John Smith Participants Tahle Activity Tenni Swmng Squarh Swenmng Tenns -ID+ 084 084 084 100 182 Mark Artony 219 100 182 219 Gof Swmmng Squaih 219 219 Activities Tae Activity Cost $47 Golf Salrg $50 $40 Sqath Swimming $15 Tennis $36 Create a QUERY TABLE to display the following result. INSTRUCTIONS: 1. Create Foreign key and primary key for each of the tables 2. List all details of id 084 3. List all students taking swimming 4. List all activities costing more than $30 6. List all activities of Jane Bloggs
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here