Dbms

A entropybase , simply speaking , is a collection of info maintained according to a pre-defined structure . It deals as the mother wit of any organisation and requires a lot of research and analytic thinking before it can be created . Database design falls under(a) the design phase of the systems development life cycle and indeed follows directly later the analysis phase . Once the informational need and flow of the system have been finalized , a infobase is designed property in mind the needs of the system and the way it allow for support the system at the back end p Databases more or less follow a usual rule of design in most cases The preliminary comprise is of analysis of the existing environment where the system will master in to determineData requirementsClassification of informationRelationship between informationTransactions among data entitiesRules of identityOnce this is done , database design accordingly travel into the design coif There atomic number 18 deuce aspects to database design , the data model and the functional model . The data model is the actual data and how it is managed . The functional model on the other hand decides how this data is supposed to be accessed , graceful , queried etc . In to design the data model , the following steps have to be followed , taken from the Information Technology run page of the University of Austin (2004Identification of data objects and relationships : this part is analyzed in the analysis stage and data entities be given pith through the flow of information in the systemDrafting the initial ER plat with entities and relationships : here the relationships between various data entities ar established and documented using an Entity-Relationship drawRefining the ER diagram : this ER diagram is further refined by removing ambiguities , repetitions , etcAdd key attributes to the diagram : in continuation of the previous step the ER diagram is further enhanced along with incorporating key attributes of data entities (class diagrams .

These attributes are what will set each entity apart from the other and serve as identifiersAdding non-key attributes : non-key attributes are extras and may also be repeated in various entitiesDiagramming Generalization Hierarchies : here , the diagram is reason out with hierarchies in terms of security and data relativity are setValidating the model through normalization : the database is normalized so as to rid of any discrepancies and logical ambiguities when transactions are conducted between data entities . Many normal forms exist , which one to decide upon depends but on the requirements of the systemAdding business and integrity rules to the Model : this is where the database becomes more than rightful(prenominal) a collection of data . It becomes meaningful and useful at this stage once the business perspective is put inAmong these steps , normalization of a database is the most important step after the ER diagram has been designed . The planning and analysis stage is one part that will determine how the end system will be (Davidson 2007 . This is because keys and relationships between data entities are change through normalization which then...If you want to get a full moon essay, order it on our website: Orderessay

If you want to get a full essay, wisit our page: write my essay .