Search
Consider the global relations EMP(ENAME, TITLE, CITY) and ASG(ENAME, PNAME, CITY, DUR). City in ASG is the location of the project of name PNAME (i.e., PNAME functionally determines CITY). Consider the local relations EMP1(ENAME, TITLE, CITY), EMP2(ENAME, TITLE, CITY), PROJ1(PNAME, CITY), PROJ2(PNAME, CITY) and ASG1(ENAME, PNAME,DUR). Consider query Q which selects the names of the employees assigned to a project in Rio de Janeiro for more than 6 months and the duration of their assignment.
(a) Assuming the GAV approach, perform query rewriting.
(b) Assuming the LAV approach, perform query rewriting using the bucket algorithm.
Consider the global relations EMP(ENAME, TITLE, CITY) and ASG(ENAME, PNAME, CITY, DUR). City in ASG is the location of the project of name PNAME (i.e., PNAME functionally determines CITY). Consider the local relations EMP1(ENAME, TITLE, CITY), EMP2(ENAME, TITLE, CITY), PROJ1(PNAME, CITY), PROJ2(PNAME, CITY) and ASG1(ENAME, PNAME,DUR). Consider query Q which selects the names of the employees assigned to a project in Rio de Janeiro for more than 6 months and the duration of their assignment.
(a) Assuming the GAV approach, perform query rewriting.
(b) Assuming the LAV approach, perform query rewriting using the bucket algorithm.
Modify the program from Lab 3 to show the shades of green and then move the turtle forward 300 steps without writing (use the penup() and pendown() turtle functions) and repeat the same loop, but backwards.
Your output should look similar to:
1. Explain the term Computer Virus.
2. Give five (5) examples of antivirus applications.
3. Mention four (4) instances of how Computer Viruses are spread.
4. State three symptoms of Computer Viruses.
A development team is developing a special purpose application for some organization. The data is very large but relatively static. Data loss is an acceptable risk. Multiple users are accessing the application at the same time. File system and database system are two approaches which can be used to store data. Being a database expert, you are approached by the Team manager to help them in deciding which of the above mentioned data storage system will be more suitable for current scenario.
Suggest the storage system considering the above mentioned scenario with solid reasoning.
a) Suppose you own a clotting brand company with your name, then how will you manage the data of your customers, orders, contracts, accounts, fixed and running expenses efficiently?
b) Would you prefer electronic database over manual database? Why or Why not? List down at least three databases available in the market for commercial use.
c) Design the database for your clotting brand company using MS Access. Design tables (as mentioned in part a) with necessary fields (must include primary and foreign keys) and draw the ERD diagram. (Paste the image of ERD diagram using snipping tool in your answer sheet). Use query to fetch any specific information of your interest from more than one table (Paste the complete image using snipping tool in your answer sheet).
development team is developing a special purpose application for some organization. The data is very large but relatively static. Data loss is an acceptable risk. Multiple users are accessing the application at the same time. File system and database system are two approaches which can be used to store data. Being a database expert, you are approached by the Team manager to help them in deciding which of the above mentioned data storage system will be more suitable for current scenario.
Suggest the storage system considering the above mentioned scenario with solid reasoning.
Consider the following variables:
int flags = 0xB2;
int mask;
What of the following are the correct statements if bit 6 of flags is to be toggled?
mask=0xBF;
flags = flags ^ mask;mask=0x40;
flags = flags ^ mask;mask=0xBF;
flags = flags | mask;mask=0x40;
flags = flags | mask;
A development team is developing a special purpose application for some organization. The data is very large but relatively static. Data loss is an acceptable risk. Multiple users are accessing the application at the same time. File system and database system are two approaches which can be used to store data. Being a database expert, you are approached by the Team manager to help them in deciding which of the above mentioned data storage system will be more suitable for current scenario.
Internet of things(IOT) is an interconnection of physical devices and internet. These devices have the capability to sense, monitor and respond to various actions. In current situation of pandemic COVID-19, it has been observed that touching of things like thermometer by different persons could enhance the possibility to transfer the virus from thermometer to second person, if the thermometer was touched by COVID positive person.
Suppose as a java programmer, you are given a task to develop an application which could check patient’s temperature without touching thermometer or patient’s body.
To develop this app for IOT device, what do you think Java language should prefer on other languages or not? Justify your answer with solid reason.
