Free Essay

Database Questions Pg.80

In: Computers and Technology

Submitted By paperplane
Words 480
Pages 2
i. FULL NAMES: BAMIGBOLA, AKEEM FEMI ii. PLACE OF BIRTH: ARAMOKO-EKITI DATE OF BIRTH: 25th March, 1987 iii. GENDER: MALE iv. MARITAL STATUS: SINGLE v. NATIONALITY: NIGERIAN vi. STATE OF ORIGIN: EKITI STATE vii. LOCAL GOVT: EKITI-WEST viii. CONTACT ADDRESS: No 5, Oke-Oja Street, Aramoko-Ekiti, Ekiti State, Nigeria. ix. Akeemfastlinks@yahoo.com x. GSM NO: +234 803 765 6313 +234 805 672 8406

xi. ACADEMIC QUALIFICATIONS:

B.Sc. [2011] Bachelor of Science in Computer Science [Second Class Upper]

Ekiti State University, Ado-Ekiti (formerly University of Ado-Ekiti) Ekiti State, Nigeria.

SSCE [2002] Senior School Certificate Examination Victory Royal College, Aramoko-Ekiti, Ekiti State, Nigeria.

TRAINING CERTIFICATIONS PROGRAM:
[2012] Certification in Sun Java Programming: Anthiis Integrated System Limited Ado-Ekiti, Ekiti State, Nigeria.

[2011] Certification in VB.net Programming: Topstock Computer Technology Offa, Kwara State, Nigeria.

PERSONAL SKILLS: • Software Developer: Writing programming code such as Vb.net, Java and PHP. • Excellent knowledge of computer like Microsoft word, Excel, Access, Database computation and internet.

WORK EXPERIENCES:
NYSC [2012] National Youth Service Corps. Department of Planning, Research & Statistics, Ministry of Information: Uyo, Akwa-Ibom State, Nigeria. Job Responsibilities: Research, evaluate and recommend new technologies for service delivery and improvement. Also Design, develop, program, install, implement, conduct research and maintain internal data processing computer systems and assist in training less experienced staff.

INEC [2011] Independent National Electoral Commission: Job Responsibilities: Aggregation of Data and Running of Automatic Fingerprint Identification System (AFIS) in 2011 Voters’ Registration Exercise.

SIWES [2009] Students Industrial Work Experience Scheme. Topstock Computer Technology: Offa, Kwara State, Nigeria. Job Responsibilities: Maintaining applications and database by evaluating client needs, analyzing requirements and developing application software.

AWARDS OF EXCELLENCE: INEC [2011] Independent National Electoral Commission: Letter of Commendation for Aggregation of Data and Running of Automatic Fingerprint Identification System (AFIS) in 2011 Voters’ Registration Exercise.

ETISALAT [2010] Scholarship Award for Academic Brilliance.

HOBBIES:
Reading, Writing Computer programs, Travelling and Meeting People.

NAMES AND ADDRESSES OF REFEREES:

-----------------------
CURRICULUM VITAE
Bamigbola, Akeem Femi [B.Sc. Computer science, OCP, IPMP]
No 5, Oke-Oja Street, Aramoko-Ekiti, Ekiti State, Nigeria.
GSM No.: +234 803 765 6313, +234 805 672 8406 E-Mail: akeemfastlinks@yahoo.com

OBJECTIVE:
Looking for a challenging career, where there is scope for demonstrations, always on look out for a positive and bigger outlook, thrive on imagination and passion, Rigorous thinking and boundless curiosity sets levels and standards that exceed expectations.

E-MAIL ADDRESS:

xii.

OCP [2013] Oracle Certified Professional: Oracle Database 11g Administrator Certified Professional.

IPMP [2012] International Project Management Professionals: Certified Project Manager.

PROFESSIONAL QUALIFICATIONS:

II. Dr. Enoch Opeyemi, Department of Mathematics, Faculty of Science, Federal University of Oye-Ekiti, Nigeria. +234 706 646 6859 ope_taiwo3216@yahoo.com

Date: September, 2014

I. Dr. Obayomi Adesoji, Department of Mathematical Sciences, Faculty of Science, Ekiti State University, Nigeria. +234 803 719 7130 aaobayomi@yahoo.com

[pic]

Signature:…...

Similar Documents

Premium Essay

Database Questions Pg.80

...Alex Swan Mr. Davis 9/18/12 Homework Review Questions 3.1 Define the following terms as they apply to the relational model of data: Domain – Set of atomic (indivisible) values. Attribute – it describes a component of the database, such as a table or a field. N-tuple – in mathematics, an ordered set of n elements called its components or coordinates. Relation Schema – It is representation of database highlighting relationships that we have created. Relation State – set of tuples that have the same attributes. Degree of a relation – number of attributes n of its relation schema. Relational Database Schema – Tables, columns and relationships that make up a relational database. Relational database state – is a union of all the individual relation states, whenever the database is changed a new state arise. 3.2 Why are tuples in a relation not ordered? - A Relation is defined as a set of tuples. Mathematically, elements of a set have no order among them: tuples in a relation do not have any particular order. In other words, a relation is not sensitive to the ordering of tuples. Tuple ordering is not part of a relation definition because a relation attempts to represent facts at a logical or abstract level. 3.3 Why are duplicate tuples not allowed in a relation? - Duplicate tuples are not allowed in a relation because it violates the specifications of the relational integrity constraints, particularly the key constraint which states that no two tuples...

Words: 943 - Pages: 4

Premium Essay

Database

...DSS 630 Database Management Systems Theory and Practice COURSE EXPECTATION FORM Course Description: The implementation of technology such as bar codes and scanners enable organizations to accumulate large volumes of data. Further, as the technology to collect data gets cheaper and more simplified, business organizations gather and process a huge amount of data and information. Thus, data management has become a key function for many organizations. Managers need high-quality information to manage change in a turbulent, global environment. Business organizations use information systems to store and retrieve data, the raw material in knowledge-based economies. This repository of data is organizational memory. Databases are an important component of the organizational memory. Thus, information systems professionals should develop a comprehensive understanding of data management principles to fully utilize the organizational role of information technology. This course provides core skills of data management for the relational database management systems. This course will review the theoretical concepts and applications of a modern relational database management system. In addition to a basic theoretical presentation of the database design concepts, students will be required to design and develop a database application using a modern fourth generation language system. This course teaches students data modeling and......

Words: 1374 - Pages: 6

Premium Essay

Database

...Examination Paper: Data Base Management System IIBM Institute of Business Management Semester-I Examination Paper Database Management System Section A: Objective Type (20 marks) • • • This section consists of Multiple Choice Questions & Fill in the blanks / True & False. Answer all the questions. Each Question carries 1 mark. MM.100 Multiple Choices: 1. Structured Query Language (SQL) is the language for working with a. DDBMS b. RDBMS c. Both (a) & (b) d. None of the above 2. Decomposition in database design means a. Breaking one table into multiple tables b. Breaking two table into multiple tables c. Composing multiple tables into one table d. None of the above Locking helps a. Hiding the database b. To solve concurrency problems c. Both (a) & (b) d. None of the above 3. 4. Database optimizer a. Enhances the speed of query execution b. Minimizes the speed of query execution c. Is a program d. None of the above 5. Data is __________. a. Raw facts b. Processed information c. Both (a) & (b) d. None of the above 6. Mobile computing means a. Ability to use computer while on still b. Ability to use computer while on move c. Calculation with the help of mobile d. None of the above IIBM Institute of Business Management 1 Examination Paper: Data Base Management System 7. Operation Data Store (ODS) provides a. Situation sensitive decision support & operational reporting b. Time sensitive decision support & operational reporting c. Both (a) & (b) d. None of the above 8.......

Words: 830 - Pages: 4

Premium Essay

Database

...Client/Server is a system. It is not just hardware or software. It is not necessarily a program that comes in a box to be installed onto your computer’s hard drive. Client/Server is a conglomeration of computer equipment, infrastructure, and software programs working together to accomplish computing tasks which enable their users to be more efficient and productive. Client/Server applications can be distinguished by the nature of the service or type of solutions they provide. Client/Server Computing is new technology that yields solutions to many data management problems faced by modern organizations. Client/Server Computing: An Introduction, features objective evaluations and details of Client/Server development tools, used operating system, database management system and its mechanism in respect of Client/Server computing and network components used in order to build effective Client/Server applications. vi Preface Last but not the least, this work is primarily a joint work with a number of fellow teacher who have worked with us. My parents, wife Meera, and our children, Akanksha and Harsh. I am particularly grateful to Dr. A. P. Singh, Principal, Udai Pratap Inter College, Varanasi; Dr. D. S. Yadav, Sr. Lecturer, Department of Computer Science and Engineering, IET, Lucknow; Dr. A. K. Naiyak, Director IIBM, Patna, former President of IT and Computer Science Section of Indian Science Congress Association; Prof. A. K. Agrawal, Professor and Ex-Head of Department,......

Words: 79055 - Pages: 317

Premium Essay

Database

...the minimum, maximum, sum, and average salary for each job type. Resave lab_04_04.sql as lab_04_05.sql. Run the statement in lab_04_05.sql. SELECT job_id, ROUND(MAX(salary),0) "Maximum",                 ROUND(MIN(salary),0) "Minimum",                 ROUND(SUM(salary),0) "Sum",                 ROUND(AVG(salary),0) "Average"  FROM   employees         GROUP BY job_id;  6. Write a query to display the number of people with the same job. SELECT job_id, COUNT(*)  FROM   employees   GROUP BY job_id;  Generalize the query so that the user in the HR department is prompted for a job title. Save the script to a file named lab_04_06.sql.� SELECT job_id, COUNT(*)  FROM   employees  WHERE  job_id = '&job_title'  GROUP BY job_id;  Oracle Database 10g: SQL Fundamentals I A - 12 Practice 4: Solutions (continued) 7. Determine the number of managers without listing them. Label the column Number of  Managers. Hint: Use the MANAGER_ID column to determine the number of managers. SELECT COUNT(DISTINCT manager_id) "Number of Managers"  FROM   employees;   8. Find the difference between the highest and lowest salaries. Label the column DIFFERENCE.� SELECT   MAX(salary) - MIN(salary) DIFFERENCE  FROM     employees;  If you have time, complete the following exercises:� 9. Create a report to display the manager number and the salary of the lowest-paid employee for that manager. Exclude anyone whose manager is not known. Exclude any groups where the minimum salary is $6,000 or......

Words: 569 - Pages: 3

Premium Essay

Databases

...Why Normalization Failed to Become the Ultimate Guide for Database Designers? Marin Fotache Alexandru Ioan Cuza University of Iasi, Romania Faculty of Economics and Business Administration Dept. of Business Information Systems Blvd. Carol I, nr. 22, Iasi, 700505, Romania Tel: + 40 744 497 654, Fax: + 40 232 217 000 fotache@uaic.ro ABSTRACT With an impressive theoretical foundation, normalization was supposed to bring rigor and relevance into such a slippery domain as database design is. Almost every database textbook treats normalization in a certain extent, usually suggesting that the topic is so clear and consolidated that it does not deserve deeper discussions. But the reality is completely different. After more than three decades, normalization not only has lost much of its interest in the research papers, but also is still looking for practitioners to apply it effectively. Despite the vast amount of database literature, comprehensive books illustrating the application of normalization to effective real-world applications are still waited. This paper reflects the point of 1 view of an Information Systems academic who incidentally has been for almost twenty years a practitioner in developing database applications. It outlines the main weaknesses of normalization and offers some explanations about the failure of a generous framework in becoming the so much needed universal guide for database designers. Practitioners might be interested in finding out (or......

Words: 12110 - Pages: 49

Premium Essay

Pg. 197

...conduct business and keep the organization from going through embarrassing lawsuits do to leaks of information that can be a business related in a personal email. An emails path once it leaves an organization is to go to a certain person or organization basically to the designated receiver. Once an email is sent, it can then be sent to spammers or other destinations unwillingly. Getting some type of Internet Security can limit this tragedy.  That is why it is important for organizations to enforce the policy for non-personal use on computers.  Business emails may have more security than personal emails. So if an employee does access their personal information, it could allow spam ware to access all important information on the entire computer database.  2. What is the effect of instant messaging on organizational networks? What are the benefits and drawbacks of using instant messaging in an organization? Instant messaging is basically a message sent instantly to one or more people that can be personal and allow responses immediately. Using instant message on organizational networks can cause more employees to not focus on work related material. Also if they are monitoring employees Systems then they will be able to see those sending messages and read the conversations.  Managers worry about the loss of time and employee productivity when employees are focusing on personal rather than company business. When they spend too much on personal things, then the business can......

Words: 985 - Pages: 4

Premium Essay

Database Revision Questions for Computer Science and Technology

...Review Questions 24 I Chapter 1 Databases and Database Users 1.1. Define the following terms: data, database, DBMS, database system, database catalog, Program-data independence, user view, DBA, end user, canned transaction, deductive Database system, persistent object, meta-data, transaction-processing application. 1.2. What three main types of actions involve databases! Briefly discuss each. 1.3. Discuss the main characteristics of the database approach and how it differs from traditional file systems. 1.4. What are the responsibilities of the DBA and the database designers? 1.5. What are the different types of database end users? Discuss the main activities of each. 1.6. Discuss the capabilities that should be provided by a DBMS. Exercises 1.7. Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2. 1.8. What is the difference between controlled and uncontrolled redundancy? Illustrate with examples. 1.9. Name all the relationships among the records of the database shown in Figure 1.2. 1.10. Give some additional views that may be needed by other user groups for the database Shown in Figure 1.2. 1.11. Cite some examples of integrity constraints that you think should hold on the Database shown in Figure 1.2. Chapter 2 Database System Concepts and Architecture Review Questions 2.1. Define the following terms: data model, database schema, database state, internal Schema, conceptual schema, external schema, data......

Words: 803 - Pages: 4

Free Essay

Database Questions Pg.80

...This document has been removed....

Words: 480 - Pages: 2

Premium Essay

Database Design Chapter 1 Review Questions

...organize data in a database. Its functions are data dictionary management, data storage management, data transformation and presentation. 5. Structural independence exists when you can change the file structure without affecting the application's ability to access the data. If it did not exist, any change to a files structure would require several extra steps for every single record in the file. 6. Data is raw facts that have not been processed. Information is data that has been processed and given context. Databases help to organize the manipulation of data to create information by providing an organizational structure that makes relationships and connections between data explicit. 7. The DBMS serves as the intermediary between the user and the database. Some advantages are improved data sharing, data security, data access, decision making, and increased end-user productivity. Disadvantages are increased costs, management complexity, maintaining currency, vendor dependence, and frequent upgrade cycles. 8. The databases are single user database, desktop database, multiuser database, workgroup database, enterprise database, centralized database, distributed database, operational/transactional/production database, and data warehouse. 9. The main components are hardware, software, people, procedure, and data. 10. Metadata is data about data, through which the end user data is integrated and managed. 11. A poorly or incorrectly designed database can......

Words: 480 - Pages: 2

Premium Essay

Database

...not matched with left relation are left as Null TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 2) In order to find out what customers have not placed an order for a particular item, one might use the NOT qualifier along with the IN qualifier. 2) T MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 3) The UNION clause is used to: 3) B A) join two tables together to form one table. B) combine the output from multiple queries into a single result table. C) find all rows that do not match in two tables. D) none of the above. TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 4) SQL statements can be included in another language, such as C or Java. 4) T MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 5) A procedure is: 5) B A) given a unique name. B) called by name. C) stored within the database. D) all of the above. 6) The ________ DBA view shows information about all users of the database in Oracle. 6) B A) DBA_VIEWS B) DBA_USERS C) USERS D) DBA_INDEXES TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 7) User-defined functions can improve system performance because they will be processed as sets rather than individually, thus reducing system overhead. 7) T ESSAY. Write your answer in the space provided or on a separate......

Words: 696 - Pages: 3

Premium Essay

Databases

...University of Phoenix Material Determining Databases and Data Communications Read Scenario 1 and Scenario 2 below. Write a paper of no more than 1,500 words in which you respond to the questions designated for both scenarios. Scenario 1: You are a marketing assistant for a consumer electronics company and are in charge of setting up your company’s booth at trade shows. Weeks before a show, you meet with the marketing managers and determine what displays and equipment they want to display. Then, you identify each of the components that need to be shipped and schedule a shipper to deliver them to the trade show site. You then supervise trade show personnel as they set up the booths and equipment. After the show, you supervise packing the booth and all the equipment as well as schedule its shipment back to your home office. When the equipment arrives, you check it into your warehouse to ensure that all pieces of the booth and all the equipment are returned. If there are any problems due to shipping damage or loss, you handle those problems. Your job is important; at a typical show you are responsible for more than a quarter-million dollars of equipment. • In Scenario 1: o You need to track data about booth components, equipment, shippers, and shipment. List typical fields for each type of data. Provide an example of two relationships that you need to track. o Do you need a database system? If not, can Excel® handle the data and the output? What...

Words: 436 - Pages: 2

Premium Essay

Database Desighn Chaper 11 Review Questions

...Chapter 11 Review Questions 1. It is a process that is done locally on a client. The performance tuning will send a query to the server and come back with an answer in a certain amount of time with the little resources being used on the server side. 2. This process is being done on the server with the DBMS. The best way to this is to see how long a response takes from a client machine to the DBMS. The faster the response the better. 3. Performance tuning would mostly be focusing on input/output (I/O). Measuring the performance of how fast data is moved through the disks on the server. You don’t want the server to always use I/O instead they are going to want the data cashed because it doesn’t have to search the disks to retrieve the data. 4. Database statistics are measurements from the DBMS. They usually look at tables, columns and indexes that are being used. By measuring those that can see the performance of the system and make critical decisions to make the system better. 5. There are many different programs out there that can measure database statistics. Some commands that are built in the system to obtain the stats are to use to ANALYZE command. 6. Most measurement that are typical are the number of disk blocks being utilized, also the number of rows and how long the length of the rows are. Also including the smallest value within each column, including column that also are utilizing indexes. 7. They are two different command......

Words: 761 - Pages: 4

Premium Essay

Hands on Database

... HANDS-ON DATABASE AN INTRODUCTION TO DATABASE DESIGN AND DEVELOPMENT Steve Conger Seattle Central Community College Prentice Hall Boston Columbus Indianapolis New York San Francisco Upper Saddle River Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto Delhi Mexico City Sao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo Editorial Director: Sally Yagan Editor in Chief: Eric Svendsen Executive Editor: Bob Horan Product Development Manager: Ashley Santora Editorial Project Manager: Kelly Loftus Editorial Assistant: Jason Calcaño Director of Marketing: Patrice Lumumba Jones Senior Marketing Manager: Anne Fahlgren Marketing Assistant: Melinda Jensen Production Project Manager: Renata Butera Creative Art Director: Jayne Conte Cover Designer: Suzanne Behnke Cover Art: Kheng Guan Toh/Fotolia, Inc Media Editor: Denise Vaughn Media Project Manager: Lisa Rinaldi Full-Service Project Management: Chitra Sundarajan/Integra Software Services Pvt. Ltd. Printer/Binder: Edwards Brothers Cover Printer: Lehigh-Phoenix Color/Hagerstown Text Font: Palatino Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microsoft Corporation. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation. Copyright © 2012 Pearson Education, Inc., publishing as Prentice Hall, One Lake Street, Upper......

Words: 70521 - Pages: 283

Premium Essay

80/20 Rule

...Learning Game Project: 80/20 Rule Report Table of Contents I. 80/20 Rule Concept: An Overview…………………………………..……………pg. 1 II. 80/20 Rule Concept: Importance and Implications in Business.....……………….pg. 1 III. Learning Game Description…………………………………….…………………pg. 1 IV. Resources………………………………………………………………………….pg. 2 I. 80/20 Rule Concept: An Overview The 80/20 rule is a well-known, theory that can be broadly applied to many different situations and areas of study. It originates from an observation made by Vilfredo Pareto, an Italian economist who noted that eighty percent of the land in Italy belonged to only twenty percent of the people. The idea, also known as Pareto’s principle, preaches that in anything (situation, process, event, etc.) just a small percentage is truly important while the rest is of little significance. Furthermore, it is crucial to note that the exact proportions or numerical values associated to this ideology are irrelevant. In essence, the premise upon which the principle is based assumes most results or outcomes stem from very few causes. Simply, the majority or best results that can be produced are derived from specific efforts or actions. II. 80/20 Rule Concept: Importance and Implications in Business In the business world, a strategy chosen and implemented by an enterprise is especially important in successfully achieving the outlined goals. Furthermore, the strategy should be one that is built upon a sound understanding of......

Words: 1024 - Pages: 5

Strike Back | the greatest showman | Watch Movie