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 1 year ago

Create a table ‘StudentInfo’ with following fields: ID First Name Last Name SSN Date of Birth...

Create a table ‘StudentInfo’ with following fields: ID First Name Last Name SSN Date of Birth Create a table ‘ClassInfo’ table: ID Class Name Class Description Create a table ‘RegisteredClasses’ table: StudentID ClassID The RegisteredClasses table should have a foreign key relationship to StudentInfo and ClassInfo tables for the respective IDs. Also the IDs in StudentInfo and ClassInfo need to be primary keys. When you submit the file your email should also contain the following SQL Queries: Query to show...

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...

) Write queries for the following. Include screenshots of the queries and the outputs. Create a...

) Write queries for the following. Include screenshots of the queries and the outputs. Create a procedure named DisplayInfo which takes customer name as a parameter and displays information of that customer. (database – sql_store)

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...

write program in java Create a class named PersonalDetails with the fields name and address. The...

write program in java Create a class named PersonalDetails with the fields name and address. The class should have a parameterized constructor and get method for each field.  Create a class named Student with the fields ID, PersonalDetails object, major and GPA. The class should have a parameterized constructor and get method for each field. Create an application/class named StudentApp that declare Student object. Prompts (GUI input) the user for student details including ID, name, address, major and GPA....

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,...

Question