Premium Essay

Data Management - Any Accountholder Can Read the Tuple Corresponding to His Her Own Account Number from the Acnt Detail Relation

In: Other Topics

Submitted By casestudyhelp365
Words 386
Pages 2
Need Answer Sheet of this Question paper, contact aravind.banakar@gmail.com www.mbacasestudyanswers.com
ARAVIND – 09901366442 – 09902787224

DATA MANAGEMENT

CASE STUDY : 1

The physical or internal level organization of a database system is concerned with the

efficient storage of information in the Secondary Storage devices.

The physical to conceptual level mapping must provide the necessary shield to the user.

The basic problem in physical database representation is to select a suitable file system

to store the desired information. The file consist of records and a record may consist of

several fields.

1) What are the typical operations that may be performed on the information stored in

the file?

2) Explain in detail factors affecting physical organization of data?

3) Explain the term ‘Magnetic Tapes’?

4) Define in brief ‘Secondary Storage Devices’?

CASE STUDY : 2

In a medical database with attributes DISEASE, SYMPTOM, TEST (such as

pathological or clinical tests), TREATMENT and MEDICINE, following data

dependencies are assumed to hold.

1) Compute the dependency basis of each attribute?

2) Identify the join dependencies that hold in this database?

3) Does there exist a fourth normal form decomposition that preserves the

dependencies?

4) If so, design a fourth normal form lossless, join decomposition that preserves the

dependencies?

CASE STUDY : 3

1) Anyone can read BANKACNT relation except for the ACCT NO attribute.

2) Any accountholder can read the tuple corresponding to his/her own account number

from the ACNT DETAIL relation.

3) Bank employees can read tuples from ACNT DETAIL relation, but only those

employees whose job is TELLER can update entries in the ACNT DETAIL relation

pertaining to any ACCT NO (this field cannot be modified).

4) Bank employees can read…...

Similar Documents

Premium Essay

Real-Time Fraud Detection: How Stream Computing Can Help the Retail Banking Industry

...multi-purpose technology known as Stream Computing, as the basis for a Fraud Detection solution. Indeed, we believe that this architecture will stimulate research, and more importantly organizations, to invest in Analytics and Statistical Fraud-Scoring to be used in conjunction with the already in-place preventive techniques. Therefore, in this research we explore different strategies to build a Streambased Fraud Detection solution, using advanced Data Mining Algorithms and Statistical Analysis, and show how they lead to increased accuracy in the detection of fraud by at least 78% in our reference dataset. We also discuss how a combination of these strategies can be embedded in a Stream-based application to detect fraud in real-time. From this perspective, our experiments lead to an average processing time of 111,702ms per transaction, while strategies to further improve the performance are discussed. Keywords: Fraud Detection, Stream Computing, Real-Time Analysis, Fraud, Data Mining, Retail Banking Industry, Data Preprocessing, Data Classification, Behavior-based Models, Supervised Analysis, Semi-supervised Analysis Sammanfattning Privatbankerna har drabbats hårt av bedrägerier de senaste åren. Bedragare har lyckats kringgå forskning och tillgängliga system och lura bankerna och deras kunder. Därför vill vi införa en ny, polyvalent strömmande datorteknik (Stream Computing) för att upptäcka bedrägerier. Vi tror att denna struktur kommer att stimulera forskningen, och......

Words: 56858 - Pages: 228

Premium Essay

Database Management System

...Examination Paper of Data Base Management Systems IIBM Institute of Business Management Examination Paper Subject Code- E1010 Database Management Systems Section A: Objective Type (20 marks)    This section consists of Multiple Choice Questions / 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 1 IIBM Institute of Business Management Examination Paper of Data Base Management Systems 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: 831 - Pages: 4

Premium Essay

Certified Public Accounts

...AUDITING AND ASSURANCE STUDY TEXT Copyr i ght ALL RIGHTS RESERVED. Nopartofthispublicationmaybereproduced,storedinaretrievalsystemortransmittedinanyformorbyany means,electronic,mechanical,photocopying,recordingorotherwisewithoutthepriorwrittenpermissionofthe copyright owner. ISBN NO: 9966-760-23-7 © 2009 Strathmore University Press First Published 2009 Strathmore University Press P.O. Box 59857, 00200, Nairobi, Kenya. Tel: +254 (0) 20 606155 Fax: +254 (0) 20 607498 Acknowledgment We gratefully acknowledge permission to quote from the past examination papers of the following bodies: Kenya Accountants and Secretaries National Examination Board (KASNEB). v ACKNOWLEDGMENT ................................................................................................................. ii CHAPTER ONE ........................................................................................................................... 1 ThE GEnEral aUDiTinG EnvironmEnT .............................................................................. 3 CHAPTER TWO ......................................................................................................................... 23 ThE aUDiTor anD ThE CompaniES aCT............................................................................. 25 CHAPTER THREE ..................................................................................................................... 47 aUDiT planninG, ConTrol & rECorDinG (iSa 300)............

Words: 96495 - Pages: 386

Premium Essay

Many Aspects of an Individual's Environment Can Affect His/Her Health.

...The aim of this essay is to examine the notion that many aspects of an individual’s environment can affect his/her health. To do this I (avoid using the personal pronoun “I”) will look at both the physical and social aspects of a person’s environment (the students were asked to consider both the physical and social environment – students who covered only one of these got a low mark) . I will attempt to make clear the links between these elements and will consider how they impact on health. There are numerous factors influencing health, such as age, race, gender to name a few. However, for the purpose of this essay I intend to concentrate on a number of other elements also thought to be key factors influencing health; social class, employment, income, housing and place of residence. (This has set the scene well showing that the student knows that many factors can affect health but then tells us which ones she will concentrate on). Social Class Table 1 Social class classification Higher managerial and professional e.g. company directors, bank managers, senior civil servant e.g. doctors, barristers and solicitors, teachers, social workers Lower managerial and professional e.g. nurses, actors and musicians, police, soldiers Intermediate e.g. secretaries, clerks Small employers and own account workers e.g. publicans, playgroup leaders, farmers, taxi drivers Lower supervisory, craft and related occupations e.g. printers, plumbers, butchers, train......

Words: 2471 - Pages: 10

Free Essay

Business Process Management

... Richard Hull Jan Mendling Stefan Tai (Eds.) Business Process Management 8th International Conference, BPM 2010 Hoboken, NJ, USA, September 13-16, 2010 Proceedings 13 Volume Editors Richard Hull IBM Research, Thomas J. Watson Research Center 19 Skyline Drive, Hawthorne, NY 10532, USA E-mail: hull@us.ibm.com Jan Mendling Humboldt-Universität zu Berlin, Institut für Wirtschaftsinformatik Unter den Linden 6, 10099 Berlin, Germany E-mail: contact@mendling.com Stefan Tai Karlsruhe Institute of Technology (KIT) Englerstraße 11, Gebäude 11.40, 76131 Karlsruhe, Germany E-mail: stefan.tai@kit.edu Library of Congress Control Number: 2010933361 CR Subject Classification (1998): D.2, F.3, D.3, D.1, D.2.4, F.2 LNCS Sublibrary: SL 3 – Information Systems and Application, incl. Internet/Web and HCI ISSN ISBN-10 ISBN-13 0302-9743 3-642-15617-7 Springer Berlin Heidelberg New York 978-3-642-15617-5 Springer Berlin Heidelberg New York This work is subject to copyright. All rights are reserved, whether the whole or part of the material is concerned, specifically the rights of translation, reprinting, re-use of illustrations, recitation, broadcasting, reproduction on microfilms or in any other way, and storage in data banks. Duplication of this publication or parts thereof is permitted only under the provisions of the German Copyright Law of September 9, 1965, in its current version, and permission for use must always be obtained from Springer. Violations are liable to prosecution......

Words: 147474 - Pages: 590

Premium Essay

Data Modeling

...(schemas in the ER model) for a given application, translate ER models into equivalent (as far as possible) relational models. Marc H. Scholl (DBIS, Uni KN) Information Management Winter 2007/08 48 2. The Entity-Relationship Model Introduction Database design (1) Overall goal of DBMS usage: Efficiently develop programs to support given real-world tasks. These programs need to store data persistently. To develop these programs, apply proven methods of software engineering—specialized to support data-intensive programs. Definition (Database Design) Database Design is the process of developing a database schema for a given application. DB design is a subtask of the overall software engineering effort. Marc H. Scholl (DBIS, Uni KN) Information Management Winter 2007/08 49 2. The Entity-Relationship Model Introduction Database design (2) The specification of programs and data is intertwined: The schema should contain the data needed by the programs. Programs are often easy to develop once the structure of the data to be manipulated has been specified. Data, however, is an independent resource: Typically, additional programs will be developed later based on the collected data. Also, ad-hoc queries will be posed against the DB. Marc H. Scholl (DBIS, Uni KN) Information Management Winter 2007/08 50 2. The Entity-Relationship Model Introduction Database design (3) During DB design, a formal model of the relevant aspects of the......

Words: 7024 - Pages: 29

Free Essay

Computer 200 Management

...BIT 200 FINAL STUDY GUIDE • What is the difference between data and information: o Data is a set of discrete, objective facts about events. In an organizational context, data is most usefully described as structured records of transactions. o Information is a message to change the way the receiver perceives something to have an impact on his or her judgment or behavior. • Ex. Your doctor tells you are on the verge of being obese. If you do not want to increase your risk of heart disease or diabetes, then you need to change your eating habits. • What are the reference disciplines in information systems: o Computer Science- Computer Science is the discipline that seeks to build a scientific foundation for topics like computer design, computer programming, information processing, algorithmic solutions or problems, and the algorithmic process itself. o Management Science-The discipline using math and other analyzed methods to help make better decisions in business. Field includes- decision analysis, probability, and math modeling. • Management Science body of knowledge – uses quantitative approaches to decision making and is referred to as management science, operations research, and decisions science. • What do processors do: o A processor interprets computer program instructions and processes data. • Moore’s Law- Moore’s Law state that processor speeds will double every 18 months • The different kinds of storage memory are: kilobyte, megabyte, gugabyte,......

Words: 6356 - Pages: 26

Premium Essay

Why Are Tuples in a Relation Not Ordered?

...of FDs for the relation schema R(A,B,C,D) with primary key AB under which R is in 1NF but not in 2NF. 4. Give a set of FDs for the relation schema R(A,B,C,D) with primary key AB under which R is in 2NF but not in 3NF. 5. Consider the relation schema R(A,B,C), which has the FD B → C. If A is a candidate key for R, is it possible for R to be in BCNF? If so, under what conditions? If not, explain why not. 6. Suppose we have a relation schema R(A,B,C) representing a relationship between two entity sets with keys A and B, respectively, and suppose that R has (among others) the FDs A → B and B → A. Explain what such a pair of dependencies means (i.e., what they imply about the relationship that the relation models). Answer 19.1 1. Let R be a relational schema and let X and Y be two subsets of the set of all attributes of R. We say Y is functionally dependent on X, written X → Y, if the Y-values are determined by the X-values. More precisely, for any two tuples r1 and r2 in (any instance of) R πX(r1) = πX(r2) [pic]πY (r1) = πY (r2) 2. Some functional dependencies are considered trivial because they contain superfluous attributes that do not need to be listed. Consider the FD: A → AB. By reflexivity, A always implies A, so that the A on the right hand side is not necessary and can be dropped. The proper form, without the trivial dependency would then be A → B. 3. Consider the set of FD: AB → CD and B → C. AB is obviously a key for this relation since AB →......

Words: 1307 - Pages: 6

Premium Essay

Human Resource Management

...this opportunity to enrich my knowledge on banking system. I have taken this opportunity to apply my knowledge, which I have learnt from my theoretical classes. I have tried my level best to present my experience of the practical orientation in this report. This report is also a requirement of my BBA program. 1.2 Objective of the Study Broad Objectives 1. The objective of the study is to gather practical knowledge regarding banking systems and operations, especially for loan and advances. 2. To gather the knowledge and idea about the business arena where there are so many scope for using loan and advances from the point of view of practical orientation and the legal procedures and accounting systems are used . 3. Use of AIS in the Banking sectors, Especially on Loans & Advances. 4. Proper Utilization of Resources & capabilities by using Loans & Advances. 5. To generate and obtain the knowledge and proper ideas regarding the accounting field in case of accounting performance on loans and advances by maintaining the GAAP and IAS where accounting information will be highlighted and reflected very clearly through the financial statement and balance-sheet. 6. Accounting procedures for the legal settlement of Investment Mechanism will be highlighted very clearly so that the proper out comes from here may be realized. 7. To gather knowledge about banking companies operations on Investment Mechanism in practical......

Words: 16328 - Pages: 66

Free Essay

Big Data

...database. This unique identity is typically implemented via a unique, system-generated object identifier (OID).Immutable – They do not change. An OID can be used only once.The main property required of an OID is that it be immutable; that is, the OID value of a particular object should not change. an ODMS must have some mechanism for generating OIDs and preserving the immutability property. It is also desirable that each OID be used only once; that is, even if an object is removed from the database, its OID should not be assigned to another object. These two properties imply that the OID should not depend on any attribute values of the object, since the value of an attribute may be changed or corrected. . The three most basic CONSTRUCTORS are ATOM, STRUCT (or tuple), and COLLECTION. . One type constructor has been called the atom constructor. This includes the basic built-in data types of the object model, which are similar to the basic types in many programming languages: integers, strings, floating point numbers, enumerated types, Booleans, and so on. They are called single-valued or atomic types, since each value of the type is considered an atomic (indivisible) single value. A second type constructor is referred to as the struct (or tuple) constructor. This can create standard structured types, such as the tuples (record types) in the basic relational model. Collection (or multivalued) type constructors include the set(T), list(T), bag(T), array(T), and......

Words: 2026 - Pages: 9

Premium Essay

Account Management

...student at the Art Institute. Market research is the gathering and evaluation of data regarding consumers' preferences for products and services. Advertising is the activity of attracting public attention to a product or business, as by paid announcements in the print, broadcast, or electronic media. When I asked my sister if I could get a job working for the government after I graduate; she took me to her job only to find out that market research is not advertising. Though advertising does do market research some companies feel a business marketing degree is better for their services. However, I can take some business classes, and become an intern. Advertising is a single component of the marketing process. It's the part that involves getting the word out concerning your business, product, or the services you are offering. It involves the process of developing strategies such as ad placement, frequency, etc. Advertising includes the placement of an ad in such mediums as newspapers, direct mail, billboards, television, radio, and of course the Internet. Advertising is the largest expense of most marketing plans, with public relations following in a close second and market research not falling far behind. The best way to distinguish between advertising and marketing is to think of marketing as a pie, inside that pie you have slices of advertising, market research, media planning, public relations, product pricing, distribution, customer support, sales strategy, and......

Words: 1807 - Pages: 8

Premium Essay

Data Management

...Top Data Management Terms to Know Fifteen essential definitions you need to know Fifteen Essential Data Management Terms We know it’s not always easy to keep up-to-date Contents with the latest data management terms. That’s why we have put together the top fifteen terms and definitions that you and your peers need to know. OLAP (online analytical processing) Star schema What is OLAP (online analytical processing) Fact table OLAP (online analytical processing) is computer processing that enables a Big data analytics Data modeling Ad hoc analysis user to easily and selectively extract and view data from different points of view. For example, a user can request that data be analyzed to display a spreadsheet showing all of a company's beach ball products sold in Florida in the month of July, compare revenue figures with those for the same products in September, and then see a comparison of other product sales in Data visualization Extract, transform, load (ETL) Florida in the same time period. To facilitate this kind of analysis, OLAP data is stored in a multidimensional database. Whereas a relational database can be thought of as two-dimensional, a multidimensional database considers each data attribute (such as product, geographic sales region, and time Association rules (in data mining) Relational database period) as a separate "dimension." OLAP software can locate the intersection of dimensions (all products sold in......

Words: 4616 - Pages: 19

Premium Essay

Databasse Management

........................................................38 2.1 Data Models, Schemas, and Instances ......................................................................................39 2.2 DBMS Architecture and Data Independence............................................................................41 2.3 Database Languages and Interfaces..........................................................................................43 2.4 The Database System Environment..........................................................................................45 2.5 Classification of Database Management Systems ....................................................................47 2.6 Summary ..................................................................................................................................49 Review Questions...........................................................................................................................49 Exercises.........................................................................................................................................50 Selected Bibliography ....................................................................................................................50 Footnotes ........................................................................................................................................50 Chapter 3: Data Modeling Using the Entity-Relationship Model....................

Words: 229471 - Pages: 918

Premium Essay

Accounts and Numbers

...because “growth options” can evaporate. On the other hand, companies within the same industry tend to exhibit similar financial characteristics, as measured by financial ratios. With some knowledge of the different operating, investing, and financing decisions across industries, financial ratios can be used to identify an industry (see Exhibit 1 for the definition of ratios used). Balance sheets and income statements for the most recent three years are provided for 10 companies from 10 different industries. Common-sized balance sheets (all items scaled by total assets), common-sized income statements (all items scaled by net sales), and selected financial ratios for the most recent three years are also provided. Since unusual deviation from target values may occur in any given year, the values for the items were averaged over three years. The three-year average common-sized balance sheet, common-sized income statement, and financial ratios are reported in Exhibits 2, 3, and 4, respectively. The 10 companies are drawn from the following 10 different industries: • • • • • • • • • • Commercial airline Commercial banking (items fitted into the same categories as the non-financial firms) Computer software Integrated oil and gas IT service provider Liquor producer and distributor Mobile phone service provider Pharmaceutical preparations Retail grocery stores Semiconductor manufacturer Assignment Using the financial statement data provided in......

Words: 2512 - Pages: 11

Premium Essay

Data Management - Anyone Can Read Bankacnt Relation Except for the Acct No Attribute

...09902787224 DATA MANAGEMENT CASE STUDY : 1 The physical or internal level organization of a database system is concerned with the efficient storage of information in the Secondary Storage devices. The physical to conceptual level mapping must provide the necessary shield to the user. The basic problem in physical database representation is to select a suitable file system to store the desired information. The file consist of records and a record may consist of several fields. 1) What are the typical operations that may be performed on the information stored in the file? 2) Explain in detail factors affecting physical organization of data? 3) Explain the term ‘Magnetic Tapes’? 4) Define in brief ‘Secondary Storage Devices’? CASE STUDY : 2 In a medical database with attributes DISEASE, SYMPTOM, TEST (such as pathological or clinical tests), TREATMENT and MEDICINE, following data dependencies are assumed to hold. 1) Compute the dependency basis of each attribute? 2) Identify the join dependencies that hold in this database? 3) Does there exist a fourth normal form decomposition that preserves the dependencies? 4) If so, design a fourth normal form lossless, join decomposition that preserves the dependencies? CASE STUDY : 3 1) Anyone can read BANKACNT relation except for the ACCT NO attribute. 2) Any accountholder can read the tuple corresponding to his/her own account number from the ACNT......

Words: 386 - Pages: 2