Rdms. phase 1 db2 Essay Example | Topics and Well Written Essays - 2000 words

Rdms. phase 1 db2 - Essay ExampleThe second phase focuses on the intention of the informationbase 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 be available the business view of data and the designers view. RDBLCs second phase also includes data definition. It is also burning(prenominal) to note thatthe database design is not a sequential process it is rather an iterative process with nonstop feedback.In the abstract 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 atomic number 18as and is software and hardware independent.ii) Entity relationship modeling and normalization (The ER model serves to be a communication tool amid 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 counseling system. Therefore, the logical design is obviously software-dependent.III. Physical DesignPhysical design is the process of selecting the data retentivity 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 ladingThe relational database and its interfaces are created according to the specification of a logical schema. A new database implementation requires the founding of special storage-related blocks for the placement of end-user tabl es. During the implementation and loading phase, the security, performance, integrity, backup and recovery, standards, and control issues must also be addressed. 4. testOnce 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. OperationOnce 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. MaintenanceThe bread and butter phase starts as soon the database is implemented. The database