This is about identifiers in a record referring to other records.
You can have many to one, one to one, many to many.
E.g., if you have two tables, Authors and Books, then a book record could have a reference to an author record. Since an author can write many books, this would be a many-to-one relationship.
Answer:
Artificial Intelligence.
Automated personal digital assistant.
THz frequencies for Communications (5G & 6G)
Blockchain.
Virtual reality and augmented reality.
Internet of Things (IoT)
Visible light communication.
LTE.
Explanation:
Advantages;
Firstly, the internet can let a person to communicate with people in virtually any parts of the world through the internet or e-mail, without having to leave his room. E-mail allowed peoples to communicate with minimum of times. It is now possibles to send a message to any parts of the world through a simple e-mail address and the message is delivered in matter of seconds. Every companies is using e-mail in business. The convenience of e-mail has allowed businesses to expand and communicates with their vendors and customers located all over the world in records times. Personal communication has also become more easier thanks to e-mail. Chat rooms, video conferencing are some of the latest additions in this technology and these have allowed peoples to chat in real time. Besides, there are a lot of messengers services in offering. With the help of such services, it has become very easy to establish a kind of global friendship where you can share your thoughts and explore other cultures. The internet also allows people within an organization to easily communicate and share informations.
Second, information is probably the biggest advantages that internet offers. Internet is a virtual treasures trove of information. Any kinds of information on any topic under the sun is available on the internet. The search engines like Google, Yahoo are at your service through the internet. There is a huge amount of information available on the internet for just about every subjects known to man, ranging from government law and services, trade fairs and conferences, market information, new ideas and technical support, the lists is simply endless. We can uses these search engines, websites dedicated to different subjects and large amount of articles and papers are available for perusal in a matter of a few seconds.
Forums on a number of sites allow peoples to discuss and share their thoughts and informations with others located at different places all over the world. Whether this information is the latest news happenings in the world or information about your favourite celebrity, everything is available at your finger tips. A huge cache of data is available on the internet on every single subjects. With this storehouse of information people can not only increases their knowledge bank but can do so without wasting their time through traditional means such as visiting libraries and conducting exhaustive research. With internet, students can save their times to search for information and using their time to do other works.
This is particularly relevant for students who can use this wealth of information for their school projects and also learn new things about the subjects they are interested in. In fact this internet is for many schools and universities that are now able to assigns projects and work to the students and follows their progress which can be easily posted on the school or university internal websites. Online education has grown at a very fast pace since internet allow the development and uses of innovative tools for imparting education. University students and lecturers can communicate through internet. Besides, some universities are also offerings far distances courses to make study become more inefficient and convenience. Internet become a gateway for those who wants to learn but cannot afford the living fees at foreign countries.
Thirdly, entertainments is another popular reasons why many people prefer to surf the internet. In fact, the internet has becomes quite successful in trapping the multifaceted entertainment industry. Downloading games or just surfing the celebrity websites are some of the uses people have discovered. Even celebrities are using the internet effectively for promotional campaigns. Besides that, there are numerous games that can be downloaded for free. The industry of online gaming has tasted dramatic and phenomenal attentions by game lovers. The internet has also revolutionized the entertainments industry. People nowadays no need to go to a cinema hall to watch your favourite movie. Instead of watching movies at cinema now have companies offering their services where you just can downloads or order your favourite movie and watch it with a fast internet connection. Besides that, you also can download other important software or your favourite music in a matter of few minutes. There are a number of shareware programs that allow you to share and download your favourite music and videos. The internet also allows people from different cultures and background to connect with each other. Internet gaming is a huge business and allow enthusiastic gamers to compete against each other in games even when they are located far apart. Likewise dating has also allowed people to find their prospective soul mates.
Answer:
The Update statement in the DML is used for changing existing data in a table.
Explanation:
Their are following Sql statement in the DML.
Insert
This SQL statement is used for inserting data into the table.
select
This SQL statement is used for retrieving data from database
update
This SQL statement is used for updating data in a table.
delete
This SQL statement is used for delete data from database .
The "UPDATE" SQL statement in DML is used for Modify the data in the existing table .
Following are the syntax of Update SQL query
Update tablename
set column1=value1,column2=value2............column N=valueN
Where condition;
Example :Suppose we have student table and (rollno,name,age and add) are the field for that table we have to change the address of rollno 105
Then we use update query like that
UPDATE STUDENT
SET add='kalam nagar'
where rollno=105;
