Task 2&3 (1)
docx
keyboard_arrow_up
School
Kenyatta University *
*We aren’t endorsed by this school
Course
7030
Subject
Information Systems
Date
Nov 24, 2024
Type
docx
Pages
3
Uploaded by mercy4321
Task 2 and 3
If you were going to develop a computer-based tool to help interview users and quickly and
easily create and edit E-R diagrams, what type of tool would you build?
The developers have designed several data models to create or edit E-R diagrams frequently. They are available at affordable cost and very easy to use. They are generally available in packaged software and developed by specialists, consultants, or database technology vendors.
• One of the available tools is ER Win. It is developed by Computer Associates. This software is used to prepare E-R diagrams. It keeps all the necessary data about the diagram and its elements.
• It can also produce different types of reports to present data about the required position or situation.
• There could be two types of computerized data models: Universal and Industry-specific.
In a situation in which the computerized system is required for helping analysts in creating and editing quickly the E-R diagrams (
Cagiltay et al., 2013). The Industry-specific data model is to be developed by using CASE tools. The features and working system of this new tool are described below:
• It would store information regarding the employee type and interview process.
• It would find required shapes to present the entity types with their attributes and relationships.
• It would create an E-R diagram and relate it to the continuous entry system of interviewing process.
• It would be modified as per the new data entered into the system.
What is the purpose of denormalization? Why might you want to create one physical table or title for each relation in a logical data model?
Denormalization is a technique for database optimization in which we add redundant data
to one or more tables. In a relational database, this can help us avoid costly joins. Denormalization can facilitate certain searches on a given set of data (getting information out of the database). This refers to the fact that if denormalization has been effectively implemented, queries are simpler to write and perform better. Both of these occur because fewer joins are required. After all, some relevant data is grouped in the same rows.
For the transactional database (Sanders & Shin, 2001), which is subject to frequent updates, it is typical to have a fully normalized database where "one physical table for each relation in the logical data model" is present. This has the benefit of requiring the least amount of
storage for the transactional database, allowing the database to be tuned properly, and ensuring that updates are made "in only one place."
However, for certain retrieval queries, a denormalized database may still be desirable. These competing requirements are met by using two (or possibly more) databases. One normalized database handles business transaction updates, while another denormalized database handles retrieval queries (Date, 2019). Tables that do not align with the logical data model can be
found in this denormalized.
References
Cagiltay, N. E., Tokdemir, G., Kilic, O., & Topalli, D. (2013). Performing and analyzing non-
formal inspections of entity relationship diagrams (ERD).
Journal of Systems and Software
,
86
(8), 2184-2195.
Date, C. J., & Date, C. J. (2019). Denormalization.
Database Design and Relational Theory: Normal Forms and All That Jazz
, 161-182.
Sanders, G. L., & Shin, S. (2001, January). Denormalization effects on the performance of RDBMS. In
Proceedings of the 34th Annual Hawaii International Conference on System Sciences
(pp. 9-pp). IEEE.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help