All the questions are to run on the Application DATABASE Student(SID, SName, GPA, sizeHS); college(CName, State, Enroolment); Apply(SID, CName, Major, Decision) ;

PLEASE MAKE SURE THERE ARE NO DUPLICATES IN YOUR RESULTS

Q1.1: Get the names of all the students whose GPA>=3.8;

Q1.2:Get the names of all the students who applied to some college;

Q1.3: Get the names all the students who did not applied to any college;

Q1.4: Get the names and enrollment of all the colleges who received applications for a major involving bio;

Q1.5: Get all pairs of students who have the same GPA;

Q1.6: Get all the students who applied to both CS and EE majors;

Q7: Get all the students who applied to CS and not to EE;

Q1.8: Use subquery to answer Q1.6 & Q1.7;

Q1.9 :Get all colleges such that some other college is in the same state;

Q1.10: Get all students. with highest GPA--use the keyword EXISTS or NOT EXISTS to answer the query; hint; use a subquery

Q1.11: Now pair colleges with the name of their applicants.

How can i clip a picture to a question on the computer?

Data is processed, stored, and transmitted as a series of 1s and 0s. each 1 or 0 is called a(n) . a series of eight 0s and 1s, called a(n) , represents one character—a letter, number, or punctuation mark. data becomes when it is presented in a format that people can understand and use. digital signals are represented by two different , such as +5 volts and +.2 volts. digital data can also take the form of light and dark spots etched onto the surface of a cd or the positive and negative orientation of particles on the surface of a hard disk. data consists of numbers that might be used in arithmetic operations. it can be represented digitally using the number system. data is composed of letters, symbols, and numerals that are not used in arithmetic operations. computers represent this type of data using , ebcdic, unicode, or utf-8. data is quantified using terms such as or kibibyte (1024 bytes), and prefixes such as or mebi (1,048,576), and giga or (1,073,741,824). to reduce file size and transmission times, digital data can be compressed. compression provides the means to compress data and reconstitute it into its original state. compression throws away some of the original data during the compression process. compressed files usually have at the end of the file name and are represented with special icons. these files have to be or unzipped before you can view the data they contain.

Consider the following function main: int main() { int alpha[20]; int beta[20]; int matrix[10][4]; . . } a. write the definition of the function inputarray that prompts the user to input 20 numbers and stores the numbers into alpha. b. write the definition of the function doublearray that initializes the elements of beta to two times the corresponding elements in alpha. make sure that you prevent the function from modifying the elements of alpha. c. write the definition of the function copyalphabeta that stores alpha into the first five rows of matrix and beta into the last five rows of matrix. make sure that you prevent the function from modifying the elements of alpha and beta. d. write the definition of the function printarray that prints any onedimensional array of type int. print 15 elements per line. e. write a c11 program that tests the function main and the functions discussed in parts a through d. (add additional functions, such as printing a two-dimensional array, as needed.)