The paper "Database Design" is a brilliant example of a term paper on information technology.
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).
The function of the data dictionary in database design
A 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 & foreign keys, descriptions, and cardinalities
- Domain constraints and data domain definitions
- Any supplementary information regarding the design, planned use, and administration of the database
- Information regarding user accessibility; the way the user has the right to access and modify the database.
Factors important in a DBMS software selection
According 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