Free Essay

Salim

In:

Submitted By sallimm
Words 505
Pages 3
INTRODUCTION TO BUSINESS DATABASE CAT 2 JULY 2014
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 employees employed in the year 2009. (2 marks) f) Write a select query statement that will only display Pinno and Empdate. (2 marks) g) What is a split form (2 marks) h) Distinguish between bound and unbound controls in forms (3 marks)

ASSIGNMENT (a) Outline the steps of creating a database in Ms Access (3 marks)
Table 1: Player Player code | Player name | Proffessional club | Goals | University code | P001 | Oliech | Harambee stars | 3 | M1 | P002 | Essien | Barcelona | 4 | M1 | N021 | E’Too | Cameroon | 1 | J1 | E039 | Zidane | Chelsea | 2 | S2 | P004 | Iniesta | Man U | 5 | K9 | C087 | Mariga | Arsenal | | |

Table 2: Teams University code | University | Country | M1 | MKU | Kenya | J1 | JKUAT | Kenya | S2 | STRATHMORE | Kenya | K9 | KEMU | Kenya | (b) How many entity sets does this database contain (3 marks) (c) Identify the most appropriate key to be the primary key for each table then show relationships among the tables. (5 marks) (d) Does the database exhibit referential and entity integrity. Explain (4 marks) (e) Clearly show the data types and field sizes that have been used to create Player table (5 marks)
NB
DO THE CAT2 AND THE ASSIGNMENT THOROUGHLY I WILL COLLECT THEM ON FRIDAY 11TH JULY 2014 AFTER THE LESSON.

Similar Documents

Free Essay

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 requirements...

Words: 651 - Pages: 3

Free Essay

Business Ethic

...|Assignment Cover Sheet for Students | |An assignment cover sheet needs to be included with each assignment. Please complete all detail clearly. | | | | |Name |Garry Jonathan | | | |Student ID |29112169 |Mobile phone |081806527970 | | | | | | | |Course code and title |MM5001 | Business Ethics & Law | | | |Course time and place |Sunday, 2 September 2012 | Jakarta |Program |MBA Jakarta | | | |Lecturer |Karl Knapp | | | | |...

Words: 3096 - Pages: 13

Free Essay

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 identity...

Words: 764 - Pages: 4

Premium Essay

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 we...

Words: 375 - Pages: 2

Premium Essay

Chokra

...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

Free Essay

Marriage and Sexuality in Midaq Alley

...marriage and sexuality in Egyptian society. Through relationships between male and female characters, Mahfouz heavily criticizes traditional societal views 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...

Words: 1903 - Pages: 8

Free Essay

Slumdog Millionaire Oscar

...PGDM 2009-2011 Business Communication II Did Slumdog Millionaire deserve the awards it got? Submitted to: Prof. Virupakshi Goud Submitted by Section C Names: Rachit Bhatia 2009156 Rachita Gulati 2009157 Declaration We, Rachita Gulati and Rachit Bhatia have prepared this report solely for our BC II project. We accept that every coin has 2 facets and we have tried to consider both the perspectives for the said scenario. But then again we might have been biased towards a single perspective. Here we declare that such an instance should be seen as unintentional. While writing this report we have included certain personal opinions and so, it must not be seen as containing derogatory remarks. Place: Nagpur Signatures: Date: 15 December 2009 Acknowledgement We would like to thank Prof. H Virupakshi Goud, Business Communication professor, for giving us this interesting and highly debated topic for the project. This helped us in attaining a lot of information about the film industry, films and awards. This project also helps us to sort out the differing view of people and thus giving a new line of thought to thinking. Thus, it helped us further in realizing the importance of considering all the facets of a situation before giving out a judgement. Abstract Slumdog Millionaire is a 2008 film directed by Danny Boyle based in Mumbai, India’s most popular metropolis. The movie was critically acclaimed in the western world as well as in India. It...

Words: 10279 - Pages: 42

Free Essay

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 would go...

Words: 1153 - Pages: 5

Premium Essay

Cross Cultural Analysis of Slumdog Millionaire

...the people that we are today. These events can occur because of the culture that we are exposed to. This idea is prevalent in the movie Slumdog Millionaire. Slumdog Millionaire tells the tale of 18 year old Jamal, a kid from the slums, “slum dog” of Bombay/Mumbai as he is about to answer the final question on India’s version of “Who Wants to be a Millionaire”. The movie opens on Jamal being interrogated by police who think the only way a kid from the slums could make it that far on the show is by cheating. Throughout the movie we see Jamal get asked 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...

Words: 2119 - Pages: 9

Premium Essay

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...

Words: 704 - Pages: 3

Premium Essay

Social

...Almost everything we do has a set of rules. There are rules for games, for sports and for the workplace. Rules tell us what we should and should not do. Rules made by government are called "laws." Laws control and change our behavior. They are enforced by the courts. If you break a law - whether you like that law or not - you may have to pay a fine, pay for the damage you have done, or go to jail. Ever since people began to live together in society laws have been necessary to hold that society together. Laws help to ensure a safe and peaceful society in which people's rights are respected. The Canadian legal system respects individual rights, while at the same time ensuring that our society operates in an orderly manner. An essential principle is that the same law applies to everybody, including the police, governments and public officials, who must carry out their public duties according to the law. The great importance of law in our life is to organize the daily lives, So the law is important for social control and organized society in controlling the behavior of the members, According to Roscoe Pound, "The law is the science of social engineering, which is achieved through the organization of human relations in the community organizer political or social control through steady systematic use of political power of organized society "by law views passed played a key role in keeping meat and maintain community stability and cohesion by providing justice, security and freedom...

Words: 1525 - Pages: 7

Free Essay

Curriculam Vitae

...Curriculum [pic] Md. Salim Mahmud Address Madhobgonj, Nayarhat, Ashulia, Savar, Dhaka Cell no.:+8801916-360061 E-mail: Salimmahmud217@yahoo.com |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

Premium Essay

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

Premium Essay

Lesson Plan

... |45 Mins |Main Library | |Course |Subject: VERBS | |Arabic Language | | |No. of students |Topic | |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...

Words: 508 - Pages: 3

Free Essay

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...

Words: 649 - Pages: 3