ITEC 3220 Lecture Notes - Lecture 1: Cross Product, Cosc

12 views2 pages

mraliice

13 Dec 2021

School

York University

Department

Information Technology

Course

ITEC 3220

Professor

For unlimited access to Class Notes, a Class+ subscription is required.

Document Summary

1 - find the ids and names of students who have been registered for itec or cosc program. We don"t have distinct because union eliminates duplicates, otherwise use all. 2 find the ids and names of students who have been registered in both itec and cosc courses. 3 find the sid of students who have been registered for itec courses, but not cosc courses. Select sid, sname from student natural join transcript natural join course where pcode = 4 find ids of students who are younger than 24 and are enrolled in cosc courses. 5 find the ids and names of students who have been enrolled in at least two courses. Cross product of two identical instances of the table transcript, use qualification to select same student id but different course code then we need to join this result with table student. Select distinct s. sid, s. sname from student s join transcript t1 on s. sid = t1. sid join transcript t2.

Related Questions

For many of us, smartphones have become indispensable, but they have also come under fire
for their impact on the way we think and behave, especially among children. Two of the largest
investors in Apple Inc. are urging the iPhone maker to take action against smartphone addiction
among children over growing concerns about the negative effects of technology. An open letter
to Apple on January 6, 2018 from New York-based JANA Partners and the California State
Teachers’ Retirement System (CalSTRS) stated that the firm must do more to help children
fight smartphone addiction. These two shareholders together control about $2 billion in Apple
stock. The investors’ letter urged Apple to offer tools to prevent smartphone addiction and to
provide more parental options for monitoring children’s smartphone usage. The iOS operating
system for Apple smartphones and tablets already has limited parental controls for restricting
Examiners: Dr. Emmanuel Awuni and Dr. Acheampong Owusu Page 2 of 4
apps, features such as location sharing, and access to certain types of content. The investors
felt Apple needs to do more—for example, enable parents to specify the age of the user of the
phone during setup, establish limits on screen time, select hours of the day the phone can be
used, and block social media services.
The average American teenager who uses a smartphone receives his or her first phone at age
10 and spends over 4.5 hours a day on it (excluding texting and talking). Seventy-eight percent
of teens check their phones at least hourly and 50 percent report feeling “addicted” to their
phones. The investors’ letter cited a number of studies on the negative effects of heavy
smartphone and social media use on the mental and physical health of children whose brains
are still developing. These range from distractions in the classroom to a higher risk of suicide
and depression. A recent survey of over 2,300 teachers by them Center on Media and Child
Health and the University of Alberta found that 67 percent of the teachers reported that the
number of students who are negatively distracted by digital technologies in the classroom is
growing. Seventy-five percent of these teachers think students’ ability to focus on educational
tasks has decreased. Research by psychology professor Jean Twenge of San Diego State
University found that U.S. teenagers who spend 3 hours a day or more on electronic devices
are 35 percent more likely, and those who spend 5 hours, or more are 71 percent more likely,
to have a risk factor for suicide than those who spend less than 1 hour. This research also
showed that eighth-graders who are heavy users of social media have a 27 percent higher risk
of depression. Those who spend more than the average time playing sports, hanging out with
friends in person, or doing homework have a significantly lower risk. Additionally, teens who
spend 5 or more hours a day on electronic devices are 51 percent more likely to get less than 7
hours of sleep per night (versus the recommended 9).
Nicholas Carr, who has studied the impact of technology on business and culture, shares these
concerns. He has been highly critical of the Internet’s effect on cognition, and these cognitive
effects extend to smartphone use. Carr worries that excessive use of mobile devices diminishes
the capacity for concentration and contemplation. Carr recognizes that smartphones provide
many useful functions in a very handy form. However, this extraordinary usefulness gives them
too much influence on our attention, thinking, and behaviour. Smartphones shape our thoughts
in deep and complicated ways, and their effects persist even when we aren’t using the devices.
Research suggests that the intellect weakens as the brain grows dependent on the technology.
Carr points to the work of Adrian Ward, a cognitive psychologist and marketing professor at
the University of Texas at Austin, who for a decade has been studying how smartphones and
the Internet affect people’s thoughts and judgment. Ward has observed that using a smartphone,
or even hearing one ring or vibrate, produces distractions that make it harder to concentrate on
a difficult problem or job. Divided attention impedes reasoning and performance.
A study published in Applied Cognitive Psychology in April 2017 examined how smartphones
affected learning in a lecture class with 160 students at the University of Arkansas at
Monticello. It found that students who didn’t bring their phones to the classroom scored a full
letter-grade higher on a test of the material presented than those who brought their phones. It
didn’t matter whether students who brought their phones used them or not. A study of 91 U.K.
secondary schools, published in 2016 in the journal Labour Economics, found that when
schools ban smartphones, students’ examination scores go up substantially, and the weakest
students benefit the most. Carr also observes that using smartphones extensively can be
detrimental to social skills and relationships. Connecting with “friends” electronically via
smartphones is not a substitute for genuine person-to-person relationships and face-to-face
conversations.

rubyarmadillo521

ITEC 3220 Lecture Notes - Lecture 1: Cross Product, Cosc

Document Summary

Get access

Related Documents

CS348 Lecture Notes - William R. Day, Final Grades, Foreign Key

IOE 373 Study Guide - Midterm Guide: Dialog Box, Datapoint, Second Normal Form

PSYC 4008 Lecture : PSYC 4008 Semster Notes

Related Questions