Nobody downloaded yet

Rdms. phase 1 db2 - Essay Example

Comments (0) Cite this document
Summary
The relational database lifecycle is the process through which a relational database system is developed. Within the larger information system, the database, too, is subject to a life cycle. The Database Life Cycle contains six phases: initial study, database design, implementation and loading, testing and evaluation, operation, and maintenance and evolution…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER95.2% of users find it useful
Rdms. phase 1 db2
Read TextPreview

Extract of sample "Rdms. phase 1 db2"

Download file to see previous pages The second phase focuses on the design of the database model that will support company operations and objectives. In the process of database design, concentration must be placed on the data characteristics required to build the database model. Two views of the data within the system are available the business view of data and the designers' view. RDBLC's second phase also includes data definition. It is also important to note thatthe database design is not a sequential process it is rather an iterative process with continuous feedback.
In the conceptual design phase, an abstract structure is created that represents real-world objects in the most realistic way possible. The conceptual model must represent a clear understanding of the business and its functional areas and is software and hardware independent.
ii) Entity relationship modeling and normalization (The ER model serves to be a communication tool between technical and non-technical individuals as well as a design blueprint. During normalization the dependencies are checked and data anomalies removed)
Logical design is used to translate the conceptual design into the internal model (database schema) for a selected database management system. Therefore, the logical design is obviously software-dependent.
III. Physical Design
Physical design is the process of selecting the data storage access characteristics of the database. These characteristics are actually the types of devices supported by the hardware, the system, and the DBMS. Therefore the physical design is hardware dependant. It affects not only the location of the data in the storage device(s) but also the performance of the system.
3. Implementation and Loading
The relational database and its interfaces are created according to the specification of a logical schema. A new database implementation requires the creation of special storage-related blocks for the placement of end-user tables.
During the implementation and loading phase, the security, performance, integrity, backup and recovery, standards, and control issues must also be addressed.
4. Testing
Once the data have been loaded into the database, the DBA tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints. The testing and evaluation phase occurs in parallel with applications programming.
5. Operation
Once the database has passed the test phase, it is considered to be operational. On the whole all the components the database, its management, its users, and its application programs are in place at this time and represent a complete information system.
6. Maintenance
The maintenance phase starts as soon the database is implemented. The database ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Rdms. phase 1 db2 Essay Example | Topics and Well Written Essays - 2000 words”, n.d.)
Retrieved from https://studentshare.org/miscellaneous/1524506-rdms-phase-1-db2
(Rdms. Phase 1 Db2 Essay Example | Topics and Well Written Essays - 2000 Words)
https://studentshare.org/miscellaneous/1524506-rdms-phase-1-db2.
“Rdms. Phase 1 Db2 Essay Example | Topics and Well Written Essays - 2000 Words”, n.d. https://studentshare.org/miscellaneous/1524506-rdms-phase-1-db2.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Rdms. phase 1 db2

DB2

...?Comparison of Greek and Roman Art For this comparison, I have chosen Greek Temple Parthenon, and Roman Arch of Constantine. The Greek Temple Parthenon was completed in 432 BC while the Roman piece of intellect and art was made in 312 CE. Both of these are three dimensional, pieces of constructions. The decorations of both these buildings are done very beautifully. The earlier represents the best of Greek building art and the former represents the aesthetic sense of the Romans (Boardman, 1996). Looking at the Greek master piece, we can notice the use of Metopes, Frieze and Pediments. The walls of this building are light colored. This building was constructed to replace the temple of the goddess Athena (Boardman, 1996). The look... of Greek...
1 Pages(250 words)Essay

Phase 1 Discussion Board

...of the decisions are coming from the majority; and that’s what makes our previous projects successful. References Judd, M. (2007). Project Procurement Management. Retrieved from http://www.eastidahopmi.org/5-16-07mtg.pdf Haughey, D. (n.d.). The Project Management Body of Knowledge (PMBOK). Retrieved from http://www.projectsmart.co.uk/pmbok.html Piscopo, M. (n.d.). Procurement Management Plan. Retrieved from http://www.projectmanagementdocs.com/project-planning-templates/procurement-management-plan.html (n.d.). List of Open Tenders. Retrieved from http://www.irctc.com/DownloadDocuments?workflow=geDocListByCategory&doc_cat_id=1 The Doughty Centre for Corporate Responsibility. (2009). Stakeholder Engagement: A Roadmap to...
4 Pages(1000 words)Assignment

Managing Human Resources-Phase 2 DB2

...Managing Human Resources, Phase 2 DB 2 The goal of this report is to show how I would present a 401k to new employees at NL&C. The primary audiencewill be new hires, and the presentation will be made during their new-employee orientation. My goals are threefold: (1) to create value in the eyes of the new employees, so that they see this as a meaningful benefit to working at NL&C, (2) to insure that the participation rate is high, as it is a good long-term way to insure employee loyalty, and (3) give them the facts that they need in order to make an informed decision. The basic facts of 401k’s are the following: 1. Many companies, including NL&C, offer matching contributions up to a certain percentage of an employee’s pay, capped... at a...
2 Pages(500 words)Essay

Information Technology Management Phase 1 DB2

...Running Head: INFORMATION TECHNOLOGY MANAGEMENT PHASE DB2 Information Technology Management Phase DB2 in Harvard Style by Name University What unique things does Pottery Barn do with its employees that could be used by SWU? The most notable thing that the employees of the Pottery Barn do is breaking the stereotypical portrait of an efficient employee. The company recognizes that being workaholic is not equivalent to being effective. Noting that the success of Pottery Barn is through the recognition and identification of the needs and wants of the customers, it allows it employees to put themselves at the shoes of their customers. The company doesn’t spend much time on desk research in terms of design but are immersed in the real...
3 Pages(750 words)Essay

Phase 1

...Response essay The rapid globalization of the recent years has tremendously changed the very dynamics of the business world. Apart from becoming fiercely competitive, the business around the world is fast changing its business and public-relation strategy to encompass areas that were hitherto, not considered relevant. In fact the public relation is increasingly becoming one of the most important areas that have major influence on the overall performance of the companies. In the changing scenario, the management of Global Gadgets Imports (GGI) needs to reassess its image building strategy at the earliest and introduce a more personal touch with its customers by getting involved in community services. Looking at the public relation...
2 Pages(500 words)Essay

Reponse to Phase 1

...Running head: RESPONSE TO PHASE Response to Phase Affiliation November 2008 This document will discuss how PMI PMBOK knowledge area on project procurement and contract management fits into the project management lifecycle. Project Management Body of Knowledge (PMBOK) from the project Management Institute (PMI) described six process for our (ACME Development Corporation (ADC)) corporate single project scheduling tool. What Procurement is: Procurement process shows us the aspects of project management that will leads us towards getting goods and services from some out side organizations or companies (Kenneth, 1998). I will present overview of project procurement activities1 through out the project...
2 Pages(500 words)Essay

Phase 1 Individual Project

.... From the case, it is evident that the prosecution has a duty to disclose all evidence it has in its possession to the defendant and it has no obligation to search for exculpatory evidence. The United States Supreme concurs with this statement and argues that by following this process, the prosecutor follows the constitution and fulfills his/her duties of seeking justice. However, Justice Harlan gave a dissenting opinion arguing that the due process of administration of justice should follow into the guilt phase because it was the responsibility of the jury to decide whether the defendant is guilty and administer punishment in the State of Maryland on issues pertaining to first degree murder. The rationale of the...
3 Pages(750 words)Essay

Marketing Plan: Phase 1

...Marketing plan Supervisor] Marketing plan Introduction Sonoma County Family YMCA is basically an organization that helps with the development of youth of Sonoma County. YMCA organizes a number of activities that help with the development and learning of children. Through these activities, a number of children and teens of various ages are taught the importance of values, and are given lessons on positive behaviours. More importantly, the organization aims at helping these individuals learn about the skills that they possess and how they can exploit those skills in a positive manner (YMCA, 2013). Importance of marketing for YMCA Reaching out to more individuals The organization hosts a number of events in a calendar year... plan Supervisor]...
2 Pages(500 words)Essay

Nursing capstone phase 1

...risks in implementing the provide solutions (De Silvestro et al, 2013). This component will involve an analysis of the cause and effect process, as well as identification of changes required for the department. Tools that can be used here include the Failure Mode and Effects Analysis, Impact Analysis, and Continuous Improvement Analysis. During the collection of data phase, the root cause analysis will involve at least two other disciplines, which are hematology and anesthetics. The anesthetist will be involved in this RCA since they are responsible for making the decision concerning whether the blood is to be given to a patient undergoing a procedure or not. The reason that this decision is a responsibility for the...
3 Pages(750 words)Assignment

Case Study Phase 1

...Topic: Risk RISK Risk entails the potential of losing something that is valuable since values can be achieved or lost when risks are taken resulting from specific actions, activities or inactions that have either been forecasted or unpredicted (Carson & Bain, 2008). Risks may also be considered as intentional interactions with uncertainty while perception of risk is the biased judgment people make concerning the possibility of risks occurring and may be different from one person to another. All the activities that human beings take part in are associated with some level of risk but some are have more risk than others do. In terms of business and management, the possibility of an investment’s actual return usually differs... Risk RISK Risk...
2 Pages(500 words)Case Study
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Essay on topic Rdms. phase 1 db2 for FREE!

Contact Us