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). Task B Complete the tasks below and document your answers in a Word document. Each response must be Harvard referenced and clearly identified by using a heading related to each question. Your submission should be no more than 300 words. Answer the following questions: 1. One of the main threats to Database systems is Loss of Integrity, explain what that means, and how to prevent it? 2. In Database security, what do we mean by loss of Availability? 3. What are Firewalls?how do they benefit web Security? provide definition and a detailed explanation.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
