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)
The Research paper on The Now Wedding Final Project
There was a tremendous amount of planning, organizing and tasks that needed to be accomplished for the “NOW” wedding to take place on time, in budget and for it to be perfectly memorable for everyone, especially Lauren and Conner. For Lauren to have the wedding that she dreamed of there were numerous tasks that needed to be accomplished immediately. The first task that needed to be accomplished ...
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?
The Essay on Project Guideline
If you not able to submit/resubmit your synopsis as per the timeline given above than you can submit in the next session ( Ist week of July to 15th September, 2013 without any fine) Student can submit their project report with a copy of approved synopsis, Guide Resume, Acknowledgement Letter from Project Guide at (IMT-CDL Ghaziabad, Hyderabad, Kolkata & Mumbai) PROJECT SYNOPSIS GUIDELINE ...
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 |.
The Essay on 16 Personality Factors And College Students
16 Personality Factors and College Students The Sixteen Personality Factor Questionnaire (16PF) is an objective test of 16 multidimensional personality attributes arranged in omnibus form. In general, it provides normed references to each of these attributes (the primary scales). Conceptualized and initially developed by Raymond B. Cattell in 1949 as a broad, multipurpose measure of the source ...
+———–+————+——+——+ 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 | +——-+———+
