Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Microsoft SQL Server 2012 Programming

Authors: Paul Atkinson, Robert Vieira

1st Edition

1118102282, 9781118102282

More Books

Students also viewed these Databases questions

Question

=+ What are the information and consultation requirements?

Answered: 1 week ago