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

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

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

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

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

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

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

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

Indian School of Business Management and Administration.Answer Sheets. Mba.Emba.Dms.Bms.Aravind 9901366442.Doc

...www.mbacasestudyanswers.com www.casestudysolution.in aravind.banakar@gmail.com ARAVIND 09901366442 – 09902787224 ADVERTISING MANAGEMENT A) Define Advertising Copy? Please explain various ways of writing print advertising copy with examples? B) Design an AD campaign for a construction engineering company? (Manufacturers of construction product)? C) Write short notes on: 1: Characteristics of the ideal print advertisement 2: AIDA Model 3: Medial planning tools 4: ATL / BTL 5: Ad agency organization structure D) Illustrate positioning statement for: 1: Maruti 2: Nirma washing powder 3: BOSCH 4: Harward business school 5: Apples ADVERTISING MANAGEMENT VENKY’S OF VENKATESHWARA HATCHERIES Questions (A) (a) Comment on the advertising strategy adopted previously and currently. (b) Comment on branding of food products, and their promotion. (c) Can you think of a different creative strategy for a product like chicken? Lip-sticks with permitted colours can also damage the lips since the stainers are tetra-bromo-fluorosine. When rubbed against the palm, darkness of the stain will indicate the quantity of stainer present. Darkening of lip colour also depends upon the bio-chemistry of individual’s lips. Questions (B) (a) The complete product knowledge is given in the above write-up. What do you think should be the copy platform for......

Words: 27243 - Pages: 109

Indian School of Business Management and Administration.Answer Sheets. Mba.Emba.Dms.Bms.Aravind 9901366442.Pdf

...www.mbacasestudyanswers.com www.casestudysolution.in aravind.banakar@gmail.com ARAVIND 09901366442 – 09902787224 ADVERTISING MANAGEMENT A) Define Advertising Copy? Please explain various ways of writing print advertising copy with examples? B) Design an AD campaign for a construction engineering company? (Manufacturers of construction product)? C) Write short notes on: 1: Characteristics of the ideal print advertisement 2: AIDA Model 3: Medial planning tools 4: ATL / BTL 5: Ad agency organization structure D) Illustrate positioning statement for: 1: Maruti 2: Nirma washing powder 3: BOSCH 4: Harward business school 5: Apples ADVERTISING MANAGEMENT VENKY’S OF VENKATESHWARA HATCHERIES Questions (A) (a) Comment on the advertising strategy adopted previously and currently. (b) Comment on branding of food products, and their promotion. (c) Can you think of a different creative strategy for a product like chicken? Lip-sticks with permitted colours can also damage the lips since the stainers are tetra-bromofluorosine. When rubbed against the palm, darkness of the stain will indicate the quantity of stainer present. Darkening of lip colour also depends upon the bio-chemistry of individual‘s lips. Questions (B) (a) The complete product knowledge is given in the above write-up. What do you think should be the copy platform for these products? Indicate the theme, the appeal and the buying motives. (b) Indicate a suitable media mix for advertising these products. Give your......

Words: 27294 - Pages: 110

Indian School of Business Management and Administration.Answer Sheets. Mba.Emba.Dms.Bms.Aravind 9901366442.Pdf

...www.mbacasestudyanswers.com www.casestudysolution.in aravind.banakar@gmail.com ARAVIND 09901366442 – 09902787224 ADVERTISING MANAGEMENT A) Define Advertising Copy? Please explain various ways of writing print advertising copy with examples? B) Design an AD campaign for a construction engineering company? (Manufacturers of construction product)? C) Write short notes on: 1: Characteristics of the ideal print advertisement 2: AIDA Model 3: Medial planning tools 4: ATL / BTL 5: Ad agency organization structure D) Illustrate positioning statement for: 1: Maruti 2: Nirma washing powder 3: BOSCH 4: Harward business school 5: Apples ADVERTISING MANAGEMENT VENKY’S OF VENKATESHWARA HATCHERIES Questions (A) (a) Comment on the advertising strategy adopted previously and currently. (b) Comment on branding of food products, and their promotion. (c) Can you think of a different creative strategy for a product like chicken? Lip-sticks with permitted colours can also damage the lips since the stainers are tetra-bromofluorosine. When rubbed against the palm, darkness of the stain will indicate the quantity of stainer present. Darkening of lip colour also depends upon the bio-chemistry of individual‘s lips. Questions (B) (a) The complete product knowledge is given in the above write-up. What do you think should be the copy platform for these products? Indicate the theme, the appeal and the buying motives. (b) Indicate a suitable media mix for advertising these products. Give your reasoning....

Words: 27294 - Pages: 110

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

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

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

Data Base

...Chapter 1 Review Questions 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, and transaction-processing application. Answer : 1.2. What four 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. 1.7. Discuss the differences between database systems and information retrieval systems. Exercises 1.8. Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2. 1.9. What is the difference between controlled and uncontrolled redundancy? Illustrate with examples. 1.10. Specify all the relationships among the records of the database shown in Figure 1.2. 1.11. Give some additional views that may be needed by other user groups for the database shown in Figure 1.2. 1.12. Cite some examples of integrity constraints that you think can apply to the database shown in Figure 1.2. 1.13. Give examples of systems in which it may make sense to use traditional file processing instead of a database approach. 1.14....

Words: 4933 - Pages: 20

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