In: Other Topics

Submitted By sallimm
Words 505
Pages 3
QUESTION ONE (20 MARKS) i) The table below shows details of students in a secondary school

Admno | First name | Last name | Class | Maths | English | Average | 2343 | John | Juma | 3 A | 45 | 65 | 65 | 2344 | Mary | Akinyi | 3 B | 54 | 60 | 54 | 2346 | Peter | Kimani | 3 A | 43 | 54 | 75 | 2347 | Micheal | Wafula | 3 B | 65 | 76 | 56 |
Write a query expression that will perform the following a) List all students with first name starting with letter M. (2 marks) b) List all students in class 3 B. (2 marks) c) List all students who scored more than 60 English marks. (2 marks) d) List all students who scored between 50 and 60 Maths marks.(2 marks) e) Identify and describe parts of a report (12 marks)
QUESTIONTWO (20 Marks): i. Explain any four types of queries used in Ms Access (3 marks) ii. You are provided with the following details :

The table below shows details of employees in ABC Computer Ltd.

Pinno | Fname | Iname | Empdate | Basic Salary | Allowance | Deduction | 4352 | Mike | Owiti | 11/02/10 | 45000 | 12000 | 5400 | 4535 | Paul | Mwiti | 12/03/08 | 50000 | 26000 | 6000 | 4536 | Mary | Wambui | 02/03/10 | 44000 | 12000 | 6600 | 4537 | Sam | Juma | 24/08/09 | 35000 | 14000 | 4000 | 4538 | Peter | Koech | 16/04/10 | 60000 | 16000 | 7200 | 4539 | Amina | Abdi | 12/07/09 | 56000 | 9000 | 4500 |

Write an expression that will extract records that satisfy the following conditions. a) Give data types and a primary key suitable for this table. (3 marks) b) List all employees with first name second letter “a”. (2 marks) c) List all employees not earning more than 50,000 basic salaries and more than 15000 allowances. (2 marks) d) List all employees whose Iname ends with letters “witi”. (2 marks) e) List all…...

Similar Documents

Business Ethic 1990. It is one of the companies owned by the family of Sudono Salim under the Salim Group. (Wikipedia 2012. Approx. 1st screen). PT Indofood CBP Sukses Makmur Tbk (“ICBP”) is an established and leading packaged food company in Indonesia. ICBP was established from the Consumer Branded Product (“CBP”) Group of PT Indofood Sukses Makmur Tbk (“ISM”), a holding company listed on the Indonesian Stock Exchange since 1994. ISM provides total food solutions through its four strategic business groups: consumer branded products (CBP), Bogasari (flour producer), agribusiness, and distribution. Through internal restructuring, all business activities of CBP which involves instant noodles, dairy, food seasonings, snack foods, nutrition and special foods, as well as biscuits which was previously under Bogasari Group, has been transferred from ISM to ICBP, which was established in September 2009. The aforementioned restructuring process was completed in March 2010. ICBP principal brands include a variety of brands of instant noodles (Indomie, Supermi and Sarimi), dairy (Indomilk), food seasonings (Sambal Indofood, Sirup Indofood and Bumbu Racik), snack foods (Chitato and Qtela), as well as nutrition & special foods (Promina and SUN). (ICBP. 2012.) The company had a change of pace when the son of Sudono Salim, Anthoni Salim, took over the business, as reported on Saturday, June 26, 2004. (Witular. 2004). Anthoni Salim took control of the management of giant food producer PT Indofood......

Words: 3096 - Pages: 13


...of overtime worked. In Salim case the display of the advertisement is an invitation to treat and as per the law of contracts a person may make an offer which may or may not be accepted the person making the invitation. A person making an invitation to treat is not intended to be bound as soon as it is accepted by the person to whom the statement is addressed, however once the offer is accepted there is a binding contract. Offer : offer is an expression of willingness to contract on certain terms, made with the intention that it shall become binding as soon as it is accepted by the person to whom it is addressed", the "offer". In this case Salim makes the offer through an advertisement and the Fan Company accepts the offer leading to a binding contract between them. Accordingly the contract between Salim and the fan company is binding on both the parties since there is a offer and acceptance by other parties and sum of 1000 RO has been paid as consideration for the sale as well with the assurance the transaction would be complete with three days; Salim has breached the contract by selling the computers for a higher price after accepting the offer from the Fan Company, He could have done so if the Fan Company had failed to complete the transaction by paying the balance payment after 3 days ; Question for mailing or faxing his refusal does not arise since the contract has already been concluded by the parties leading to a binding agreement. Salim has to give Fan Company...

Words: 1525 - Pages: 7

Marketing Research

...No: | Country | Year | Author | Study Title | Journal Title | Variables | Method | Findings | 1 | Jordan | 2007 | Hamza Salim Khraim, Younes Ellyan Al Shoubaki, Aymen Salim Khraim | Factors Affecting Jodanian Consumers’ Adoption of Mobile Banking Services | International Journal of Business and Social Science | *Self-efficacy*Trailability*Compatibility*Complexity*Risk*Relative advantage | Questionnaire | *Self-efficacy has a direct effect on consumers‟ adoption of mobile banking services * Trailability has a direct effect on consumers‟ adoption of mobile banking services * Compatibility has a direct effect on consumers‟ adoption of mobile banking services * Complexity has a direct effect on consumers‟ adoption of mobile banking services*Risk has a direct effect on consumers‟ adoption of mobile banking services*Relative advantage has a direct effect on consumers‟ adoption of mobile banking services | 2 | Malaysia | 2011 | Ching Mun Cheah, Aik Chuan Teo, Jia Jia Sim, Kam Hoe Oon and Boon In Tan | Factors Affecting Malaysian Mobile Banking Adoption: An Empirical Analysis | International Journal of Network and Mobile Technologies | *Perceived usefulness*Perceived ease of use*Relative advantages*Perceived Risk*personal innovativeness | Questionnaire | *Factors such as perceived usefulness (PU), perceived ease ofuse (PEOU), relative advantages (RA) and personal innovativeness (PI) were found positively related with theintention to adopt mobile banking services. However, social...

Words: 342 - Pages: 2

Sustainable Energy

...national and international levels. Pure data driven analytical studies based on recent quantitative research underpinnings strengthen sustainable energy planning to ensure community involvement, inter-generational equity, biological diversity, ecological integrity, and precautionary social and environmental investment. Research Areas • • • • Energy Conservation Renewable Energy Sustainable Mining Community Oil Price Volatility Energy Conservation (a) Rafiq, S. and Salim, Ruhul A. 2010, ‘The Linkage between energy consumption and income: A multivariate cointegration analysis in developing economies,’ International Journal of Emerging Markets, forthcoming. (b) Rafiq, S. and Salim, Ruhul A. 2009. ‘Temporal causality between energy consumption and income in six Asian emerging countries,’ Applied Economics Quarterly, Vol. 55, no. 4, 335-350. Objective: • Identifying energy conservation possibilities in emerging economies by implementing a multivariate demand side time series econometric analysis. (c) Rafiq, S., Salim, Ruhul A. and Bloch, H. 2010, ‘Relationship between oil consumption and economic growth: Is there any energy conservation possibility for China?’ Submitted in: Energy Economics. Objective: • Identifying energy conservation possibilities in China by implementing an extensive multivariate supply and demand side time series econometric analysis. Renewable Energy (a) Rafiq, S., and Alam, K. A. 2010, ‘Why are some emerging economies proactively accelerating......

Words: 704 - Pages: 3

Slumdog Millionaire Oscar the Bombay slums), and how he and his brother Salim befriended the girl Latika (played by Rubina Ali as a child). He refers to Salim and to himself as Athos and Porthos, two of the Three Musketeers. Latika is the third, whose name they never learn. In Jamal's flashbacks, the three children are eventually discovered by Maman (Ankur Vikal) while they are living in the trash heaps. Maman is a gangster who pretends to run an orphanage in order to "collect" street children to beg money for him. Salim is groomed to become a part of Maman's operation and is told to bring Jamal to Maman in order to be blinded by acid, since blind beggars typically earn more money. Salim warns Jamal to escape just in time, and they flee, jumping onto a departing train. Latika catches up and takes Salim's hand, but Salim purposely lets go, and she is recaptured by the gangsters. The two boys make a living, traveling on top of trains, selling goods, picking pockets, and cheating tourists at the Taj Mahal by pretending to be tour guides. Jamal eventually insists that they return to Mumbai to find Latika, which annoys Salim. They eventually locate her, discovering that she has been raised by Maman to become a prostitute whose virginity will fetch a high price. The brothers attempt to rescue her, but Maman intrudes, and in the resulting conflict, Salim draws a gun and kills him. Salim then gets a job with Javed (Mahesh Manjrekar), a rival crime lord. Salim returns to the room where the three are......

Words: 10279 - Pages: 42

Marriage and Sexuality in Midaq Alley

...on the role of women and homosexuality. The characters Salim Alwan and Kirsha are male archetypes whose violent dysfunctional relationships with their wives serve to criticize the greater societal issue of subjugation of women. Meanwhile, Hamida’s various engagements with Abbas, then Salim Alwan, then Ibrahim Faraj, reveal attitudes of extreme disrespect toward women and even unequal treatment for women before the law. Finally, though difficult to sympathize with, Kirsha nonetheless draws the reader’s pity as he is victimized by an anti-homosexual society that prevents him and his family from living fulfilled lives. Kirsha and Salim’s domineering treatment of their wives sheds light on the plight of married women in Egyptian society. Throughout the novel marriage is presented as an emotionless contract rather than a loving mutual relationship. The blunt causal structure of Kirsha’s reasoning in the statement, “I am a man. I am free.” implies that women are inferior to men (Mahfouz 103). Kirsha believes that, almost like a dog, it is his wife’s “duty to obey” so long as her basic needs are met (76) while Salim becomes annoyed simply by his wife’s leaving the home without his permission. Both men consistently resort to physical abuse during arguments and Kirsha openly voices the opinion that men in general ought to “use a stuck” on their wives (102). Furthermore, sexual problems are blamed solely on the wife. Salim seeks to marry Hamida on the pretense of his wife’s......

Words: 1903 - Pages: 8

Slum Dog Milionare

...One of the main characters in the film Slum Dog Millionaire, directed by Danny Boyle is Salim. He is a slum dog who originally comes from the slum in India. He is the brother of Jamal who is a contestant on a game show called: “Who wants to be a millionaire”. In the first round of the game show, Jamal wins 10 million rupees, and only lacks one question from winning 20 million rupees. Since he is a slumdog, and could not possibly know all these answers, they accuse him of cheating. The whole movie shows why he actually know all of the answers, not because he is particularly smart, but because of happenings in his life. I would say that Salim is a round character. When we first see him, he is a little boy in the slum who watches his mother getting brutally killed right in front of his eyes. Salim and his brother Jamal is now on their own. In the start both of the brothers is kind of similar and equal. But after they meet Lateeka and end up in the house with all the future beggars, we can see that the Salim is developing. He is a much more rough character than Jamal, and is quickly given a “leader” position in the house. He is loud and is not afraid of saying what he thinks. When he finds out that they is going to make Jamal blind, he shows a good side of himself and rescues them. When they find Latheeka again after many years separated from her, Salim changes and throws Jamal out of an empty apartment they find. Again we see that he is a “bad” boy. And whole through the film......

Words: 375 - Pages: 2


...Written assignment 2e 1) The three children, Jamal, Salim and Latika are found by Maman - a gangster who tricks and then trains street children into becoming beggars. Maman’s plan is to find the best singing children and then blind them in order to make them more disturbing as singing beggars. One night Jamal and Salim have to attend when this blinding happens to a little boy. At first the boy is being stunned and then placed on a table. While he lies on the table he gets his eyes blinded by burning water. To experience such traumatic things, will inflict psychological effects for life. Maybe you can end up finding it very hard to trust anyone because you have been betrayed so much in your childhood, and maybe that can lead to not seeing anyone in fear of what they will do to you. When you’ve been raised in such a traumatic environment like Jamal and Salim its causes will follow you the whole life, and maybe one day you’ll be unconcerned and careless about everything and anyone around you. And at worst you can end up by doing the same thing to children as you were exposed to when you were a child. In the movie, we also see some of the consequences of being persecuted and maimed as child. Jamal and Salim choose two very different paths in their life. These paths lead to two dissimilar lives. When you think about their whole childhood it’s obvious that the experience at Maman’s place has been a detachment of the boys: Jamal ends up winning the show “Who wants to...

Words: 597 - Pages: 3

Engilsh Essyas , Speeches

...Rajasthan (Ghost Town) village of Kuldhara is a ghost village that has been abandoned since 1800s. It is said to carry a curse of the villagers who migrated to other places. Kuldhara lies about 15 Km west of Jaisalmer in western Rajasthan. The village now lies in ruins. The village was established in 1291 by the Paliwal Brahmins, who were a very prosperous clan and were known for their business acumen and agricultural knowledge. But one night in 1825 all the people in Kuldhara and nearby 83 villages vanished in dark. According to folklore, Salim Singh, the minister of the state, once visiting this village fell for the beautiful daughter of chieftain (Paliwal Brahmin) and wanted to marry her. The minister threatened the villagers that if they did not marry the girl to him, he would levy huge taxes. The chief of the village with those of other 83 adjoining villages decided to abandon and migrate elsewhere as against marrying the girl to Salim Singh. Nobody saw them leave nor did anyone figure where they went, they simply vanished.  3. Roopkund Lake — Uttarrakhand (Skeleton Lake) Roopkund Lake is a glacial lake located at about 5000 meters in the Himalayan ranges of Uttarakhand. In 1942, a forest guard stumbled upon hundreds of human skeletons on the banks of Roopkund. Over the years a number of expeditions by Indian and European scientists were attempted to resolve the mystery of their death. There were several theories suggested to explain these well preserved bones and......

Words: 649 - Pages: 3

The Struggles in India

...the India version of Who Wants to Be a Millionaire? Jamal is one question away from winning the million dollars. But the host can’t believe that a boy from the slums of India can know all of the answers the questions. So he has Jamal arrested and interrogated after being convinced that he’s cheating. The rest of the movie employs flashbacks to narrate the story of Jamil and his brother Salim, and Latika a girl from there slum. Even though Jamals life wasn’t easy his life experiences gave him the knowledge to answer the difficult questions on Who Wants to Be a Millionaire? In the movie Jamal and Salim take totally different paths in life. These paths lead to two opposing outcomes. Jamal ends up winning the Indian version of Who Wants to Be a Millionaire? While Salim dies at the hands of his gangster boss’ employees. Nevertheless, to say that Salim is a bad person who made all the wrong choices, whereas Jamal is the typical good-doer hero of the movie. To understand how they ended up in these different situations, we must first understand the experience that shaped their lives. Salim and Jamal are both orphans who lost their mother on an anti-muslim attack in the slum where they lived. They didn’t have the opportunity to attend school very long. In fact, Jamal only learned to name of two of the Three Musketeers while in school. He referred to Latika as the third musketeer Aramis, he referred to himself as Athos and his brother to Porthos. His ignorance of the......

Words: 764 - Pages: 4

Salim Lims

...Private Contractor versus Government-Operated System on Aviation Security Travis Park Embry-Riddle Aeronautical University ASCI 202: Intro to Aeronautical science I. Summary: Throughout the 1960s, 70s, and 80s, the government developed its security system by introducing inspection devices, canine teams, and etc. However, on September 11, 2001, the most terrible tragedy has changed the United States. It was the most shocking moment in the history, and it changed the whole security system in aviation industry. The Aviation and Transportation Security Act of 2011 (ATSA) was passed, and the federal government created Transportation Security Administration (TSA) and gave direct responsibility of aviation and airport security to TSA. Although the government has done its best for aviation security, the government-owned system has its pros and cons. This research paper would discuss the pros and cons of security system between private contractor and government-owned system. II. Problem: The United States called for more effective security system on the aviation industry, which ensures the safety and protect the country. However, the government agencies do not always succeed its efficiency and created many loss compare to private sector. The ATSA required TSA to run a two-year long pilot program, culminating the Screening Partnership Program (SPP), which allowed airports have private contractors for its security personnel and maintain issue that operate under the TSA......

Words: 651 - Pages: 3

Curriculam Vitae

...Curriculum [pic] Md. Salim Mahmud Address Madhobgonj, Nayarhat, Ashulia, Savar, Dhaka Cell no.:+8801916-360061 E-mail: |Career Objective | Ready to accept any kind of hurdle on the way to be an established employee in this highly competitive world with a blend of hardworking spirit and creative zeal. |Personal Information | Father’s Name: Md.Shahidul Islam Mother’s Name: Salma Akter Present Address: Vill: Madhobgonj, P.O.: Nayarhat, P.S: Ashulia, Savar, Dhaka. Permanent Address:Vill: : Madhobgonj, P.O.: Nayarhat, P.S: Ashulia, Savar, Dhaka. Date of Birth: September 02, 1990 Marital Status: Single Religion: Islam Nationality: Bangladeshi (By birth) |Educational Qualification | - LLB (Legum Baccalawres) Southeast University, Dhaka, Bangladesh Year of passing: 2015 CGPA: Appeared (On the scale of 4.00) - MBA (Masters of Business Administration) Major: HRM Stamford University Bangladesh Year of passing: 2015 CGPA: 3.50 (On the scale...

Words: 347 - Pages: 2

The West Bank

...misguided. Salim, Suad's husband, treats her very well. The same goes for many other Palestinian husbands. Suad is an educated architect. Despite that stereotype that Israeli and Palestinian’s hate each other, the book proves that not to be the case. Suad takes an Israeli man to the hospital due to a heart attack proving that compassion, at times, can override territories. She chooses an Israeli vet for her dog, Nura. 1.1 Suad chose the Israeli vet because she felt that Dr. Hisham was sexist for taking so long to give Nura her vaccines due to her being a female dog. She was able to get better medicine for Nura. This is a big deal because Nura enjoys more political rights than her owner. Suad's West Bank I.D. does not allow her to travel from Ramallah to Jerusalem, although Nura can. Suad paints the picture of the irony that an animal can get a passport quickly, whereas, it can take the Palestinian people years to obtain one. 2. With the occupation of Ramallah under Israel, the curfew made day to day living challenging to say the least. During curfew the Palestinian people lived on lock down in their homes. This was a challenge because there were entire families living in small confined spaces. When curfew would lift the streets would become so crowded and the grocery stores would become chaotic. Suad seemed to find humor with the invasion, however, Um Salim, seemed to be more of a challenge for her. Um Salim would get confused and fret over small things. Um Salim......

Words: 1153 - Pages: 5

Cross Cultural Analysis of Slumdog Millionaire

...each question and as a result of his experiences, how he arrived upon each answer. Through these memories, we see Jamal’s experiences with being orphaned, surviving the slums with his brother Salim and trying to find out what happened to their friend Latika. Slumdog Millionaire was took home numerous awards at the 2009 Oscars including Best Picture. There are many cross cultural psychology concepts that are prevalent in this movie. The idea of collectivism vs individualism is a constant theme throughout the movie. Individualistic cultures are those which have many practices and customs encouraging individuals to prioritize their own individualistic goals and emphasize the ways in which they are distinct from each other as well as being self-sufficient. Collectivist cultures are ones in which interdependent goals are more emphasized people attend to close relationships and group memberships more (pg. 206). India is a country that has both individualistic and collectivistic traits. As seen in Slumdog Millionaire, Jamal very collectivist views. Even after all the time has spent apart from his brother and Latika, he still tries to search for them in the database at the call center he works for. He is unable to find Latika, but is successful in finding his brother, Salim. Despite punching, Salim in the face when they are reunited, Jamal takes Salim’s offer to stay at his place so as to not break their newly mended bond. Furthermore, at the end of the movie Jamal uses his “Phone......

Words: 2119 - Pages: 9

Lesson Plan

... | |Seven 7 |WEAK VERBS | |Lesson aims: To cover WEAK VERBS fel naqis, this lesson will focus on understanding the salim,ajwaf,naqis,and mutal verbs. When would | |the radical letter be omitted. Also discuss the diminutive noun,ie noun which indicate smaller size, fuail. and to continue | |improvement of pronunciation. | | | |Learning Outcomes (what the learner will know/be able to do by the end of the session) | | | |By the end of the lesson, the learner will have learnt about the three different weak verbs and its rules of application, the | |naqis,ajwaf,mutal and the salim verbs when will the radical be dropped and which radical is it effecting from FA AIN LAM. The usage and| |application of the diminutive noun FUAIL. Focus on new vocab dealing with weak verbs. | |How will I achieve this? ...

Words: 508 - Pages: 3

Zelda Williams | [HorribleSubs] Beelzebub-jou no Okinimesu mama - 08 [720p] mkv | Melrose Place (2009)