write a query that will display the following information about course sections (the course_section table): the course ID number and section number, the days of the week that the class meets, the duration of the class in munites, and the maximum enrollment. only returns those rows whose maximum enrollment is between 30 and 35,
If you have any doubts, please give me comment...
SELECT course_num, section_num, days_of_week, duration, max_enrollment
FROM course_section
WHERE max_enrollment BETWEEN 30 AND 35;
Assumed schema:
course_section(course_num, section_num, days_of_week, duration, max_enrollment);
Let me know if schema changes. Thank you...
write a query that will display the following information about course sections (the course_section table): the...
Course: Fundamentals of Databases Write a Query for the Following Table. Table Name: Student Stu_ID Name Age Address Phone 1452364 Alla 22 Riyadh 7772223310 1452365 Ahamed 25 Jeddah 7772223311 a) Write a Query for Create Table: b) Write a Query for insert filed in above Given Table. c) Write a Query for Replace Age = 25 Replace by 26 the above given Table. d) Write a Query for Remove Student ID =1452364 one Row above given Table. e) Drop Student...
1. Display the query you would write to update the salary for John Jones 2. Display the query you would write to update all salaries by 5% 3. Display the query you would write to update all salaries by 5% for only the employees who live in Arizona 4. Write a query to insert a new record into the empinfo table (Hint: you are adding a full record - a new piece of information for each field/column) 5. Write a...
SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee table. If the employee id is 777, name is ABC and hire date is 01-JAN-2016, the output should look as follows - 'Stephen (Employee ID - 777) was hired on the 1st of January, 2016 – Department: 90'. Note - The date should not have preceding...
Course, Schedule, and ScheduleTester (100%) Write a JAVA program that meets the following requirements: Course Class Create a class called Course. It will not have a main method; it is a business class. Put in your documentation comments at the top. Be sure to include your name. Course must have the following instance variables named as shown in the table: Variable name Description crn A unique number given each semester to a section (stands for Course Registration Number) subject A...
Please write ONE SQL statement for each of the following tasks using the below tables. Note that you can only use conditions specified in the task description and cannot manually look up data and add conditions. Task 1: return title of textbooks with price over $100. Task 2: return number of courses sections scheduled for each year and semester. Please return year, semester, and number of courses. Task 3: Return names of all courses in Information Systems undergraduate program. Task...
Java program The file enrollments.txt is a text file with each line containing a positive integer that represents the enrollment in a section of CIS 103. The highest value is 36. Write a program to read the data from the file into an array, then calculate and display the number of sections, the average class size, the minimum class size, and the maximum class size. enrollments.txt 36 36 36 34 35 25 34 31 29 19 35 33 36 32...
Problem 1. Please create the following tables for UMBC bookstore’s textbook management system with appropriate primary keys & foreign keys. Please include drop table statements with cascade constraints before your create table statements so it is easier to grade your create table statements. E.g., suppose you will create table tab1, tab2, including the following before creating them: Drop table tab1 cascade constraints; Drop table tab2 cascade constraints; Assumptions: Each teacher can teach one or more scheduled course sections. Each scheduled...
Using the tables at the bottom, write a query to produce the results needed to answer each question below. 1. Display the query you would write to update the salary for John Jones 2. Display the query you would write to update all salaries by 5% 3. Display the query you would write to update all salaries by 5% for only the employees who live in Arizona 4. Write a query to insert a new record into the empinfo table...
Create a DataEntryException class whose getMessage() method returns information about invalid integer data. Write a program named GetIDAndAge that continually prompts the user for an ID number and an age until a terminal 0 is entered for both. If the ID and age are both valid, display the message ID and Age OK. Throw a DataEntryException if the ID is not in the range of valid ID numbers (0 through 999), or if the age is not in the range...
5. (3 pts) Write a SQL command that will insert a record into the “appts” table above for a student named “Kelly”, where the advisor is “JSR”, and the room number is 5. 6. (3 pts) Write a SQL command that will display the name of students that are associated with the advisor named “JSR”. 7. (7 pts) Use the FRIENDS table to answer the following questions. LASTNAME FIRSTNAME AREACODE PHONE ST ZIP --------------- ---------------- -------- -------- -- ------ BUNDY ...