Create a table with name “S_YOURStudentID” with the following fields with required constraints. Screenshots are to...

Create a table with name “S_YOURStudentID” with the following fields with required constraints. Screenshots are to be attached.

For example, if your botho student id is 1212121, your table name should be “S_1212121”.

Student id
Student Name
Age
Gender
City
Course name
Module Name
Internal mark 1
Internal mark 2
Internal mark 3
Total internal mark

Insert minimum 10 records/rows to the table. Input the data based on Question 5. Screenshots are to be attached.
Create two users and assign different default and temporary table spaces. Screenshots are to be attached for each step.
Create two roles named admin and user. Admin has the full privileges to access the table and user has only the READ privileges to the table. Screenshots are to be attached for each step.
Write a SQL query for the following scenario. Screenshots with queries and outputs are to be attached

Write a Query in SQL to list all the students.
Write a Query in SQL to list all the name of students of six characters long and name starts with ‘A’ and ends with ‘S’
Write a Query in SQL to display all the information of the students together with the Total Internal mark.
Write a Query in SQL to list the students whose gender is ‘male’ and the age is above 25.
Write a Query in SQL to list the students whose total internal mark is greater than 80.

Expert Solution

venereology answered 10 months ago

Create table, create primary and foreign key constraints. Create index on the table to satisfy a...

Create table, create primary and foreign key constraints. Create index on the table to satisfy a query with aggregate functions.

Create a class named Horse that contains the following data fields: name - of type String...

Create a class named Horse that contains the following data fields: name - of type String color - of type String birthYear - of type int Include get and set methods for these fields. Next, create a subclass named RaceHorse, which contains an additional field, races (of type int), that holds the number of races in which the horse has competed and additional methods to get and set the new field. ------------------------------------ DemoHorses.java public class DemoHorses { public static void...

IN C++ Create student structure with the following fields:  Name (cstring or null-terminated character array)...

***IN C++*** Create student structure with the following fields:  Name (cstring or null-terminated character array)  Student ID (int – unique random value between 1000 and 9999)  grade (char – Values A thru F)  birthday (myDate – random value: range 1/1/2000 to 12/31/2005)  Home Town (string) Create an array of pointers to students of size 10. Example: Student *stuPtr[10]; Write a function that populates the array with 10 students. Example: populate(stuPtr); Write a display function that...

Create a struct MenuItem containing fields for name (a string) and price (a float) of a...

Create a struct MenuItem containing fields for name (a string) and price (a float) of a menu item for a diner. Create a ReadItem() function that takes an istream and a MenuItem (both by reference) and prompts the user for the fields of the MenuItem, loading the values into the struct's fields. Create a PrintItem() function that takes an output stream (by reference) and a MenuItem (by value) and prints the MenuItem fields to the stream in a reasonable one-line...

Create a new SQL table in your phpMyAdmin account that collects the following fields (columns) - (10...

Create a new SQL table in your phpMyAdmin account that collects the following fields (columns) - 1) The name of a medicine, sanitizer, or tip/trick for protecting yourself against transmission or fight the disease - STRING 2) The amount of money the item costs - NUMBER 3) The UPC code of the item - NUMBER 4) Manufacturing country of the item - STRING Connect to the SQL database with your HTML code, and make sure to show the results of...

C# (Thank you in advance) Create an Employee class with five fields: first name, last name,...

C# (Thank you in advance) Create an Employee class with five fields: first name, last name, workID, yearStartedWked, and initSalary. It includes constructor(s) and properties to initialize values for all fields. Create an interface, SalaryCalculate, class that includes two functions: first,CalcYearWorked() function, it takes one parameter (currentyear) and calculates the number of year the worker has been working. The second function, CalcCurSalary() function that calculates the current year salary. Create a Worker classes that is derived from Employee and SalaryCalculate...

Create a table with two columns. Name the table First Initial _ Last Name (e.g. John...

Create a table with two columns. Name the table First Initial _ Last Name (e.g. John Dow will create table j_dow). You have to audit all DML statements on your table. To do this you write two triggers: 1. To log any DML statements that users might run on this table. The results must be stored in the First Initial _ Last Name _ Log table (e.g. John Dow will create table j_dow_log). The table should have unique event ID,...

Name the three opportunity constraints.

Create a PHP class named "User" with the following private fields: name, birthdate in yyyy/mm/dd format,...

Create a PHP class named "User" with the following private fields: name, birthdate in yyyy/mm/dd format, age, and department. In the class, include getter and setter methods to get and set the values of those variables. Author a data entry webform using HTML text input boxes and a submit button. When the user clicks on the submit button, a "User" class is instantiated and the new User object's fields are populated. The HTML input boxes correspond to the field in...

In java, create a class named Contacts that has fields for a person’s name, phone number...

In java, create a class named Contacts that has fields for a person’s name, phone number and email address. The class should have a no-arg constructor and a constructor that takes in all fields, appropriate setter and getter methods. Then write a program that creates at least five Contact objects and stores them in an ArrayList. In the program create a method, that will display each object in the ArrayList. Call the method to demonstrate that it works. Include javadoc...

Question