Question
Using various SQL commands that you have learned, perform the following SQL queries: CREATE all tables (dont forget your keys) INSERT all tuples of data
Using various SQL commands that you have learned, perform the following SQL queries: CREATE all tables (dont forget your keys) INSERT all tuples of data After you have created all your tables and data, run SQL statements to perform the following: DELETE one row of data from each table UPDATE one row of data from each table ALTER one table by adding a new attribute Prepare SELECT statement to display: A. The total number of students who have siblings in the school. B. List the names (family name/surname) of all the families that have children enrolled at the school. C. List the names of the families that have more than one child enrolled in the school. D. List the name of the teachers along with the class they teach and arrange them in alphabetical order. E. list the details of a report of a student in year 2. F. List the type of activities/sports students do in a Physical education class. G. List details of staff members who are not teachers. H. which student has the highest grades(best performance) in year 5 in a specific year ( for example the year 2019). I. List the details of all the classes along with the classroom ID/number and the facilities available in each classroom. J. which teacher is specialised in teaching the Art subject and what facilities are available in the Art classroom to help the teacher deliver the subject. K. which classes teach Science and/or technology subjects, list the class name, year level and the subject name (Science, technology or both).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started