Database Design Example

Database Design Example Database Design – Term Paper Example Business rules and their importance to Designers Business Rules are employed in the system design process in order to define: Attributes Entities Relationships Constraints It is important to keep the business rules straightforward, easy to comprehend so that could be easily understood by different individuals. Business rules should always be in writing and they must be updated. Business rules are important to designers since they allow the creator to develop rules for relationship participation as well as constraints and also to create an accurate data model. They also help the creators to know and understand business processes, nature and scope of the data. They are a tool of communication between the users and the creators, and they also prove helpful in standardizing the organization’s view of the data (Jesdisciple, 2010). Function of data dictionary in database designA data dictionary is the warehouse of all maintenance and design information that is needed for a database. It contains all the documentation and specification and serves as a reference guidebook of a particular database (Allentech, 2010).These particulars should be included in a data dictionary:Entity Relationship diagram, Logical data model or notes.Definitions of entity and attribute definitions, data domain, data type, descriptions.Relationships of entities, primary the way the user has the right to access and modify the database. Factors important in a DBMS software selectionAccording to Whitehorn (2010) the process of selection of DBMS depends on the following critical factors: Project size Technical competency of the DBMS The number of concurrent users of the DBMS References:Allentech (2010). Datadictionary. Retrieved February 5, 2011, from http://allentech.net/vbc/ddict.phtmlJesdisciple (2010). Business Rules. Retrieved February 4, 2011, from http://databasemanagement.wikia.com/wiki/Business_RulesWhitehorn, M. (2010). Tips for choosing a DBMS to meet your companys needs. Retriev ed February 4, 2011, from http://searchdatamanagement.techtarget.com/answer/Tips-for-choosing-a-DBMS-to-meet-your-companys-needs