Questions
Question (3) Consider the following relations: Student(snum: integer, sname: string, major: string, level: string, age: integer)...

Question (3)
Consider the following relations:
Student(snum: integer, sname: string, major: string, level: string, age: integer)
Class(name: string, meets at: string, room: string, fid: integer)
Enrolled(snum: integer, cname: string)
Faculty(fid: integer, fname: string, deptid: integer)
The meaning of these relations is straightforward; for example, Enrolled has one record per student-class pair such that the student is enrolled in the class.
Write the following queries in Oracle SQL. No duplicates should be printed in any of the answers.
i) (2 points) Find the names of all Juniors (level = JR) who are enrolled in a class taught by I. Teach.
ii) (2 points) Find the age of the oldest student who is either a History major or enrolled in a course taught by I. Teach.
iii) (2 points) Find the names of all classes that either meet in room R128 or have five or more students enrolled.
iv) (3 points) Find the names of all students who are enrolled in two classes that meet at the same time.
v) (2 points) Find the names of faculty members who teach in every room in which some class is taught.
vi) (2 points) Find the names of faculty members for whom the combined enrollment of the courses that they teach is less than five.
vii) (2 points) For each level, print the level and the average age of students for that level.

**Please Write in Oracle SqlPlus**

In: Computer Science

<< UNIX >>> BY this file contains ELMER SOLVER (v 8.4) STARTED AT: 2020/03/18 13:04:22 ParCommInit:...

<< UNIX >>>

BY this file contains

ELMER SOLVER (v 8.4) STARTED AT: 2020/03/18 13:04:22
ParCommInit: Initialize #PEs: 1
MAIN:
MAIN: =============================================================
MAIN: ElmerSolver finite element software, Welcome!
MAIN: This program is free software licensed under (L)GPL
MAIN: Copyright 1st April 1995 - , CSC - IT Center for Science Ltd.
MAIN: Webpage http://www.csc.fi/elmer, Email [email protected]
MAIN: Version: 8.4 (Rev: unknown, Compiled: 2020-02-28)
MAIN: Running one task without MPI parallelization.
MAIN: Running with just one thread per task.
MAIN: HYPRE library linked in.
MAIN: MUMPS library linked in.
MAIN: =============================================================
MAIN:
MAIN:
MAIN: -------------------------------------
MAIN: Reading Model: case.sif
LoadInputFile: Scanning input file: case.sif
LoadInputFile: Loading input file: case.sif
WARNING:: LoadInputFile: There are no BCs in the system!
LoadInputFile: Number of Body Forces: 1
LoadInputFile: Number of Initial Conditions: 0
LoadInputFile: Number of Materials: 1
LoadInputFile: Number of Equations: 1
LoadInputFile: Number of Solvers: 1
LoadInputFile: Number of Bodies: 1
Loading user function library: [HeatSolve]...[HeatSolver_Init0]
LoadMesh: Base mesh name: ./.
LoadMesh: Elapsed REAL time: 0.5294 (s)

Question: I want to create new file that just print between "==" by sing Unix/Linx

this code isn't complete because the output is not correct

#!/bin/bash
while ISF= read line
do

if [[ $line = *"="* ]]

then

echo $line >> Lines

fi

done < "unix"

I REALLY NEED HELP

THANKS,

In: Computer Science

Sorry there is no more information i could provide.Please give each step's code in two class....

Sorry there is no more information i could provide.Please give each step's code in two class.

This question is about the java program and it conclude six step.Please show every step's code in two class and answer the question :"How many tests should the testStudent method now contain" "Do not forget to modify your testStudent method to test the new code. "and please explain why?Thank you!

Step1:

Create a class Student that contains the following things:
 a private integer ID number;
 a constructor that takes as argument an ID number and uses this ID number to initialize the object's ID number;
 a public method getID that takes zero argument and returns the ID number of the student;
 a public static method testStudent that contains tests for your class.
Here is the corresponding UML diagram (remember that + means public and - means private):
+--------------------------+
| Student |
+--------------------------+
| - ID: int |
+--------------------------+
| + Student(int ID) |
| + getID(): int |
| + testStudent(): void |
+--------------------------+
The Student class does not have a setID method because the ID number of a student never changes.
How many tests should the testStudent method contain?
Once you have written the Student class, you can test it by adding the following code in a new class called Start in the same project:
public class Start {
public static void main(String[] args) {
Student.testStudent();
}
}
This code calls the static testStudent method of the Student class, which should then run all your tests.
What is the problem if you make the ID instance variable public?

Step 2

Modify the constructor of the Student class so that negative ID numbers are not allowed when creating a Student object. If the constructor is given a negative ID number as argument then the constructor should use 0 for the ID number.
Modify your testStudent method to test the new code. How many tests should the testStudent method now contain?

Step 3

Add to your Student class a string representing the name of the student. The constructor for the class should now take the name of the student as an extra argument. Also add to your class two methods getName and setName to get and change the name of a student (a student is allowed to change name).
Here is the corresponding UML diagram:
+--------------------------------+
| Student |
+--------------------------------+
| - ID: int |
| - name: String |
+--------------------------------+
| + Student(int ID, String name) |
| + getID(): int |
| + getName(): String |
| + setName(String name): void |
| + testStudent(): void |
+--------------------------------+
Note: we have not talked much about the String type in class yet. For now just use it like you use any other type (like int or float).
Do not forget to modify your testStudent method to test the new code. In Java you can use == to compare constant strings.

Step 4

Add to your Student class a character representing the grade of the student. The default grade when a student is created is 'A'. Also add to your class two methods getGrade and setGrade to get and change the grade of a student.
Here is the corresponding UML diagram:
+--------------------------------+
| Student |
+--------------------------------+
| - ID: int |
| - name: String |
| - grade: char |
+--------------------------------+
| + Student(int ID, String name) |
| + getID(): int |
| + getName(): String |
| + setName(String name): void |
| + getGrade(): char |
| + setGrade(char grade): void |
| + testStudent(): void |
+--------------------------------+
Do not forget to modify your testStudent method to test the new code. In Java you can use == to compare characters.

Step5

Add a new constructor to your Student class that takes three arguments as input: an ID number, a name, and an initial grade. Using this second constructor it becomes possible to create Student objects with an initial grade which is different from 'A'.
Here is the corresponding UML diagram:
+--------------------------------------------+
| Student |
+--------------------------------------------+
| - ID: int |
| - name: String |
| - grade: char |
+--------------------------------------------+
| + Student(int ID, String name) |
| + Student(int ID, String name, char grade) |
| + getID(): int |
| + getName(): String |
| + setName(String name): void |
| + getGrade(): char |
| + setGrade(char grade): void |
| + testStudent(): void |
+--------------------------------------------+
Do not forget to modify your testStudent method to test the new code.

Step 6

Add to your Student class a boolean indicating whether the student is currently sleeping in the lab or not. When a student is created, the student is awake. Also add to your class three methods:
 one method isSleeping that returns a boolean indicating whether the student is currently sleeping or not.
 one method goToSleep that makes the student fall asleep. When a student falls asleep, the grade of the student decreases by one letter grade ('A' becomes 'B', 'B' becomes 'C', 'C' becomes 'D', 'D' becomes 'F', 'F' stays an 'F', and any other grade becomes 'F' too).
 one method wakeUp that makes the student wake up. The grade of a student does not go up when the student wakes up.
Here is the corresponding UML diagram:
+--------------------------------------------+
| Student |
+--------------------------------------------+
| - ID: int |
| - name: String |
| - grade: char |
| - sleeping: boolean |
+--------------------------------------------+
| + Student(int ID, String name) |
| + Student(int ID, String name, char grade) |
| + getID(): int |
| + getName(): String |
| + setName(String name): void |
| + getGrade(): char |
| + setGrade(char grade): void |
| + isSleeping(): boolean |
| + goToSleep(): void |
| + wakeUp(): void |
| + testStudent(): void |
+--------------------------------------------+
Do not forget to modify your testStudent method to test the new code.

In: Computer Science

schema: Student( studID, name, major )   // dimension table, studID is key Instructor( instID, dept );  ...

schema:
Student( studID, name, major )   // dimension table, studID is key
Instructor( instID, dept );   // dimension table, instID is key
Class( classID, univ, region, country );   // dimension table, classID is key
Took( studID, instID, classID, score );   // fact table, foreign key references to dimension tables

Write a SQL query to find all students who took a class from an instructor not in the student's major department and got a score over 80.

Return the student name, instructor name, and score. ,

Please describe in sentences what you need to do to find this information

In: Computer Science

A paper edge slices your left index finger and you immediately move your hand away but...

  1. A paper edge slices your left index finger and you immediately move your hand away but it takes a few moments before you are “aware” of the pain. Then, by lightly rubbing the area, the pain disappears.

A. Name and diagram the reflex pathwaythat allowed you to remove your hand.

B. Why was the “feeling of pain” delayed? Where would this information ultimately have been interpreted? Name the fiber type associated with the primary afferent involved, and name the somatosensensory pathway it would have taken to get to the ultimate processing area.

C. Explain why light rubbing removed the pain sensation.

In: Anatomy and Physiology

Assume you are trying to choose 5 letters from your name and surname altogether (you can...

Assume you are trying to choose 5 letters from your name and surname altogether (you can use your name and surname. or can use someone's name and surname). By using the permutation rule, find how many different selection could be made if replacement is allowed and order is not important. By using the combination rule, find how many different selection could be made if replacement is allowed and order is not important. Repeat the same process once for the case when the order is important. you interpret all factors of the formula and explain everything you do in details.

In: Statistics and Probability

Question 1 (10) Single screen with information about a the 2020 Olympics Create an application using...

Question 1 (10) Single screen with information about a the 2020 Olympics
Create an application using PyQt. The user must enter the name of an Olympic sport and a single character (e.g ‘a’). The application must read the name of the sport and count the number of occurrences of the character in the sport name. The count should be case-insensitive. Thus, if ‘c’ is entered as the character then both capital letter ‘C’ and small letter ‘c’ in the string should be counted. The count must be displayed. The application interface must include at least a label, an edit and a button. You are welcome to enhance your application with comments and messages.

In: Computer Science

Why am I getting error below? sh-3.2# ./week4prog1[name].scr ./week4prog1[name].scr: line 2: count: command not found start...

Why am I getting error below?

sh-3.2# ./week4prog1[name].scr

./week4prog1[name].scr: line 2: count: command not found

start of the program

./week4prog1[name].scr: line 4: [: -le: unary operator expected

end of the program

Below is my vim script I am running. I can't see the error, please help:

#!/bin/bash

count =1

echo "start of the program"

while [ $count -le 10 ]

do

echo "Loop #$count"

sleep 10

count=$[ count + 1]

done

echo "end of the program"

In: Computer Science

PLEASE ANSWER WASNT ANSWERED PYTHON You will ask 3 questions USERNAME = "user1" PASSWORD = "password1"...

PLEASE ANSWER WASNT ANSWERED PYTHON

You will ask 3 questions

USERNAME = "user1"
PASSWORD = "password1"

  1. What is your user name?
  2. What is your password?
  3. What is your age?
    1. If the user name and password are incorrect, display a message that says - Your credentials are not valid
    2. If both user name and password are correct, ask question 3
    3. If the answer to question 3 is eighteen and greater, display a message that says - You're considered an adult
    4. If the answer to question 3 is less than eighteen, display a message that says - you're not considered an adult
    5. MAKE SURE to use the constants above

In: Computer Science

Do research current acquisition tools as many as you can that are available up to now,...

Do research current acquisition tools as many as you can that are available up to now, specifying computer forensics vendor name, acquisition tool name and features of the vendor’s product. You can classify the listing vendors you found with Excel or Word table that contains each row with the acquisition tool name and each column, such as raw format, proprietary format, AFF format, other proprietary formats the tool can read, compression of image files, remote network acquisition capabilities, and method used to validate (MD5, SHA-1, and so on). NO more than 10 pages overall.

In: Computer Science