Here are the queries:
To create table student with necessary attributes:
CREATE TABLE student(id INT PRIMARY KEY, firstName
VARCHAR2(50), lastName VARCHAR2(50), address VARCHAR2(50), state
VARCHAR2(4), gpa FLOAT, credits INT);
Inserting Values in the Table:
INSERT INTO student values( 1, 'Jessica', 'Jones', '23,
High Street', 'IN', 3.95, 31);
INSERT INTO student values( 2, 'Jessica', 'Jones', 'Ghar ke piche',
'NJ', 3.7, 23);
INSERT INTO student values( 3, 'Jessica', 'Jones', 'Mohalle no
231', 'GH', 3.84, 30);
INSERT INTO student values( 4, 'Jessica', 'Jones', '23, High
Street', 'IN', 2.7, 28);
INSERT INTO student values( 5, 'Vijay', 'Kholiya', 'Tigri
chauraha', 'NJ', 3.69, 31);
INSERT INTO student values( 6, 'Vijay', 'James', '485 W 46th
Street, New York City', 'NY', 1.0, 97);
INSERT INTO student values( 7, 'Rahul', 'James', '485 W 46th
Street, New York City', 'NY', 1.69, 99);
INSERT INTO student values( 8, 'Jessica', 'James', '485 W 46th
Street, New York City', 'NY', 3.7, 66);
INSERT INTO student values( 9, 'Jessica', 'Jones', '485 W 46th
Street, New York City', 'NY', 3.84, 97);
INSERT INTO student values( 10, 'Jessica', 'Jones', '485 W 46th
Street, New York City', 'NY', 3.69, 69);
INSERT INTO student values( 11, 'Shiwani', 'Kholiya', 'Tigri
chauraha', 'NY', 2.7, 89);
INSERT INTO student values( 12, 'Ram', 'Verma', 'Tigri chauraha',
'NJ', 1.69, 82);
INSERT INTO student values( 13, 'Sheetal', 'Verma', 'Kuch Bhi
Daalo', 'DE', 1.0, 78);
INSERT INTO student values( 14, 'Kala', 'Mera', 'Kahen Bhi Chale
Jao', 'NJ', 3.89, 76);
INSERT INTO student values( 15, 'Ladka', 'Kutta', 'Tigri chauraha',
'NJ', 3.7, 28);
INSERT INTO student values( 16, 'Harami', 'beta', '45, Pankhe K
niche', 'DE', 3.69, 37);
INSERT INTO student values( 17, 'Chutiya', 'Ladka', '45, Love
street', 'NJ', 0.6, 43);
INSERT INTO student values( 18, 'Bahut', 'Bada', '23, Gone street',
'DE', 0.92, 49);
INSERT INTO student values( 19, 'Bada', 'Kuita', 'Upar wali gali',
'NJ', 3.92, 98);
INSERT INTO student values( 20, 'Kamina', 'hai', 'Ghar k niche',
'NJ', 3.3, 67);
INSERT INTO student values( 21, 'Kanu', 'Vashisth', '29, Duplec
xity', 'GF', 3.7, 28);
INSERT INTO student values( 22, 'Priya', 'Samant', '34, Parathe
Wali Gali', 'RE', 2.8, 20);
INSERT INTO student values( 23, 'Nicky', 'Singh', '899, No where',
'AU', 2.56, 34);
INSERT INTO student values( 24, 'Shiwani', 'Joshi', '344, Chandni
CHowk', 'GF', 1.75, 88);
INSERT INTO student values( 25, 'Arti', 'Bhandari', '321,
Muzzafarpur', 'YT', 0.7, 68);
Displaying the table's content:
SELECT * FROM student;
Output:
1. (5pts) Populate your "student" table with 20 or more students, such that: At least 4...
Write a C++ program to store and update students' academic records in a binary search tree. Each record (node) in the binary search tree should contain the following information fields: 1) Student name - the key field (string); 2) Credits attempted (integer); 3) Credits earned (integer); 4) Grade point average - GPA (real). All student information is to be read from a text file. Each record in the file represents the grade information on...
1. Create a PL/SQL program block that determines the top students with respect to GPA. Assume that the database has four tables. Student(SSN, SName, DOB, Major) , Grade(SSN, CNo, Grade(0,1,2,3,4)) and Course table(CNo,CName, Credit Hour), Prerequisite(CNo, PreCNo); Student and couse data ae given in the following SQL statements a. Accept a number n as user input with SQL*Plus telling top n%. b. In a loop get the SName and GPA of the top n% people with respect to GPA. c....
Population o El Camino Students (P1- Students who use Instagram more than 7 hours per week, P2- Students who use Instagram less than 7 hours per week) Variable o Time Spent on Instagram per week (7+hours(yes) below 7(no)) GPA (3.0 or higher (yes) or below 3.0(no)) -Boolean Parameter: Proportion "P1, P2" The group MWA in Professor Love's class wants to test using a significance level of 0.05 if students at El Camino Community College who use Instagram for 7 hours...
Must be written in JAVA Code Write a program that will read in a file of student academic credit data and create a list of students on academic warning. The list of students on warning will be written to a file. Each line of the input file will contain the student name (a single String with no spaces), the number of semester hours earned (an integer), the total quality points earned (a double). The following shows part of a typical...
Key Takeaways -To create 2 groups of 4 students (8 students in total) -NEEDS random GPAs for each student -No arrays ------------------------------------- app.java, student.java, and group.java as requested below. Please use the diagram above to help answer the Question: Create a project that: Has a student class Instance variables for Firstname, last name , and age random generated GPA methods to return getinfo and semesterGPA Build upon the solutions of the previous labs (e.g., using app.java and student.java) You will...
3. Suppose my graph theory class has 12 different students, of which 6 are under- grads and 6 are graduate students. (a). How many ways can I choose at least 4 but no more than 8 of my students to take a field trip to the library? (b). I want to repeat part (a), but I want to be sure to take at least 2 undergrads. (c). I have 3 different final projects for them to work on (projects A,...
Create three or more MySQL Data Control language (DCL) Statements using the Youth League Database. 1. A Create new user statement for the database 2. A statement that grants privileges to the new user 3. A statement that revokes privileges 1. A SQL Text File containing the SQL commands to create the database, create the table, and insert the sample test data into the table. 2. A SQL Text File containing the DCL SQL Statements. eted hemas Untitled Limit to...
Define a class called Student with ID (string), name (string), units (int) and gpa (double). Define a constructor with default values to initialize strings to NULL, unit to 0 and gpa to 0.0. Define a copy constructor to initialize class members to those of another Student passed to it as parameters. Overload the assignment operator (=) to assign one Student to another. Define a member function called read() for reading Student data from the user and a function called print()...
In C++ Write a menu driven C++ program to read a file containing information for a list of Students, process the data, then present a menu to the user, and at the end print a final report shown below. You may(should) use the structures you developed for the previous assignment to make it easier to complete this assignment, but it is not required. Required Menu Operations are: Read Students’ data from a file to update the list (refer to sample...
Lesson 6 2.2: 2-Scores and Normal Distributions STUDENT NAME DATE TAKE IT HOME basketball team wants to score more points. To get better at scoring points the while 1 The Westwood Warriors zone defense, w team is trying to improve its offensive strategies. Some opponents primarily use a others primarily use a man-to-man defense. When the Warriors play against teams t defense they hat use a zone score an average of 67 points per game. When they play against teams...