Intro to Rel Dbase Mgts Syst - Assignment Example

Yours Teacher’s 29th October, Introduction to Relational Database Management System Normalization and Redundancy" Please respond to the followingQuestion number 1:Response 1: Data inconsistency is one the main problem that exists in different versions of the same data, which appears in different places. For example, a sales company’s sales department stores the name of a salesman as Bill Brown while same name in personnel department is saved as William G brown, the probability of data inconsistency increases in similar cases.

Price of the product is shown as $45.50 in the sales office while product of the same product is displayed as $43.90 in another department.Response 2: Normalization provides faster way to search out the data because of data consistency. There is a low risk of mistakes better data integrity because no duplicate data occurs.Question Number 2:Response 1: Constraint like Candidate key affects the degree of normalization of the database. De-normalization process is applied for the creation of data warehouse or sometimes used for revival of the dying online transaction processing (OLTP) applications, which shows the dreadful performance.

De-normalization process applied to those tables, which results during the normalization. De-normalization does not alter the basic form or structure of the schema, but adjusts the basic structure or database design.Response 2: Business rules are enforced by applying the triggers or stored procedures. Business rules are used for handling the referential integrity. Using stored procedures for achieving the referential integrity does not involve the application development outside of data.Database Design and ImplementationQuestion Number 1:Response 1: Queries like select, create, update, delete, and alter are used to perform the various business functions from a relational database management system.

These queries can be used to access the column or rows of relations.Response 2: Data access and modification becomes easier by using the queries. Queries are also implemented in order to create reports.Question Number 2:Response 1: Some queries become complex during processing and cannot support the join and aggregation. Translation of multi-database queries becomes difficult for integration of heterogeneous results.Response 2: Under specification of data translation is another issue. Data from multiple tables becomes an issue because no simple way is there to validate the cross references from different files.

It becomes the integrity issue of cross-referencing.Database Life CycleQuestion Number 1Response 1: Initial deficiencies of information flow assessed during the Database Initial Study phase causes the modification of the existing system. This modification is also derived from the increased size of the organization. Increased number of wants and needs of the system also modify the initial study phase of database life cycle.Response 2: If the current system fails to meet the required functionality then system designer examines the ways the existing system failed.

Lot of time is spent in talking with end-users of the database (Rob, Coronel and Crocket 491).Question Number 2:Response 1: When strategic organization extends business across the different countries, scope and boundaries of the existing database will affect the change phase of the initial study.Response 2: Objectives of the organization also affect the database life cycle. Analysis of organization’s situation involves the organizational structure.Work CitedRob Peter, Coronel Carlos and Crocket Keeley.

Database systems: design, implementation & management. CENGAGE Learning, 2008. Print.