Premium Essay

Database Theory Exam 1

In:

Submitted By themouse
Words 8796
Pages 36
CHAPTER 1

1 The word ________ indicates that the facts have not yet been processed to reveal their meaning.

a. data b. dictionary c. raw d. information correct: c 2 Processed data, or ________, can be used as the foundation for decision making.

a. information b. DP c. raw data d. queries correct: a 3 Raw data must be properly ________ for storage, processing, and presentation.

a. sorted b. grouped c. formatted d. arranged correct: c 4 What is a key characteristic of knowledge?

a. "new" Knowledge can be derived from "old" knowledge. b. It is assembled from raw data. c. It cannot be duplicated. d. It exists in a vacuum. correct: a 5 Accurate, relevant, and timely ________ is the key to good decision making.

a. relationships b. data c. processing d. information correct: d 6 What is the name for data about data?

a. unique data b. superdata c. metadata d. raw data correct: c 7 Data management is a discipline that focuses on ________.

a. the proper generation, storage, and retrieval of data b. the help items to be used by end users

c. the management of end users d. the proper generation, storage, and retrieval of information correct: a 8 What is a benefit of using a DBMS?

a. It provides seamless Internet access to database data. b. It creates automatic backups. c. It helps create an environment for end users to have access to more data. d. It provides full security to data using private/public key encryption. correct: c 9 The ________ manages interaction between the end user and the database.

a. DBMS b. DP c. DM query engine d. DBMQ correct: a 10 The ________ receives all application requests and translates them into the complex operations required to fulfill requests.

a. workgroup b. DP c. query

d. DBMS correct: d An ad hoc query is a ________.

a. spur of the moment question b. pre-planned question c. pre-scheduled question d. question that will not

Similar Documents

Premium Essay

It and Its Scope

...UNIVERSITY OF MUMBAI Bachelor of Engineering Information Technology (Third Year – Sem. V & VI) Revised course (REV- 2012) from Academic Year 2014 -15 Under FACULTY OF TECHNOLOGY (As per Semester Based Credit and Grading System) University of Mumbai, Information Technology (semester V and VI) (Rev-2012) Page 1 Preamble To meet the challenge of ensuring excellence in engineering education, the issue of quality needs to be addressed, debated and taken forward in a systematic manner. Accreditation is the principal means of quality assurance in higher education. The major emphasis of accreditation process is to measure the outcomes of the program that is being accredited. In line with this Faculty of Technology of University of Mumbai has taken a lead in incorporating philosophy of outcome based education in the process of curriculum development. Faculty of Technology, University of Mumbai, in one of its meeting unanimously resolved that, each Board of Studies shall prepare some Program Educational Objectives (PEO‟s) and give freedom to affiliated Institutes to add few (PEO‟s) and course objectives and course outcomes to be clearly defined for each course, so that all faculty members in affiliated institutes understand the depth and approach of course to be taught, which will enhance learner‟s learning process. It was also resolved that, maximum senior faculty from colleges and experts from industry to be involved while revising the curriculum. I am happy to state...

Words: 10444 - Pages: 42

Premium Essay

Syllabus

...Marks s 1. CSE311 Data Structures 3 1 0 4 4 50 2. 3. 4. 5. 6. 7. 8. 9. Total Second Year -Fourth Semester Sr.No Paper Code 1. 2. 3. 4. 5. 6. CSE411 CSE461 CSE412 CSE462 CSE414 CSE464 Subject Title Scheme of Teaching L 3 0 3 0 3 0 T 1 0 1 0 1 0 P 0 3 0 3 0 3 Hours 4 3 4 3 4 3 Credit 4 2 4 2 4 2 University External Marks 50 50 50 CSE361 CSE313 CSE363 AS301 EC316 EC366 EC317 EC367 Data Structures (Practical) Peripheral Devices & Interfaces Hardware Lab (Practical) Engineering Mathematics – III Digital Electronics Digital Electronics (Practical) Microprocessors Microprocessors (Practical) 0 3 0 3 3 0 3 0 15 0 1 0 1 1 0 1 0 5 3 0 2 0 0 2 0 2 09 3 4 2 4 4 2 4 2 29 2 4 1 4 4 1 4 1 25 50 50 50 50 250 Internal Total Sessional Marks 50 50 50 50 50 50 50 50 50 450 100 50 100 50 100 100 50 100 50 700 7. 8. Total ASC405 CSE 415 Analysis & Design of Algorithms Analysis & Design of Algorithms (Practical) Database Management System Database Management System (Practical) Object Oriented Programming Object Oriented Programming (Practical) Cyber Law & IPR Computer Architecture & Organization Internal Total Sessional Marks 50 100 50 50 50 50 50 50 100 50 100 50 3 3 15 0 1 4 0 0 9 3 4 28 3 4 25 50 50 250 50 50 400 100 100 650 2 Scheme of Examination of B.E. in Computer Science & Engineering Third Year - Fifth Semester Sr. Paper Subject Title Scheme of Teaching Univesity Internal Sessional Code External L T P Hou Credit Marks Total Marks rs s 1. CSE511...

Words: 14784 - Pages: 60

Premium Essay

Grading System

...technology are essential for national development and progress. The State shall give priority to research and development, invention, and their utilization, and to science and technology education according to the 1987 Philippine Constitution (Article XIV, Section 10). Since computer power was the critical resource, efficiency of processing became the main goal. Emphasis was placed on automating existing process such as purchasing or paying, often within single department as indicated by Jeffrey A. Hofer on Modern System Analysis and Design (1996). A major purpose of a database system is to provide users with an abstract view of data. That is the system hides certain details of how the data are stored and maintained as stated by Abraham Silberschatz, Database System Concepts (1999). A database is an organized collection of facts and information. An organizations database can contain facts and information on customers, employees, inventory, competitors, sales information and much more. Most Managers and executive...

Words: 1009 - Pages: 5

Premium Essay

Sexyshubham

...BCO1102 Information Systems for Business 2014 Semester 1 Prepared by Paul Darbyshire Prepared by Paul Darbyshire Welcome Welcome to BCO1102 Information Systems for Business for Semester 1, 2014. For the vast majority of you it will be a compulsory unit of study as it is part of the Business Core in all undergraduate Bachelor of Business degrees. The major focus of this unit is on how computer- based information systems can support decision making in organizations and businesses. Those decisions often need to be made by professionals who come from discipline areas you are studying such as accounting, management, information systems or marketing. One of the most important elements of an information system is people, so all of us need to know what role we can play and what role information and communication technologies (ICT) can play in supporting decisions. This unit will look at the theoretical side of information systems as well as personal productivity tools such as spread sheets and databases. In addition we will look at global trends in information systems and in particular the emerging use of Cloud Computing and Social Networking, which is sometimes called Web 2.0. The unit of study requires the textbook Introduction to Information Systems by Rainer, Prince and Cegielski 5th Edition. The textbook is used for the theory and some of the practical work in tutorials. All reading for this subject during the semester is assigned from this textbook. Feedback from previous...

Words: 3033 - Pages: 13

Free Essay

Management

...2002 PhD. Core Exam: Part 1 MIS Dept, Univ. of Arizona, Tucson, AZ Tuesday, May 28, 2002 Venue: Room 214, McClelland Hall Time: 9:00 AM – 1:00 PM INSTRUCTIONS: (Please read them carefully before you begin the exam) 1. The exam will begin promptly at 9:00 a.m. and end promptly at 1:00 p.m. No extensions are allowed. 2. This exam consists of 6 questions. You are required to answer all of them. Please allocate roughly 30 minutes per question and leave some time for checking your answers. 3. Each question is worth 100 points. 4. For each question, state your assumptions clearly. 5. If you are writing by hand in a blue book, please answer each question in a separate blue book. If you are using a word processor, please make sure that you start each new question on a new page. You are allowed to use combinations of the blue book and a word processor file for answering questions. 6. At the top of each question that you answer, please identify two things: ▪ The number of the question that you are answering and ▪ The code name given to you at the beginning of the exam. Do not write your real name anywhere on the exam, and use only your code name. 7. Please make two (2) diskette copies of the files containing your answers if you are using a word processor. Please turn in both diskettes, along with your blue book answers and the exam questions, to the proctor at the end of the exam. 8. You are allowed to take a restroom or lunch break only if no one else is already...

Words: 3203 - Pages: 13

Premium Essay

International Financial Organisations

...in the international system in the post World War II era. Emphasis will be placed on the Bretton Woods institutions, namely the International Monetary Fund (IMF) and the World Bank (WB). Course Objectives • To show the relationship between the theoretical and practical dimensions of International Financial Organizations in relation to mainstream IR theories and in the subfield of International Relations known as International Political Economy • To introduce students to the major international financial institutions which have impacted on world politics in the post World War II era • To critically assess the roles, contributions, operations and prescriptions of these organizations particularly in the context of developing countries • To locate these organizations within the theoretical realm of the development problematique of the Third World You can realize these objectives by • Regular and punctual lecture and tutorial attendance. • Tutorials are mandatory, roll will be taken and there will be no pandering to absenteeism. Students must attend 75% tutorials otherwise students will be debarred from writing exams. • Frequently assimilating and reviewing lecture notes • Reading all recommended articles and relevant chapters from the designated textbooks before attending class since lectures frequently make references to and offer perspectives on the required readings Classroom Rules • No reading of the newspapers, chatting, eating, surfing the Net, listening...

Words: 2386 - Pages: 10

Premium Essay

Diploma

...Information Technology. This is an introductory module to the current and evolving technologies in today’s computer systems. It introduces information technology concepts and principles. This module explains major components of information systems and demonstrates applications of information systems in business. Students are provided with sophisticated knowledge and necessary skills of information technology. Principles of Information Technology is a course that will provide students with computer skills necessary to be successful in “real world” personal and business situations. Students will use Microsoft Office to learn word processing, desktop publishing, presentation software, spreadsheets, and databases. COURSE OUTCOMES On completion of the course, students will be able to: 1. Demonstrate an understanding of basic information technology concepts and principles 2. Describe major components of information systems 3. Discuss business applications of information systems 4. Use Office application software and apply the computer skills effectively METHODS OF TEACHING Lectures and tutorials/lab practices INSTRUCTIONAL MATERIALS Major Reference Texts: |Author |Date |Title/ISBN |Publisher | |Gary B. Shelly and Misty|2009...

Words: 1347 - Pages: 6

Premium Essay

Training and Development

...School of Psychology 2013 Paper Outline  Faculty of Arts and Social Sciences   PSYC573-13A (HAM) Personnel Training & Development Lecture times/rooms: Thursdays, 09:00am – 10:50am. Room I1.08. Lecturer/Convenor: Donald Cable, Room K1.01. Extn: 8296. Email: dcable@waikato.ac.nz Student consultation hours: Thursdays 14:00-15:00. Other times by appointment. Paper Description The aim of this paper is for you to develop an understanding of the theory, research, and practice relating to training and development (including career development) in organizations. Upon successfully completing this course, you should be able to:     understand, and apply personnel training and development psychology theory and research, and bridge the gap between this and the practice, conduct training needs analyses and evaluate training and development (including career and professional development) initiatives, identify or develop training programs which incorporate sound principles of learning and training transfer, identify and develop the competencies that will support you in pursuing a career as an organizational psychology (or HR) practitioner with a focus on the training and development of individuals in organizations. Blending the exploratory learning aspect of Active Learning with proceduralized instruction, and creating a learning environment within which students are actively encouraged to construct knowledge, this paper includes lectures with associated readings, student seminars...

Words: 2943 - Pages: 12

Premium Essay

Ata308 Unit Outline

...Accounting  Unit Outline 309875 Accounting Theory and Analysis 308 Semester 1, 2014 Unit study package number: Mode of study: Tuition pattern summary: 309875 Internal Lecture: 1 x 1.5 Hours Weekly Workshop: 1 x 1.5 Hours Weekly This unit does not have a fieldwork component. Credit Value: Pre-requisite units: Co-requisite units: Anti-requisite units: Result type: Approved incidental fees: Unit coordinator: 25.0 305229 (v.0) Advanced Financial Accounting 260 or any previous version Nil Nil Grade/Mark Information about approved incidental fees can be obtained from our website. Visit fees.curtin.edu.au/incidental_fees.cfm for details. Lisa Cullen Name: +618 9266 7567 Phone: Lisa.Cullen@curtin.edu.au Email: 407 Building: 406A - Level 4 Room: Consultation times: Tuesday 2-4pm and Thursday 12.30-2.30pm Name: Phone: Email: Building: Room: Name: Phone: Email: Building: Room: Name: Phone: Email: Building: Room: Administrative contact: Name: Phone: Email: Building: Room: Andrew Reynolds +61 8 9266 3602 A.Reynolds@curtin.edu.au 407 426 John Evans +618 9266 3156 John.Evans@curtin.edu.au 407 407 Clive Oliver +618 92667295 Clive.Oliver@curtin.edu.au 407 412 Lesley Hill +618 9266 7295 Lesley.Hill@cbs.curtin.edu.au 407 412  Teaching Staff: Learning Management System: Blackboard (lms.curtin.edu.au) 309875 Accounting Theory and Analysis 308 Bentley Campus 19 Feb 2014 School of Accounting, Curtin Business School Page: 1 of 9 CRICOS Provider Code WA 00301J, NSW 02637B ...

Words: 3789 - Pages: 16

Free Essay

Read Strategy

...American College Dublin Email: academicoffice@amcd.ie 01 676 8939 PROVISIONAL Semester 1, 2012/2013 & December Repeats 2012 Examinations Timetable 10th December to 18th December 2012 MON. 10th Dec 9.00 –11.00/12.00 No. 3, rm 4: IB300 Management Accounting AF300 Management Acc 1 No. 3, rm. 3 LIB203 Digital Revolution IB202 Accounting 1 IB301 Corporate Finance AF301 Corporate Finance AF308 Int Bus Ethics LIB200 Acad Comm AF303 Acc 3 1.00– 3.00/ 4 pm No. 3, rm 4: IB408b Cont Global Challenges** IB403 Ops. Mgmt.. AF304 Business Law 2 AF403 Taxation 2** MIB508 Corp Pol** MBA505 Corp. Pol** 2.00-3.00/ 4pm No. 3, rm 4: IB308 Sust Business 1.00 –3.00/ 4 pm No. 3, rm. 4 LIB201 War & Peace IB303 Int Marketing 1.00 – 3.00/ 4 pm No. 3, rm 4: IB201 Microecomics LIB204 Imagination 1.00 – 3.00/ 4 pm No. 3, rm 4: LIB202 Western Arts IB200 Intro to Management 1.00 – 3.00/ 4 pm 1.00 – 3.00/ 4 pm 2.00 – 3.00/ 4 pm No. 3, rm 4 AF302 HRM IB302 Networks & Databases IB304 Int Law AF406 Int Fin** IB401 Int Fin** TUES. 11th Dec 9.00 – 11.00/12.00 No. 3, rm 4: AF408 Advan Fin Reporting** IB402 IHRM** WED. 12th Dec 9.00 – 11.00/12.00 No. 3, rm 4: MIB501 Int Regulatory** AF400 Fin Reporting** AF405 Theory & Pol** IB409 Theory & Pol** No. 3, rm 3: THURS. 13th Dec 9.00 – 11.00/12.00 No. 3, rm 4: MIB502 Polit Econ** MBA507 Polit Econ** FRI. 14th Dec. 9.00 – 11.00/12.00 No. 3, rm 4 IB405 Int Bus Ethics** MIB500 Cross-Cultural MBA500 Mgm.t** No. 3, rm 3: IB203 Principles of Mark MON. 17th Dec. 9.00 – 11.00/12...

Words: 431 - Pages: 2

Premium Essay

Nt1230 Syllabus

...hours: 4.5 Contact/Instructional hours: 56 (34 Theory Hours, 22 Lab Hours) Prerequisite(s) and/or Corequisite(s): Prerequisite or Corerequisite: NT1210 Introduction to Networking or equivalent Course Description: This course introduces operating principles for the client-server based networking systems. Students will examine processes and procedures involving the installation, configuration, maintanence, troublshooting and routine adminstrative tasks of popular desktop operating system(s) for standalone and network client computers, and related aspects of typical network server functions. Client-Server Networking I Syllabus Where Does This Course Belong? 1st QTR GS1140 NT1110 GS1145 Problem Solving Theory Computer Structure and Logic Strategies for the Technical Professional 2nd QTR NT1210 Introduction to Networking NT1230 Client-Server Networking I MA1210 College Mathematics I 3rd QTR NT1310 NT1330 MA1310 4th QTR PT1420 NT1430 EN1320 5th QTR PT2520 NT2580 EN1420 6th QTR NT2640 NT2670 CO2520 7th QTR NT2799 SP2750 Physical Networking Client-Server Networking II College Mathematics II Introduction to Programming Linux Networking Composition I Database Concepts Introduction to Information Security Composition II IP Networking Email and Web Services Communications Network Systems Administration Capstone Project Group Theory The follow diagram indicates how this course relates to other courses in the NSA program: 1 Date: 8/31/2012 Client-Server Networking...

Words: 1834 - Pages: 8

Premium Essay

Disney

...dynamic ways, • Identify how individuals and groups exert agency and initiate change locally and globally, • Critically examine how socially constructed ideas (such as gender, race, nationality, etc.) generate real effects on human realities, • Appreciate the broader contributions of anthropological research, • Understand how anthropological theories and methods can be applied across multiple disciplines and professions. Class Design: The course is comprised of six modules that consist of five pages; an introductory overview and four topical segments. The modules will be available during the times specified in the syllabus, and each will culminate with a quiz or an exam. Students will be evaluated via participation in online discussions at the end of each page, four quizzes, two exams, and one final project. Assignments, quizzes, and exams will be administered through the Blackboard system. Students are responsible for familiarizing themselves with the Blackboard system, and for ensuring adequate access to a computer and internet for each assessment. Required Readings: Lemert, Charles. 2010. Social Theory: The...

Words: 1430 - Pages: 6

Premium Essay

Anthro 101

...password. You need to use a newer computer with up to date software. For more info: cypresscollege.edu/academics/ distanceeducation Do NOT use Internet Explorer or mobile devices (especially to take tests!). Computers are available on campus, many in the L/LRC: ccllrc.info/ or call 714-484-7193 Advisory: Eligibility for ENGL 100 C.! UC/CSU, AA GE, CSU GE, IGETC! This course introduces the concepts, methods of inquiry, and scientific explanations for biological evolution and their application to the human species. Issues and topics will include, but are not limited to, genetics, evolutionary theory, human variation and biocultural adaptations, comparative primate anatomy and behavior, and the fossil evidence for human evolution. The scientific method serves as foundation of the course.! Duplicate credit not granted for ANTH 101HC or ANTH 201 C.! B. Floyd 30234 http://www.westminster.ac.uk 1 ANTH 101 OL Cypress College Summer 2014 Required Textbooks Essentials of Physical Anthropology: Discovering our Origins 2nd Edition. by Clark Spencer Larsen ISBN 978-0-393-92193 Instructional Objectives:! Upon completion of the course the student will be able to:! •Define anthropology as a discipline, its subfields, and...

Words: 4276 - Pages: 18

Premium Essay

K-12 Grading System

...Chapter I THE PROBLEM AND ITS BACKGROUND Introduction As technology continues to advance, computers are becoming more part of everyday life. Computers are everywhere at work, at school, and at home. Many daily activities either involve the use of or depend on information from a computer. It is also the best solution for providing information and a way of communications in every individual and gives better understanding of some events that can arouse the interest of some particular subject matter. The computerized world is highly efficient one, which processing the big quantities of data and keeping. Computer can be considered as another instrument for developing a system like grading system in every school. This can be a great help to those teachers who are handling many task from providing easier and faster access. Through the advancement of Education System in the Philippines and the application of K-12 system in public and private schools, the systems of grading and recording must be restructured together with the development of the country’s system. K-12 system of assessment critically changed and made assimilation with the international countries. The ideal system focused on the decisive purpose of quality assuring student learning. The said education system is also a standard-based to guarantee the productive teaching of teachers to help the students aspire through their goal. The propagation of technology greatly helps the teachers and students to have efficient...

Words: 4762 - Pages: 20

Premium Essay

Course Description

...3 |Prerequisites: NONE | |Instructor: Chansoo Park |Effective Date: 2. April 2013 | |Contact Info: |Class Hours: Tuesdays, 1:30-5:00 pm (3 and ½ hours) | |chansoo.park@ubc.ca | | |chansoop@sprott-shaw.com | | COURSE DESCRIPTION In today’s information-oriented environment, a manager cannot succeed a thorough understanding of the research process. A manger should understand that adequate and timely information supports business decision making. The student should be able to discuss and explain the basic kinds of research design (exploratory, descriptive, causal / longitudinal, cross-sectional) and their major sources of error; explain database marketing and how it makes use of secondary data; identify the advantages and disadvantages of the major types of qualitative research; discuss how survey and observational methods can be used and their major sources of error; define and differentiate between internal and external validity; explain how measurement and scaling relate to the...

Words: 1557 - Pages: 7