Premium Essay

Database Revision Questions for Computer Science and Technology

In:

Submitted By lokangjohnbosco
Words 803
Pages 4
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 independence, DOL, OML, SOL,
VOL, query language, host language, data sublanguage, database utility, catalog, client/server architecture.
2.2. Discuss the main categories of data models.
2.3. What is the difference between a database schema and a database state?
2.4. Describe the three-schema architecture. Why do we need mappings between?
Schema levels? How do different schema definition languages

Similar Documents

Premium Essay

Advance Issue in Ict

...| | | Semester | : | June 2013 | Course Leader | : | Iznora Aini Zolkifly | Office Location | : | Faculty of Business and Information Technology, Block B1-3A, Leisure Commerce Square | Consultation Hours | : | Tuesday : 2.30 pm – 4.30p.m Thursday : 2.30 pm – 4.30p.m jk | Telephone | : | 03-76277373 | E-mail | : | iznora@unitar.my | Tutors (Optional) | : | | | | | | | Course Synopsis The course contains current issues in Information and Communication Technology that focus on the area of information science, computer networking, multimedia, medical informatics and information security and computer forensic. Exposure through visitation, events, and seminar will be implemented in this course in order to obtain the global technology as it is impacting all walks of life all over the world. Course Objectives The objectives of this course are: * To expose students to the various area in IT through visitation and events. * To provide a series of seminar in order to gain current issues and trends in ICT. * To develop a knowledgeable and skilled computer professionals guided by the needs of companies and employers. Learning outcomes * Present verbally on current issues in different areas of information and communication technology through group presentation and discussions. * Summarize the latest technology offered in order to solve the real world problem. * Document the finding on current issues and trends in ICT from the series of seminar attended...

Words: 832 - Pages: 4

Premium Essay

Survey Book

...other professions, is dynamic. This dynamism is in response to Information and Communication Technology (ICT). With the introduction of ICT into the field of library and information science (LIS), it has become imperative that library and information science practitioners possess the skill needed to function effectively in an ICT environment. Lawal (2002), quoting Francis Bacon, describes a professional as one who has mastered certain specialized intellectual techniques, and adds that it was the intellectual content which came to distinguish the profession from the medieval craft. According to him, increased specialization of skills means that the term “profession” is now used for certain occupations which enjoy prestige and which give esoteric service. Such professions include architects, surveyors, doctors, librarians and information scientists, and engineers, among others. The intellectual work of librarians derives from the application of scientific principles in organizing, storing, retrieving, and disseminating information. In recent years, the library profession has been affected by developments in ICT. Igbinosa (2007) notes that advances in ICT have changed the paradigm of librarians' work from information storage to one of access to world literature resources using electronic databases, the Internet, and other digital resources. According to Omekwu (2005), digital technology has revolutionized the information acquisition, storage, and retrieval processes. The application...

Words: 2773 - Pages: 12

Premium Essay

Nt1330 Unit 1 Assignment

...authenticated, the admin can now create the question and store the answer for the same in the database. The admin can also add students, subjects and tests for those subjects. The admin should keep all the keywords present in the answer in capital letters. Thus admin should store the answer with a subject expert helping him to identify the keywords present in the answer. The question will be displayed to the user and the answer stored will be used...

Words: 1174 - Pages: 5

Premium Essay

Oral Communication

...[pic] FACULTY OF BUSINESS AND MANAGEMENT SEMESTER 1 / 2011 OUMH1103 LEARNING SKILLS FOR OPEN DISTANCE LEARNERS MATRICULATION NO : 891214145494001 IDENTITY CARD NO. : 891214145494 TELEPHONE NO. : 010-2482356 E-MAIL : hema_1412@yahoo.com LEARNING CENTRE : NEGERI SEMBILAN LEARNING CENTER TABLE OF CONTENTS |INTRODUCTION |3 | |FINDINGS |6 | |CONCLUSION |10 | |RECOMMEDATIONS |10 | |APPENDIX |11 | 1. INTRODUCTION The purpose of this report is to study the challenges faced by online learners which are not faced by traditional learners and it also discusses the three main skills that are vital for online learners. Online learning is more to the impression of self-study. Online learning is a multifaceted task that holds great perspective as a teaching and learning approach that colleges and universities may tactically hire to accomplish wide-ranging...

Words: 2821 - Pages: 12

Premium Essay

Thesis

...GAME THEORY Game theory has found its applications in numerous fields such as Economics, Social Science, Political Science, and Evolutionary Biology. Game theory is now finding its applications in computer science. The nature of computing is changing because of success of Internet and the revolution in Information technology. The advancement in technologies have made it possible to commoditize the components such as network, computing, storage and software. In the new paradigm, there are multiple entities (hardware, software agents, protocols etc.) that work on behalf of different autonomous bodies (such as a user, a business etc.) and provide services to other similar entities. Internet has made is possible for many such geographically distributed antonymous entities to interact with each other and provide various services. These entities will work for their respective owners to achieve their individual goals (maximize their individual payoffs), as opposed to obtaining a system optima (that is socially desirable). This results in an entirely different paradigm of computing where the "work" is performed in a completely distributed/decentralized fashion by different entities where the primary objective of each entity is to maximize the objective of its owner. Therefore, it is important to study traditional computer science concepts such as algorithm design, protocols, and performance optimization under a game-theoretic model.  This course aims to provide a basic understanding...

Words: 2068 - Pages: 9

Free Essay

Decision Support System

...Decision Support Systems December 22, 2014 Decision Support Systems Many businesses are faced with situations that need critical analysis, compilation of raw data, circulation of precise documents and effective utilization of computer systems. Frito Lay is an example of a company who implemented various decision support systems (DSS) into their business model. A DSS is a “highly flexible and interactive IT system that is designed to support decision making when the problem is not structured.” (Haag, Cummins p.162) Managers require information to guide their organization in the right direction. DSS increases productivity, efficiency, and enhances understanding of business processes. DSS helped carve their business success, facilitate management making qualitative decisions, and turned their raw data into valued information that was needed by employees and management. DSS assist the management and employees of Frito-Lay by delivering statistical and data retrieving systems. Employees of Frito-Lay also used DSS systems in searching information that was germane to their job function. The three main components of a DSS are model management, data management and interface management. “The model requests the information from the data management component, analyzes the information, and sends the results to the user interface management component, which in turn passes the results back,” (Haag, Cummins p.163) to the user. There are many types of DSS systems and hybrid DSS systems...

Words: 1819 - Pages: 8

Premium Essay

Okay

...discovered at SoftGuide probably lay behind the decision…. The article said that SystemX feared that SoftGuide’s data-processing system was inadequate to handle the new products planned for the SoftGuide sales staff. SystemX officials were also concerned about the 30 percent annual turnover among sales personnel… Tabrez A., SoftGuide CEO, responded that the SoftGuide’s data-processing was quite competent and has absorbed at least one new product a month for two years.” Questions: a. Why should SystemX be so concerned about the capabilities of SoftGuide’s data-processing? b. What competitive advantages to a Training and Consultancy services company may be provided by an information system? Case 2 Professor Challenges Basic Assumption about Planning and Control Professor A. Van Cauwenbergh of Antwerp University, in a paper presented at the Tenth Anniversary Conference of the European Institute for Advanced Studies in Management, presented four revisions to traditional Management Theory. In summary, the revisions are: (1) The initiative for the renewal and adjustment of the activities of a firm should come from the different levels in the management hierarchy. “Strategy is not a privilege of top management”. (2) Firms, especially big firms, are incoherent systems (goals of the different component...

Words: 3343 - Pages: 14

Premium Essay

Testing

...discovered at SoftGuide probably lay behind the decision…. The article said that SystemX feared that SoftGuide’s data-processing system was inadequate to handle the new products planned for the SoftGuide sales staff. SystemX officials were also concerned about the 30 percent annual turnover among sales personnel… Tabrez A., SoftGuide CEO, responded that the SoftGuide’s data-processing was quite competent and has absorbed at least one new product a month for two years.” Questions: a. Why should SystemX be so concerned about the capabilities of SoftGuide’s data-processing? b. What competitive advantages to a Training and Consultancy services company may be provided by an information system? Case 2 Professor Challenges Basic Assumption about Planning and Control Professor A. Van Cauwenbergh of Antwerp University, in a paper presented at the Tenth Anniversary Conference of the European Institute for Advanced Studies in Management, presented four revisions to traditional Management Theory. In summary, the revisions are: (1) The initiative for the renewal and adjustment of the activities of a firm should come from the different levels in the management hierarchy. “Strategy is not a privilege of top management”. (2) Firms, especially big firms, are incoherent systems (goals of the different component...

Words: 3363 - Pages: 14

Premium Essay

Accounting Principles Related to Nursing

...operation, it is critical to document each patient’s condition and history of care, to ensure the patient receives the best available care. The medical record documents the care of the patient and can immediately be accessed, updated, and passed among the interdisciplinary team of caregivers. The Emergency Department is the initial passageway to the hospital for most patients. Electronic documentation is a patient’s health information including medications, allergies, past and present illnesses, and family history can be gathered upon their initial presentation and up-to-the minute revisions can be made by the healthcare team throughout their hospital stay. The Electronic Medical Record/Charting can be designed to hold collaborative information from all providers that are involved in the patients’ care. With each subsequent visit thereafter, the patient’s demographic, insurance, and health history database will automatically pre-fill the electronic template alleviating nurses of time restraints associated with paper documentation. This allows for quick updates to the patient’s profile if necessary. Patients may suffer drastic consequences when a chart is misread, lost, or switched accidentally. Electronic documentation provides chart legibility, clarity, error minimization, speed of accessibility, and up to the minute progression of care provided which are distinct advantages over...

Words: 3066 - Pages: 13

Premium Essay

Report

...| Carmelia Bell | Portfolio | | Bachelors of Science in AccountingDeVry UniversityJune 2013 | | | | | Table of Contents * Personal Mission Statement * Elevator Speech * Education * DeVry Plan of Study * DeVry Course Description and Academic History * Resume * Reference List * Career Path Section Mission Statement My mission is to continue to drive for excellence throughout my life. I will ensure that I graduate from school with my Bachelors of Science in Accounting degree from DeVry University. My mission is to also enroll in Keller’s Graduate school to get my master in Business and Management. My goal is to work for a successful company in a management position to demonstrate my skills and help the company to drive for outstanding results. I am committed to becoming a successful manager in a retail store or corporate level. I am willing to go above and beyond to reach that goal. I am a driven, compassionate, and hardworking individual. My goal is to one day get marry and have a family. I will be loving and proactive in building and maintaining my relationships with my employees, family and friends, so that I may be considered a successful wife, mother, daughter, sister, aunt, friend, co-worker, and manager. Elevated Speech Hi my name is Carmelia Bell. I am a senior at DeVry. I’m graduating June 30 of this year. I have 4 years of an assistant manager experience. I’m currently working as a team lead at...

Words: 3474 - Pages: 14

Free Essay

Project

...DESIGN AND IMPLEMENTATION OF ONLINE ENTRANCE EXAMINATION (A CASE STUDY OF CARITAS UNIVERSITY ENUGU) BY NAME: ABI THOMAS AUGUSTINE REG NO: CST/2009/378 IN PARTIAL FULFILLMENT OF BACHELOR OF SCIENCE DEGREE IN COMPUTER SCIENCE/ INFORMATION TECHNOLOGY FACULTY OF NATURAL SCIENCES EXAMINATON CARITAS UNIVERSITY, AMORJI-NIKE ENUGU JULY 2013. i CERTIFICATION This is to certify that this project DESIGN AND IMPLEMENTATION OF ONLINE ENTRANCE EXAMINATION (A CASE STUDY OF CARITAS UNIVERSITY, ENUGU) was carried out by; -------------------------------------------- ---------------------- NAME OF STUDENT SIGNATURE ------------------------------DATE ii APPROVAL PAGE This is to certify that this research was carried out by Abi Thomas Augustine Reg. No: CST/2009/378 of the Department of Computer Science/Information Technology , Faculty of Natural Sciences Caritas University Amorji-Nike, Enugu State. ____________________ CHIZOBA EZEME (MRS) SUPERVISOR _______________ DATE _______________________ ARINZE NWAEZE (Ph.D) HEAD OF DEPARTMENT _______________ DATE ____________________ __ Dr. BONIFACE EKECHUKWU EXTERNAL EXAMINER _______________ DATE iii DEDICATION This work is dedicated to the Almighty God for giving me the knowledge, wisdom and understanding in the pursuit of my academic career. I also extend this to my late father Chief A. E. Abi, mum, brother and sisters for all you love. May God bless you all. iv ACKNOWLEDGEMENT I want to use this medium to express my immeasurable...

Words: 18414 - Pages: 74

Free Essay

Linux Chapter 1

...Chapter 1 Introduction to Linux At a Glance Class Notes Table of Contents • Overview • Objectives • Teaching Tips • Quick Quizzes • Class Discussion Topics • Additional Projects • Additional Resources • Key Terms • Technical Notes for Hands-On Projects Lecture Notes Overview Linux technical expertise is essential in today’s computer workplace as more and more companies switch to Linux to meet their computing needs. Thus, it is important to understand how Linux can be used, what benefits Linux offers to a company, and how Linux has developed and continues to develop. In the first half of this chapter, you will learn about operating system terminology and features of the Linux operating system, as well as the history and development of Linux. Later in this chapter, you will learn about the various types of Linux and situations in which Linux is used. Chapter Objectives In this chapter, you will learn to: • Understand the purpose of an operating system • Outline the key features of the Linux operating system • Describe the origins of the Linux operating system • Identify the characteristics of various Linux distributions and where to find them • Explain the common uses of Linux in industry today Quick Quiz 1 1. What term is used to describe a running program on Linux? a. Application b. Process c. Runtime d. Project 2. What is represented...

Words: 3777 - Pages: 16

Free Essay

Colonial Rulw

...DESIGN AND IMPLEMENTATION OF ONLINE ENTRANCE EXAMINATION (A CASE STUDY OF CARITAS UNIVERSITY ENUGU) BY NAME: ABI THOMAS AUGUSTINE REG NO: CST/2009/378 IN PARTIAL FULFILLMENT OF BACHELOR OF SCIENCE DEGREE IN COMPUTER SCIENCE/ INFORMATION TECHNOLOGY FACULTY OF NATURAL SCIENCES EXAMINATON CARITAS UNIVERSITY, AMORJI-NIKE ENUGU JULY 2013. i CERTIFICATION This is to certify that this project DESIGN AND IMPLEMENTATION OF ONLINE ENTRANCE EXAMINATION (A CASE STUDY OF CARITAS UNIVERSITY, ENUGU) was carried out by; -------------------------------------------- ---------------------- NAME OF STUDENT SIGNATURE ------------------------------DATE ii APPROVAL PAGE This is to certify that this research was carried out by Abi Thomas Augustine Reg. No: CST/2009/378 of the Department of Computer Science/Information Technology , Faculty of Natural Sciences Caritas University Amorji-Nike, Enugu State. ____________________ _______________ CHIZOBA EZEME (MRS) DATE SUPERVISOR _______________________ _______________ ARINZE NWAEZE (Ph.D) DATE HEAD OF DEPARTMENT ____________________ __ _______________ Dr. BONIFACE EKECHUKWU EXTERNAL EXAMINER DATE iii DEDICATION This work is dedicated to the Almighty God for giving me the knowledge, wisdom and understanding in the pursuit of my academic career. I also extend this to my late father Chief A. E. Abi, mum, brother and sisters for all you love. May God bless you all. iv ACKNOWLEDGEMENT I want to use this medium to express my immeasurable...

Words: 18416 - Pages: 74

Free Essay

114 Outline

...ISIT114 SISAT School of Information Systems and Technology Faculty of Engineering & Information Sciences Head of School Associate Professor Rajeev Sharma, Student Resource Centre, Tel: (02) 4221 3491 ISIT114 Object Oriented Programming Subject Outline Spring Session 2014 Consultation Times: Subject Coordinator Telephone Number: Email: Location: Dr. Sifer's consultation times during session: Day Monday Wednesday Subject Organisation: Session: Credit Points Contact hours per week: Lecture Times & Location: Tutorial Day, Time and Location can be found at: Spring Session, Wollongong Campus 6 credit points 2 Hours Lec, 2 Hours Lab Wed 10:30-12:30 67-104 http://www.uow.edu.au/student/timetables/index.html Time 9:00 - 11:00am 1:30 - 3:30pm Dr Mark Sifer 4221 4919 msifer @uow.edu.au 39.219 Students should check the subject's web site regularly as important information, including details of unavoidable changes in assessment requirements will be posted from time to time via MOODLE http://www.uow.edu.au/student/ . Any information posted to the web site is deemed to have been notified to all students. Subject Description: The aims of this subject are to consolidate and extend student's knowledge and skills in structured programming and to introduce them to the concepts and practice of object oriented programming. To achieve this aim the subject will provide students with an opportunity to develop further programming skills and good coding style; develop skills in using the object-oriented...

Words: 2995 - Pages: 12

Free Essay

Eric0427

...practices in the physical sciences december 2011 Acknowledgements This report was the result of a collaborative effort between the Research Information Network, the Institute of Physics, Institute of Physics Publishing and the Royal Astronomical Society. They would like to thank the study authors at the 1) Oxford Internet Institute, University of Oxford, 2) Department of Information Systems, London School of Economics, 3) UCL Centre for Digital Humanities and the Department of Information Studies, University College, London, 4) e-Humanities Group, Royal Netherlands Academy of Arts & Sciences (KNAW) and Maastricht University, and 5) Oxford e-Research Centre (OeRC), University of Oxford. The main authors for this report are: Eric T. Meyer, Monica Bulger, Avgousta Kyriakidou-Zacharoudiou, Lucy Power, Peter Williams, Will Venters, Melissa Terras, Sally Wyatt. For the full acknowledgements, please see the project website: www.rin.ac.uk/phys-sci-case contents executive summary Overview method cases Tools and practices of information Information sources 68 69 77 78 4 4 4 4 research software dissemination complexity conclusion and recommendations Information retrieval Information and data management data analysis citation practices dissemination practices collaboration Transformations in practice New questions New technologies recommendations 79 84 84 85 85 86 86 87 88 90 91 92 Glossary Information in the physical sciences background and related literature...

Words: 30909 - Pages: 124