create a new table that contains the list of all the students and class_descriptions. Include In...
create a new table that contains the list of all the students and class_descriptions. Include In this table the list of all students who are not enrolled in any classes (display no classes). If there are no class descriptions then display ‘no description’ (Use combination of inner join, union and minus) (Note: minus will deal with the students who are not enrolled in any classes)
create new_table as (SELECT fname, lname, NVL(class_description, 'No Description') AS "Class Description" FROM STUDENT st, CLASS cl, STUDENT_CLASS sc WHERE st.ssn = sc.ssn AND sc.class_code = cl.class_code)
UNION
(SELECT ssn FROM STUDENT MINUS SELECT ssn FROM STUDENT_CLASS);
Homework Answers
Request Answer!
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Add Answer to:
create a new table that contains the list of all the students
and class_descriptions. Include In...
Use only a single SQL statement for each of the following questions 1 Give a listing of all the ssns,first names and the class descriptions of all the classes the students are taking. If there a...
Use only a single SQL statement for each of the following questions 1 Give a listing of all the ssns,first names and the class descriptions of all the classes the students are taking. If there are no class _descriptions display 'No description is available yet'. (USE NVL) 2 Give a listing of only the lname and the class_code for students who are taking 'Introduction to C programming'. (Inner join) 3 Give a lising of all the class_descriptions and the number...
a) Create a Table called Students b) Develop a Form with the following fields FName, LName,...
a) Create a Table called Students b) Develop a Form with the following fields FName, LName, Test1, Test2, Test3,State c)Using the Form fill the Table with the following data FName LName Test Test 2 Test 3 State Bob Smith 79 81 86 NY Thorpe 82 Griffey 100 Colon Jim 64 91 Conn Ohio Ken 95 92 85 Bartolo 88 93 Ohio Cal Ken Keltner 91 84 87 Lou Staub 76 89 42 Mich PROBLEM: Find and print the LName of...
Create a Student Planner app that will allow students to keep track of homework due dates...
Create a Student Planner app that will allow students to keep track of homework due dates for the classes they are currently taking. The first app activity (screen) will display the list of classes the student has entered. There should also be a way for students to add, edit, and remove classes from the list. When students select a class they should be taken to a second activity (screen) which will display the assignment name and due date (at minimum,...
Can someone please help me solve the following database management question a - d please help...
Can someone please help me solve the following database management
question a - d please help
uestion-4 The relational database schema of Question-3 is reproduced here. COURSE (NUMBER, TITLE, ENROLLED) RANK-1 (CNUMBER, R1-SSN) RANK-2 (CNUMBER, R2-SSN) TALLEST (CNUMBER, TALL-SSN) STUDENT (SSN, NAME, MAJOR, SEX, GPA) Formulate the following queries in soL. (30] (a) List the course numbers in which "Jack Hernandez" is the first ranked student. You are not allowed to use any JOIN operation and your answer must be...
At the start of each year, a list of subjects a college plans to offer is produced for students. Every semester, students at the college check the subjects available, enroll in subjects offered and re...
At the start of each year, a list of subjects a college plans to offer is produced for students. Every semester, students at the college check the subjects available, enroll in subjects offered and register for a class in each subject they enroll in. Students get an enrolment confirmation after they have enrolled for their subjects. The schedule of classes available for each subject is supplied by the teacher who coordinates the subject and the class schedule is created by...
You are working on an assignment for your statistics class. You need to E Select one...
You are working on an assignment for your statistics class. You need to E Select one answer. estimate the proportion of students at your college who delay taking their first 10 points math class for at least one year. Which sampling plan will produce the most reliable results? A. Obtain a list of all students enrolled at the college. Randomly select 100 students from the list. B. O Work with the math instructors to create a list of students currently...
Consider the following table definitions: create table node (node_id integer primary key, node_color varchar(10)); create table...
Consider the following table definitions: create table node (node_id integer primary key, node_color varchar(10)); create table edge (edge_id integer primary key, origin_id integer, destination_id integer, foreign key (origin_id) references node (node_id), foreign key (destination_id) references node (node_id) ); Which of the following list the ids of nodes that link to both the node with id 3 and and the node with id 4? select node id from node inner join edge on node_id=origin_id where destination_id=3 and destination_id=4; select node_id from...
For Problem 4, Problem 5 use the tables provided below. Assume that the table may change...
For Problem 4, Problem 5 use the tables provided below. Assume that the table may change in the future. Problems 4 and 5 do NOT have the same solution. Table = Courses StudentID Fname Lname CourseID 11 Minnie Mouse 21 13 Mickey Mouse 16 15 Donald Duck 18 14 Daisy Duck 21 16 Huey Duck 18 12 Dewey Duck 24 12 Dewey Duck 21 18 Louie Duck 27 11 Minnie Mouse 24 Problem 4 (15 points): Write a relational algebra...
9 We want to find out the courses that each student is not enrolled in. Give a listing of the course descriptions, and the students (lname) who are not taking that specific course (Use a cartesi...
9 We want to find out the courses that each student is not enrolled in. Give a listing of the course descriptions, and the students (lname) who are not taking that specific course (Use a cartesian product and union it with a minus) drop table student_class; drop table student; drop table class; create table student ( ssn char(11) not null, lname varchar(40) not null, fname varchar(20) not null, phone char(12), address varchar(40), city varchar(20), state char(2), zip char(5), dob date,...
Please complete in pseudocode. No language. Create the pseudocode design to include at least the following...
Please complete in pseudocode. No language. Create the pseudocode design to include at least the following modules. Enter the ClassTitle into an array named Classes and NumberofSeats into an array named ClassSeats. (ClassSeats = -999 when end the file is reached) Update Classes inventory (add to inventory/deduct from inventory) Calculate and print the student’s bill. Calculate and print the total number of students in each class. Calculate and print the average number of students in each class. The student will...
a) Create a Table called Students b) Develop a Form with the following fields FName, LName, Test1, Test2, Test3,State c)Using the Form fill the Table with the following data FName LName Test Test 2 Test 3 State Bob Smith 79 81 86 NY Thorpe 82 Griffey 100 Colon Jim 64 91 Conn Ohio Ken 95 92 85 Bartolo 88 93 Ohio Cal Ken Keltner 91 84 87 Lou Staub 76 89 42 Mich PROBLEM: Find and print the LName of...
Can someone please help me solve the following database management
question a - d please help
uestion-4 The relational database schema of Question-3 is reproduced here. COURSE (NUMBER, TITLE, ENROLLED) RANK-1 (CNUMBER, R1-SSN) RANK-2 (CNUMBER, R2-SSN) TALLEST (CNUMBER, TALL-SSN) STUDENT (SSN, NAME, MAJOR, SEX, GPA) Formulate the following queries in soL. (30] (a) List the course numbers in which "Jack Hernandez" is the first ranked student. You are not allowed to use any JOIN operation and your answer must be...
You are working on an assignment for your statistics class. You need to E Select one answer. estimate the proportion of students at your college who delay taking their first 10 points math class for at least one year. Which sampling plan will produce the most reliable results? A. Obtain a list of all students enrolled at the college. Randomly select 100 students from the list. B. O Work with the math instructors to create a list of students currently...
Consider the following table definitions: create table node (node_id integer primary key, node_color varchar(10)); create table edge (edge_id integer primary key, origin_id integer, destination_id integer, foreign key (origin_id) references node (node_id), foreign key (destination_id) references node (node_id) ); Which of the following list the ids of nodes that link to both the node with id 3 and and the node with id 4? select node id from node inner join edge on node_id=origin_id where destination_id=3 and destination_id=4; select node_id from...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago