Prime number

Custom Student Mr. Teacher ENG 1001-04 21 October 2016

Prime number

A4 – Intermediate Queries Assignment 4 1. CREATE AN ORACLE TABLE FOR THE FOLLOWING STUDENT DATA: STUDENT Name ID Major CourseAssignment 1Assignment 2Midterm Final Project Aisha Ahmed 200312345 CIT CIT365 83 91 77 82 71 Anood Abdulla 20031235 6 BUS CIT365 77 81 66 76 81 Budoor Mahommad 20033312 3 EDC CIT365 91 79 92 88 91 Fatma Essa 20031452 1 CIT CIT365 66 55 60 73 69 Ghulood Ali 20031121 1 CIT CIT365 58 72 88 81 88 Hanan Ahmed 20036121 2 BUS CIT365 100 92 90 91 95 Hanan Abdulla 20041212 1 CIT CIT365 93 88 83 81 83 Laila Saeed 20027123 4 EDC CIT365 67 72 78 74 81 Maryam Ibrahim 20031991.

1 CIT CIT365 82 86 84 91 93 Shamsa Khalid 20038634 1 BUS CIT365 89 96 92 98 92 CREATE TABLE STUDENTS ( ID DECIMAL(9), NAME VARCHAR(20), MAJOR CHAR(3), COURSE VARCHAR(6), A1DECIMAL(3), A2DECIMAL(3), MIDTERM DECIMAL(3), FINAL DECIMAL(3), PROJECT DECIMAL(3), PRIMARY KEY(NUMBER)); A4 – Intermediate Queries 2. CREATE INSERT STATEMENTS TO ENTER THE DATA INTO YOUR TABLE. WRITE QUERIES TO ANSWER THE FOLLOWING: INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200312345,’AISHA AHMED’,’CIT’,’CIT365′,83,91,77,82,71); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT).

VALUES (200312356,’ANOOD ABDULLA’,’BUS’,’CIT365′,77,81,66,76,81); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200333123,’BUDOOR MAJOMMED’,’EDC’,’CIT365′,91,79,92,88,91); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200314521,’FATMA ESSA’,’CIT’,’CIT365′,66,55,60,73,69); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200311211,’GHULOOD ALI’,’CIT’,’CIT365′,58,72,88,81,88); INSERT INTO STUDENTS A4 – Intermediate Queries (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT)

VALUES (200361212,’HANAN AHMED’,’BUS’,’CIT365′,100,92,90,91,95); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200412121,’HANAN ABDULLA’,’CIT’,’CIT365′,93,88,83,81,83); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200271234,’LAILA SAEED’,’EDC’,’CIT365′,67,72,78,74,81); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200319911,’MARYAM IBRAHIM’,’CIT’,’CIT365′,82,86,84,91,93); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200386341,’SHAMSA KHALID’,’BUS’,’CIT365′,89,96,92,98,92);

3. HOW MANY STUDENTS ARE THERE IN THE COURSE? SELECT * FROM STUDENTS WHERE COURSE=’CIT365′; +———–+—————–+——-+——–+——+——+———+——-+ ———+ | ID | NAME | MAJOR | COURSE | A1 | A2 | MIDTERM | FINAL | PROJECT | +———–+—————–+——-+——–+——+——+———+——-+ A4 – Intermediate Queries ———+ | 200271234 | LAILA SAEED | EDC | CIT365 | 67 | 72 | 78 | 74 | 81 | | 200311211 | GHULOOD ALI | CIT | CIT365 | 58 | 72 | 88 | 81 | 88 | | 200312345 | AISHA AHMED | CIT | CIT365 | 83 | 91 | 77 | 82 | 71 |.

| 200312356 | ANOOD ABDULLA | BUS | CIT365 | 77 | 81 | 66 | 76 | 81 | | 200314521 | FATMA ESSA | CIT | CIT365 | 66 | 55 | 60 | 73 | 69 | | 200319911 | MARYAM IBRAHIM | CIT | CIT365 | 82 | 86 | 84 | 91 | 93 | | 200333123 | BUDOOR MAHOMMED | EDC | CIT365 | 91 | 79 | 92 | 88 | 91 | | 200361212 | HANAN AHMED | BUS | CIT365 | 100 | 92 | 90 | 91 | 95 | | 200386341 | SHAMSA KHALID | BUS | CIT365 | 89 | 96 | 92 | 98 | 92 | | 200412121 | HANAN ABDULLA | CIT | CIT365 | 93 | 88 | 83 | 81 | 83 | +———–+—————–+——-+——–+——+——+———+——-+ 5. WHICH STUDENTS HAVE THE LETTER “S” IN THEIR NAMES?

A4 – Intermediate Queries SELECT NAME FROM STUDENTS WHERE NAME LIKE ‘%S%’; +—————+ | NAME | +—————+ | LAILA SAEED | | AISHA AHMED | | FATMA ESSA | | SHAMSA KHALID | +—————+ 6. LIST THE AVERAGE SCORE FOR EACH STUDENT. ASSUME THAT ALL ASSESSMENTS HAVE EQUAL WEIGHT. SELECT NAME,(A1+A2+MIDTERM+FINAL+PROJECT)/5 AS AVERAGE FROM STUDENTS; +—————–+———+ | NAME | AVERAGE | +—————–+———+ | LAILA SAEED | 74. 4000 | | GHULOOD ALI | 77. 4000 | | AISHA AHMED | 80. 8000 | | ANOOD ABDULLA | 76. 2000 | | FATMA ESSA | 64. 6000 | | MARYAM IBRAHIM | 87.

2000 | | BUDOOR MAHOMMED | 88. 2000 | | HANAN AHMED | 93. 6000 | A4 – Intermediate Queries | SHAMSA KHALID | 93. 4000 | | HANAN ABDULLA | 85. 6000 | +—————–+———+ 7. WHAT IS THE AVERAGE SCORE FOR THE STUDENT WHO SCORED HIGHEST ON THE MIDTERM? SELECT NAME,MAX(MIDTERM),(A1+A2+MIDTERM+FINAL+PROJECT)/5 AS HIGHSTMIDTERMSCOREDSTUDENTSAVERAGE FROM STUDENTS; +————-+————–+————————————+ | NAME | MAX(MIDTERM) | HIGHSTMIDTERMSCOREDSTUDENTSAVERAGE | +————-+————–+————————————+ | LAILA SAEED | 92 | 74.

400000000 | +————-+————–+————————————+ 8. LIST THE DATA SORTED BY MAJOR AND WITHIN MAJOR BY NAME. SELECT MAJOR FROM STUDENTS ORDER BY MAJOR; +——-+ | MAJOR | +——-+ | BUS | | BUS | | BUS | | CIT | | CIT | | CIT | A4 – Intermediate Queries | CIT | | CIT | | EDC | | EDC | +——-+ 9. LIST THOSE STUDENTS WHO SCORED LESS THAN 70 ON ANY ASSESSMENT. SELECT ID,NAME,A1,A2 FROM STUDENTS WHERE (A1< 70) AND (A2<70); +———–+————+——+——+ | ID | NAME | A1 | A2 | +———–+————+——+——+ | 200314521 | FATMA ESSA | 66 | 55 |.

+———–+————+——+——+ 10. LIST THE MAJORS AND THE NUMBER OF STUDENTS IN EACH MAJOR. SELECT MAJOR,COUNT(MAJOR) FROM STUDENTS GROUP BY MAJOR; +——-+————–+ | MAJOR | COUNT(MAJOR) | +——-+————–+ | BUS | 3 | | CIT | 5 | | EDC | 2 | +——-+————–+ 11. LIST THE AVERAGE OVERALL GRADE FOR EACH MAJOR SELECT MAJOR,(A1+A2+MIDTERM+FINAL+PROJECT)/5 AS AVG FROM STUDENTS GROUP A4 – Intermediate Queries BY MAJOR; +——-+———+ | MAJOR | AVG | +——-+———+ | BUS | 76. 2000 | | CIT | 77. 4000 | | EDC | 74. 4000 | +——-+———+

A

  • Subject:

  • University/College: University of Arkansas System

  • Type of paper: Thesis/Dissertation Chapter

  • Date: 21 October 2016

  • Words:

  • Pages:

We will write a custom essay sample on Prime number

for only $16.38 $12.9/page

your testimonials