6 Marks Learning Outcome(s): To understand the significance of Information Techn
ID: 3603537 • Letter: 6
Question
6 Marks
Learning Outcome(s):
To understand the significance of Information Technology and its applications in professional life.
Question One
A database interrogation is a major benefit of the database management approach, where end users can query (“ask”) the database for information. The Structured Query Language (SQL) is an international standard query language found in many DBMS packages. The basic form of a SQL query is: SELECT . . . FROM . . . WHERE . . .
For example, if we have the following STUDENTS table:
STUDENT_ID
STUDENT_NAME
COURSE_ID
STUDENT_GPA
COLLEGE_CODE
140064001
Ahmad Nasser
IT101
3.5
CHS
140064002
Sarah Abdullah
IT343
2.75
CCI
140064003
Sultan Mohamed
IT242
3.15
CCI
140064004
Basmah Khaled
IT446
3.90
CCI
140064005
Bader Ali
IT101
2.90
CHI
140064006
Fahad Mutlaq
IT448
1.95
CCI
140064007
Salman Abdulaziz
IT242
2.90
CCI
The following SQL query is used to retrieve STUDENT_NAME and COURSE_ID for all students who have GPA = 2.90
SELECT [STUDENT_NAME], [COURSE_ID]
FROM [STUDENTS]
WHERE [STUDENT_GPA] = 2.90
And the result of the above query is:
STUDENT_NAME
COURSE_ID
Bader Ali
IT101
Salman Abdulaziz
IT242
6 Marks
Explanation / Answer
NOTE:
Any doubt during the understanding of the below points drop a comment
give a postive feed back by giving thumbsup when satisfied with the answer
------------------------------------------------------
significance of Information Technology and its applications in professional life:
1.when gone to shopping mall paying the bill makes so flexible.
Eample: By using the debitcard/credit card to pay the bill
2.It is so fast and accurate when preparing the bill for all the items brought in the supermarket bill counter
Example: by using the applications like supermarket billing system
3.Making the the use of existing customer purchasing data to analyze the trends.
Ex: what items are mostly purchased by by most customers during what time/months
4. Automating the manufacturing process with integrating software will enhance the productivity.
5. Making the communication very easy and faster.
Ex: like email where we can send messages very fast
6.Saving the time by purchasing the required items/products/goods online
Ex: Online shopping.
8.Provide a central learning platform for getting any kind of information
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.