Characteristics of a good database design

Characteristics of a good entropybase number1. IntroductionThe purpose of this report is to mainly argue about characteristics of a good database radiation pattern and a role design. Main reasons behind writing this report is as part of implementation of Stanwell parish plan the motive for a database application was set by several committees.Our committee is responsible for the design a database for record the runners participated on the annual Fell race. The new wideband internet access facility is helpful in creating these new facilities.A database can be identified as a set of records or files which be logically related. Computer based databases atomic number 18 normally organised as one or multiple number of tables. A table consists of series of rows and columns. relative model is a powerful and commonly used method for organising data. The table design of the database reflects the quality of the database.The principles of normalization need to be considered always when aim a effective database. Objectives of normalization ar follows.Minimising data redundancyMinimising data restructuringMinimising I/O by redesign transaction sizesEnforcing referencing integrity.When designing an effective database following techniques and concepts are important to consider.Identifying an entity as a logical collection of items related to the stated database. And an attri savee is a descriptive or quantitative characteristic of the entity.The physical twin of the entity is a database table and the physical counterpart of the attribute is the column.Primary key is identified as an attribute which identifies each instance of an entity uniquely.The logical link among two entities is the relationship.When the primary key of a parent entity exists in a child entity, it is called as a foreign key.There are two types of relationships, Identifying and non Identifying. Identifying relationships are when primary key of the parent entity exists in the primary key of the child entity. In non identifying relationships primary key of the parent key exists in the child entity but not as a part of primary key of the child entity.To understand the nature of the relationship betwixt the parent and child entities, cardinality is helpful. Four types of cardinalities are 1 to 0 or more 1 to 1 or more 1 to 0 or 1 1 to manyIn designing a tame database ER, EER and Use Case are really useful modelling tools.2. Importance of data modellingData model is a very useful tool in communicating between developers and users of a database. It is also helpful in identifying design issues and other problems before starting the factual design bring. A data model is like a blueprint of a newly constructing building. Builders will newer start building a great(p) look without a proper blueprint. Even though changes are do during the developing process, the basic foundation remains the same.Importance of ER diagrams in the designER diagrams falls into a category of data m odelling.ER diagrams show entities in a database and relationships between tables. This graphical representation helps to understand how the database works with the interactions and dataflow. No matter how large or small the database is, the concepts of entity and relationship are the same.ER diagrams have 3 basic components.EntitiesAttributesRelationshipsFor an example, in the Fell Race database, Race can be identified as an entity and year of the Race can be identified as an attribute. An entity corresponds to a table of the database and attributes corresponds to the columns of that particular table.Most common errors that can happen when designing an ER diagram can be stated as,Missing constrainsMissing keys to any entity typeUnexpressed constrains due to bad designAssociating attributes with wrong immersion typesPutting invalid constrainsMisuse of subclassesUsing foreign keys instead of relationshipsEER Diagrams in modellingEER diagrams are also a similar kind of tool to ER dia grams except for some little differences. It is identified as enhanced model of ER diagrams.EER = ER + hierarchical relationships Hierarchical relationship means relationship between Super class and subclass, the IS A relationship.The next step is transferring the ER diagram or EER diagram into well structured relations. A relational table is made up of one or more data tables or relations. The mapping should be done in a way to avoid data duplication. This is called data redundancy.Data redundancy can become a problem for several reasons.Entering same data over and over again is a moulder of time.Data redundancy increases the probability of occurring errorsErrors can occur when retrieving data.Disk space is wasted.Affect the performance of the overall outlineWhen updating, deleting data, multiple rows should be considered.Normalization is the process used to avoid data redundancy.Importance of Use Case diagrams in the designUse cases are used in the analysis stage of the design p rocess. Main target of drawing a use case is to identify the system of rules functionality. Use cases separate the system into use cases and actors.Use cases represent the integrating of actors and the system. An actor is defined as a thing with behaviour. An actor could be a person or another system.According to the Fell Race system actor can be someone who uses the system to enter data (user).3. Importance of a good database designMainly a good, effective database design helps the ontogenesis team to reduce the addresss and time taken for the overall development. By creating a good data model and following the correct process, helps the development team to understand user requirements clearly and accurately.4. Is a correct database design necessarily a quality design?The answer is no. A correct database design is not always a quality design. But a quality design should always be a correct design.In a quality design, instead of putting data over multiple files, data is stored in a single logical unit. This reduces the duplication of data. The non duplication of data helps to discover data integrity. Also a quality design is helpful in maintain the security of data. Data can be managed properly trough a quality database design. Finally a quality design is a design that helps to increase the performance of the database. A correct database design would work, but a quality design will help increase the performance of the database.5. ConclusionAn affective and quality database design helps the development team to reduce time and the overall cost of the system development process. By taking a correct approach to database design helps the team to understand the user requirements correctly and deliver a system the user desires. A good database design will also help increase the overall performance of the system.ReferencesMike gahan.2000.An introduction to databases.online(updated 10 October 2000) Available at http// web.ucl.ac.uk/archaeology/cisp/database/manual/ node1.html Accessed 10 January 2010.SQLTeam.com.2000.Database design and modelling fundamentals.online(updated 30 June 2000) Available at http//www.sqlteam.com/article/database-design-and-modeling-fundamentals Accessed 10 January 2010.Farrkoh Alemi.2007.healthcare databases.online(updated 27 November 2007) Available at http//gunston.gmu.edu/709/DataModelingERDiagram.asp Accessed 12 January 2010 development cycles.2004.Entity Relationship Modeling-Experience vs InExperience.online(updated 05 April 2004) Available at http//www.devarticles.com/c/a/Development-Cycles/Entity-Relationship-Modeling/13/ Accessed 12 January 2010Veda c storey. Modelling quality requirements in conceptual database design.e-book Available at http//web.mit.edu/tdqm/www/tdqmpub/QEROct98.pdf Accessed 12 January 2010John A. Hoxmeier.1997.A framework for accessing database quality.onlineAvailable at http//osm7.cs.byu.edu/ER97/workshop4/jh.html Accessed 12 January 2010