MBA Database Management Essay

A1. Differentiate between Traditional File System & Modern Database System File Base system were the traditional systems which has been replaced now by modern database systems. All database application are using the Modern day database management systems now a days . The difference between the these two technologies given below. File-based System File-based systems were an early attempt to computerize the manual filing system. File-based system is a collection of application programs that perform services for the end-users. Each program defines and manages its data. However, five types of problem are occurred in using the file-based approach: Separation and isolation of data When data is isolated in separate files, it is more difficult for us to access data that should be available. The application programmer is required to synchronize the processing of two or more files to ensure the correct data is extracted. Duplication of data When employing the decentralized file-based approach, the uncontrolled duplication of data is occurred. Uncontrolled duplication of data is undesirable because: i.Duplication is wasteful ii.Duplication can lead to loss of data integrity Data dependence Using file-based system, the physical structure and storage of the data files and records are defined in the application program code. This characteristic is known as program-data dependence. Making changes to an existing structure are rather difficult and will lead to a modification of program. Such maintenance activities are time-consuming and subject to error. Incompatible file formats The structures of the file are dependent on the application programming language. However file structure provided in one programming language such as direct file, indexed-sequential file which is available in COBOL programming, may be different from the structure generated by other programming language such as C. The direct incompatibility makes them difficult to process jointly. Fixed queries / proliferation of application programs File-based systems are very dependent upon the application programmer. Any required queries or reports have to be written by the application programmer. Normally, a fixed format query or report can only be entertained and no facility for ad-hoc queries if offered. File-based systems also give tremendous pressure on data processing staff, with users’ complaints on programs that are inadequate or inefficient in meeting their demands. Documentation may be limited and maintenance of the system is difficult. Provision for security, integrity and recovery capability is very limited. Database Systems: In order to overcome the limitations of the file-based approach, the concept of database and the Database Management System (DMS) was emerged in 60s. A database is an application that can store and retrieve data very rapidly. The relational bit refers to how the data is stored in the database and how it is organized. When we talk about database, we mean a relational database, in fact an RDBMS – Relational Database Management System. In a relational database, all data is stored in tables. These have the same structure repeated in each row (like a spreadsheet) and it is the relations between the tables that make it a â€Å"relational† table Advantages: A number of advantages of applying database approach in application system are obtained including: Control of data redundancy The database approach attempts to eliminate the redundancy by integrating the file. Although the database approach does not eliminate redundancy entirely, it controls the amount of redundancy inherent in the database. Data consistency: By eliminating or controlling redundancy, the database approach reduces the risk of inconsistencies occurring. It ensures all copies of the idea are kept consistent. More information from the same amount of data With the integration of the operated data in the database approach, it may be possible to derive additional information for the same data. Sharing of data Database belongs to the entire organization and can be shared by all authorized users. Improved data integrity Database integrity provides the validity and consistency of stored data. Integrity is usually expressed in terms of constraints, which are consistency rules that the database is not permitted to violate. Improved security Database approach provides a protection of the data from the unauthorized users. It may take the term of user names and passwords to identify user type and their access right in the operation including retrieval, insertion, updating and deletion. Enforcement of standards The integration of the database enforces the necessary standards including data formats, naming conventions, documentation standards, update procedures and access rules. Economy of scale Cost savings can be obtained by combining all organization’s operational data into one database with applications to work on one source of data. Balance of conflicting requirements By having a structural design in the database, the conflicts between users or departments can be resolved. Decisions will be based on the base use of resources for the organization as a whole rather that for an individual entity. Improved data accessibility and responsiveness By having an integration in the database approach, data accessing can be crossed departmental boundaries. This feature provides more functionality and better services to the users. Increased productivity The database approach provides all the low-level file-handling routines. The provision of these functions allows the programmer to concentrate more on the specific functionality required by the users. The fourth-generation environment provided by the database can simplify the database application development. Improved maintenance Database approach provides a data independence. As a change of data structure in the database will be affect the application program, it simplifies database application maintenance. Increased concurrency Database can manage concurrent data access effectively. It ensures no interference between users that would not result any loss of information nor loss of integrity. Improved backing and recovery services Modern database management system provides facilities to minimize the amount of processing that can be lost following a failure by using the transaction approach. Disadvantages In split of a large number of advantages can be found in the database approach, it is not without any challenge. The following disadvantages can be found including: Complexity Database management system is an extremely complex piece of software. All parties must be familiar with its functionality and take full advantage of it. Therefore, training for the administrators, designers and users is required. Size The database management system consumes a substantial amount of main memory as well as a large number amount of disk space in order to make it run efficiently. Cost of DBMS A multi-user database management system may be very expensive. Even after the installation, there is a high recurrent annual maintenance cost on the software. Cost of conversion When moving from a file-base system to a database system, the company is required to have additional expenses on hardware acquisition and training cost. Performance As the database approach is to cater for many applications rather than exclusively for a particular one, some applications may not run as fast as before. Higher impact of a failure The database approach increases the vulnerability of the system due to the centralization. As all users and applications reply on the database availability, the failure of any component can bring operations to a halt and affect the services to the customer seriously Q2. What is the disadvantage of sequential file organization? How do you overcome it? What are the advantages & disadvantages of Dynamic Hashing? Disadvantage of Sequestial file organization: A file that contains records or other elements that are stored in a chronological order based on account number or some other identifying data. In order to locate the desired data, sequential files must be read starting at the beginning of the file. A sequential file may be stored on a sequential access device such as magnetic tape or on a direct access device such as magnetic disk. Contrast with random file. Dynamic Hashing: Advantages The main advantage of hash tables over other table data structures is speed. This advantage is more apparent when the number of entries is large (thousands or more). Hash tables are particularly efficient when the maximum number of entries can be predicted in advance, so that the bucket array can be allocated once with the optimum size and never resized. If the set of key-value pairs is fixed and known ahead of time (so insertions and deletions are not allowed), one may reduce the average lookup cost by a careful choice of the hash function, bucket table size, and internal data structures. In particular, one may be able to devise a hash function that is collision-free, or even perfect (see below). In this case the keys need not be stored in the table . Disadvantages Hash tables can be more difficult to implement than self-balancing binary search trees. Choosing an effective hash function for a specific application is more an art than a science. In open-addressed hash tables it is fairly easy to create a poor hash function. Although operations on a hash table take constant time on average, the cost of a good hash function can be significantly higher than the inner loop of the lookup algorithm for a sequential list or search tree. Thus hash tables are not effective when the number of entries is very small. (However, in some cases the high cost of computing the hash function can be mitigated by saving the hash value together with the key.) For certain string processing applications, such as spell-checking, hash tables may be less efficient than tries, finite automata, or Judy arrays. Also, if each key is represented by a small enough number of bits, then, instead of a hash table, one may use the key directly as the index into an array of values. Note that there are no collisions in this case. The entries stored in a hash table can be enumerated efficiently (at constant cost per entry), but only in some pseudo-random order. Therefore, there is no efficient way to efficiently locate an entry whose key is nearest to a given key. Listing all n entries in some specific order generally requires a separate sorting step, whose cost is proportional to log(n) per entry. In comparison, ordered search trees have lookup and insertion cost proportional to log(n), but allow finding the nearest key at about the same cost, and ordered enumeration of all entries at constant cost per entry. If the keys are not stored (because the hash function is collision-free), there may be no easy way to enumerate the keys that are present in the table at any given moment. Although the average cost per operation is constant and fairly small, the cost of a single operation may be quite high. In particular, if the hash table uses dynamic resizing, an insertion or deletion operation may occasionally take time proportional to the number of entries. This may be a serious drawback in real-time or interactive applications. Hash tables in general exhibit poor locality of reference—that is, the data to be accessed is distributed seemingly at random in memory. Because hash tables cause access patterns that jump around, this can trigger microprocessor cache misses that cause long delays. Compact data structures such as arrays, searched with linear search, may be faster if the table is relatively small and keys are integers or other short strings. According to Moore’s Law, cache sizes are growing exponentially and so what is considered â€Å"small† may be increasing. The optimal performance point varies from system to system. Hash tables become quite inefficient when there are many collisions. While extremely uneven hash distributions are extremely unlikely to arise by chance, a malicious adversary with knowledge of the hash function may be able to supply information to a hash which creates worst-case behavior by causing excessive collisions, resulting in very poor performance (i.e., a denial of service attack). In critical applications, either universal hashing can be used or a data structure with better worst-case guarantees may be preferable Q3. What is relationship type? Explain the difference among a relationship instance, relationship type & a relation set? A3. A relationship type R among n entity types E1, E2, †¦, En is a set of associations among entities from these types. Actually, R is a set of relationship instances ri where each ri is an n-tuple of entities (e1, e2, †¦, en), and each entity ej in ri is a member of entity type Ej, 1≠¤j≠¤n. Hence, a relationship type is a mathematical relation on E1, E2, †¦, En, or alternatively it can be defined as a subset of the Cartesian product E1x E2x †¦ xEn . Here, entity types E1, E2, †¦, En defines a set of relationship, called relationship sets. Q4. What is SQL? Discuss. Q5. What is Normalization? Discuss various types of Normal Forms? Q6. What do you mean by Shared Lock & Exclusive lock? Describe briefly two phase locking protocol? MI0034 – Database Management System – 4 Credits Assignment – Set- 2 (60 Marks) Answer all the Questions Q1. Define Data Model & discuss the categories of Data Models? What is the difference between logical data Independence & Physical Data Independence? Q2. What is a B+Trees? Describe the structure of both internal and leaf nodes of a B+Tree? Q3. Describe Projection operation, Set theoretic operation & join operation? Q4. Discuss Multi Table Queries? Q5. Discuss Transaction Processing Concept? 10.2 Describe properties of Transactions? Q6. Describe the advantage of Distributed database? What is Client/server Model? Discuss briefly the security and Internet violation? .

Dracula Queer Theory

The existence of alien and intolerable behavior generates fear into society’s mentality of the expected conduct. But does the ‘queer’ lurk under the bed? Or is it a part of all of us? The classic text â€Å"Dracula†, written by Bram Stoker, is valuable in understanding the course of society in its exploration of tabooed acts and mentalities, supported by the â€Å"Queer Theory† prevalent in the mid 1900’s. Although the queer theory describes the author’s subconscious drive for homosexual and feministic expression, Stoker’s stand point, however, is to highlight society’s vulnerability caused by their oppression of individuality and lack of conformity. Through this text we have been able to understand the flaws in a conformist society where individuality and the â€Å"different† are oppressed. Each community has their own particular morals and ethics, and when the actions of the different penetrates and ‘influences’ these expectations, those in power result to force in order to restore the original values that were compromised. Stoker’s warning of the supernatural feared the people of his century, anyone who appeared or acted ‘differently’ to what was expected, as represented through the characters in Dracula. It has been rumored that Dracula extends the element of the â€Å"Queer Theory† to a whole distinct level. Through analysis of Dracula’s behaviors, it is questioned whether or not Dracula indeed was queer himself. Besides the supernatural and gothic abilities that he encompassed, Dracula showed evidence of homosexuality. When the Count saw my face, his eyes blazed in some sort of demonic fury† (Page 33), is evident of the desire for blood, which according to the ‘Queer Theory’ symbolizes his confused sexual desire for men. Dracula thus represents the disturbance in masculinity, as he enters his femininity; a further demonstration of the 1900’s ‘Queer Theory. ’ Therefore it can be argued that Dracula is valued by the social outcas ts of modern society as it gives hope to those who choose the express their individuality. Unusual behaviors are often intolerably indicated within a society that has strict expectations and values. Stoker’s upbringing revolved around women who were independent in their own ways, however societies expectations disallowed this aspect of humanity as men where thought to be the masculine and dominant figure. The queer theory suggests that Bram Stoker concealed his â€Å"mismatch of gender roles, sex and desires† (Judith Butler, 1994) due to the clashes of his personal upbringing with society’s expectations. Women being the submissive and weak figures reflected through the words of Stoker as he portrayed this bewilderedness through Dracula who himself becomes weak at any sense of unassertive or dominant sex. Dracula’s confusion is evident as he seduces the ‘devoted’ Lucy where he demonstrates the authoritative paternal figure yet. However, when he portrays his desire and possession of Jonathan, claiming â€Å"he belongs to [him]† (Page 46), he symbolizes the feminine teenage girl who has a fascination with the opposite sex.

Misuse of power Essay

The Crucible is largely concerned with the abuse and misuse of power in Salem. Discuss with reference to any three characters. The misuse of power in The Crucible leads to horrible suffering and even the deaths of some innocent people, in the town. Some characters in the play misuse their power towards other characters; some characters misuse their power in the courtroom and some misuse their power in religion (in church). In this essay I intend to look at the misuse of power focusing on the characters of Abigail Williams, Governor Danforth and Reverend Parris. Abigail Williams Misuses her power extensively throughout the play. She has most of the adults in Salem believing that she is a sweet innocent girl and so is never accused or suspended of doing anything sinful or unlawful. She also has most of the girls of Salem obeying her, due to a mixture of respect and fear, fear of Abigail and also a fear of getting in trouble for the dancing. The women of Salem are also afraid of Abigail as she could quite easily accuse them of witchcraft with no questions asked, as she is known to be sweet and innocent. Abigail did have power over John Proctor when he was having an affair with her, as he lusted after Abigail. Although she no longer has power over John Proctor as he learns during the play what she is really like when he turns her down. In act 3 of The Crucible Abigail seems to have power over court officials. When Abigail is accusing Mary Warren of witchcraft in the courtroom, Governor Danforth begins to question Abigail. Abigail replies with shock and says that she is hurt, Governor Danforth then swiftly backs off. Abigail then begins to threaten Danforth with how hell could take him in: â€Å"think you be so mighty that the power of Hell may not turn your wits? Beware of it†. Danforth then seems to be wary of Abigail in the next reply to her, the book describes what he says as ‘apprehensively’. Danforth has began to be aware of what Abigail is doing and decided to not get in her way or upset her, as he didn’t want her to accuse him of being in contact with the Devil. If she did this it would be him on trial as well as all the others. Another point about Abigail is that she is a liar and she is very good at it. This is how she is so respected by some people and feared by others. In my opinion the reason Abigail is so manipulative and weird, and also seems to have no feeling or a conscience, is because her parents were murdered by Indians in front of her. She describes this to the girls in a hard-hearted way, which shows that her emotions have all been drained apart from her love/lust for proctor and her jealously of Elizabeth. Reverend Parris misuses his power in The Crucible because he does not think the townspeople of Salem respect his position as ‘a man of God’. The Churches power at that time was very strong and so Reverend Parris has no problem in using his power the wrong way. The way in which he misuses his power is mostly from the pulpit of the church in his sermons. He believes that the church is the authority of all people in the town. He also believes himself an authoritative figure. He believes that anyone who does not commit his or her lives to the church should be questioned. He also demands that the people of Salem are obedient to the church and himself. He says that if they are not obedient, then they will burn in hell. Reverend Parris preaching things like this in his sermon strikes fear into the townspeople, as they begin to think Hell is upon them and this causes chaos to break out, as they begin to yell and scream at one another. Reverend Parris hates to be wrong, in the courtroom even when he realised that he is wrong to accuse all the people involved, he still sticks to his beliefs however wrong they may be. Parris causes innocent peoples deaths all because of his beliefs, stubbornness, selfishness and his misuse of power. I have reached the conclusion that the characters in The Crucible do misuse their power; the two characters I chose demonstrate this theory very well. Not all the characters in the play do, but there are many characters that do. This selfish act of misusing power in The Crucible is very influential to how the plot develops. Without Abigail Williams acting like a selfish, irresponsible strumpet, or Reverend Parris being selfish and power-hungry The Crucible would have lost its whole page-turning ominous, experience.

Positive reward Essay

It can also be maintained that Kistler had more urge of continuing his ‘virtual’ mischief since he was able to, for the most part, obtain sexual pleasure through the means of the internet which could have been an easy method for Kistler to achieve his aims. The pleasure he gets is a form of a ‘positive reward’ at least in the context of Kistler as opposed to the idea that the pleasure he gets is not actually any sort of ‘reward’ to others especially to the victims. By admitting that he knew that what he did was essentially wrong perhaps in the legal and moral senses, it leads one to the realization that Kistler may unconsciously place his personal actions as behaviors that override any existing proscriptions against them. Thus, by considering his pedophilic behavior as one that is ‘wrong’ yet fulfilling in sexual terms, Kistler eventually treats his behavior as one that is above what is being forbidden or disallowed by the larger society of which he is a part of. Further, his absence of knowing that he was causing harm—or at least as far as he reveals—holds a reasonable argument that pertains to the corresponding absence of an effort to deliberately put a stop to his behavior. That is, since Kistler was not well aware that he was causing harm to his ‘victims’, there was no apparent reason for him to adjust accordingly or to realign his behavior according to the normal conducts within the society, to legal and moral prescriptions, and to what is prohibited. Otherwise, had Kistler known the negative effects his behavior has been causing, there remains the probability that he may have discontinued his actions—or he may have not. What is more important is the idea that there are reasons behind Kistler’s behavior albeit having the knowledge that his behavior is one of the things the status quo of the society is against. Nevertheless, Kistler was sentenced to 24 years of federal imprisonment; a contemporary example to the ancient Roman law â€Å"ignorance of the law is no excuse† (Brudner, 1995, p. 224). Since the learning process contains the appropriation of punishments and rewards in the SLT, there remains the implied cause that Kistler initially engaged in his pedophilic behavior and continued to do so after he was able to obtain a ‘reward’ for soliciting sexually explicit images from teenage girls. Even further, his initial behavior of engaging into internet child pornography may have also sprung from a variety of reasons which, after engaging into the act, led Kistler to obtain a ‘rewarding’ experience largely in the form of sexual satisfaction. Although the far more original causes beyond the subsequent continuance of his actions are of interest as well, the primary concern of the SLT remains to the ‘direct conditioning’ of the behavior of the individual or of, specifically, Kistler. The concept of ‘direct conditioning’ can be illustrated in the case where the experience of traumatic situations in the dental surgery is linked with the occurrence of fear by means of the learning of a correlation of pain as well as distress with the dental situation (Milson, Tickle, Humphris, & Blinkhorn, 2003, p. 495). Conversely, the case of Kistler can be analyzed in terms of the concept of direct conditioning. That is, the ‘sexually rewarding’ experience of Kistler with regards to his ‘pornographic’ exploits can be seen as one that is associated with the occurrence of the feeling of ‘liking’ what he does through the learning of a correlation of ‘sexual satisfaction’ with online child pornography by pretending as a dying teenage boy and appealing to teenage girls to send sexually explicit images.

Security Operations Management Practicum Assignment

Security Operations Management Practicum - Assignment Example If I was an adjudicator and considering the investigative report done by the Special Agent, FBI, on   Smith Ronald James Smith DPOB: 2/5/1976, I would not have granted her the security clearance request. According to the investigative report gathered, the credit agencies had no unfavourable financial information on Smith. He was born in Davenport, Iowa, in 1976, on his security form it; he indicated that he had been arrested in high school over alleged smoking of marijuana. According to guideline regarding drug involvement, drug abuse is a condition that can raise a security concern and thus disqualifies an individual from been granted security clearance. By definition, drug abuse is the illegal use a drug in a manner that deviates from the correctly approved medical direction. Accordion to the Controlled Substance Act of 1970, Marijuana or Cannabis is classified as an illegal drug (Herbig 12). Further, a review of State Department travel records indicated that Smith had travelled outside the country on four different occasions. However, the date he indicated on his security form regarding his tour to Moscow did not match with the date on indicated in the State Department travel record. As if that was not enough, on his security form, he failed to indicate his tour to Rome, Italy. In the travel state department, it is clearly indicated that he travelled to he travelled to Rome, Italy on September 15, 1988, and returned on October 15, 1988. According to the Guideline E, personal conduct, dishonesty and questionable judgment is a concern that can result in unfavourable action for clearance eligibility (Herbig 12). However, Smith could have mitigated the security concerns if in good faith efforts he corrected the falsification of the dates before he was confronted with the facts. Other the other hand, if I was an adjudicator and considering the investigative report done by the Special Agent, FBI, on Susan Julia Kidwell, DPOB: 7/5/1986, I would have granted her the security clearance request. The aggravating factor that I would consider first is that Kidwell profoundly admitted that she owed the credit card debt and after discovering this, she filed for bankruptcy.  Ã‚  

An outline marketing plan for the next year for Atlantic Quench 304 Essay

An outline marketing plan for the next year for Atlantic Quench 304 - Essay Example market. Theoretical frameworks of Porter’s five forces, Ansoff Matrix and Marketing Communication mix has been used in this paper. The paper suggests that AQC must continue with its quest of new product development primarily focusing on healthy products for consumers. A slightly high price can be charged from the consumers if they assume that the products provide functional value. The global fruit juice industry is also facing a number of challenges from the health organizations in the developed countries regarding their fatty contents and the amount of sugar in these drinks. It has therefore become difficult for fruit juice companies to retain their market share in face of volatile demand conditions. In this light, this paper makes an attempt to create a marketing plan for Atlantic Quench Cranberries (AQC), a US based agricultural cooperative which have pioneered in the production of canned fruit juices. AQC had a slow but steady beginning in 1930’s. It started as a cooperative which was initially controlled by three farmers from New Jersey and Massachusetts. Presently the company is the top player in the U.S. fruit juice market. The success story of AQC had been strong even in the United Kingdom ever since its entry in the U.K. market. This report provides an elaborate marketing plan for AQC in the next one year so that the company can increase its market share in the U.K. The government of the U.K. is trying to introduce measures to reduce obesity and fruit juices are items which contains high volume of saturated sugar. However, Atlantic Quench produces drinks with very low sugar content and low calories that provide chances of growth in the U.K. markets. The market conditions in the U.K. fruit juice industry are quite dynamic. An estimated growth of 10% has been noted in the value of fruit juice markets including the smoothies. Despite the

A study was conducted and an introduction (lit review) section needs Research Paper

A study was conducted and an introduction (lit review) section needs to be done - Research Paper Example f-concept also gives people an opportunity to compare their personal attributes, abilities, and reactions to those of others (Harter & Bukowski, 2012). On the other hand, self-esteem refers to the respect that a person has for himself or herself. Self-esteem is an extremely vital concept since it affects functional behavior, motivation, as well as life satisfaction (Bordens & Horowitz, 2002). Individuals who have high self-concept about themselves normally have positive thoughts. In this regard, they have high self-esteem of themselves. Having high self-esteem is a critical component in one’s life since it gives one confidence about his or her self-worth. In this regard, an individual can compare himself to be attractive. Being attractive entails several components, and personal hygiene is one of the components (Harter & Bukowski, 2012). Therefore, one must assess his or her personal hygiene in the wake of evaluating