DBMS is necessary to create so department managers such as purchasing, operations, marketing, and personnel may be convinced DBMS is ideal. Designing a database follows a general rule of stage analysis in:Data requirementsClassification of informationRelationship between informationTransactions among data entitiesRules of identityThere are two stages in creating a database design: data and functional model. The data model is the actual data and how it is managed. The functional model decides how data is supposed to be accessed, processed, and queried. In order to design the data model, the following steps have to be followed:•Identification of data objects and relationships: this is the analytical stage and data entities are given meaning through the flow of information in the system.•Drafting initial Entity-Relationship diagram with entities and relationships: the relationships between various data entities are established and documented using ...view middle of the document...
•Adding business and integrity rules to the Model: database becomes more than a collection of data.The process of normalization in a database is important after the Entity-Relationship diagram has been designed. "The planning and analysis stage is one part that will determine how the end system will be" (Davidson 2007). The link between data entities are simplified through normalization that helps in better design for a functional model.To meet the political expectations of others it is safe to believe that users not aware of the design development are confused to how this will works and whether it would serve their needs. The proposed model is a database model interlinked using a primary key infrastructure. To convince the other managers from other departments would be to involve them in the whole data and system analysis process.End users can be shown a demonstration of a 'prototype' database where data entered by the purchasing manager pertaining to raw materials bought becomes available for the operations manager to use on the system. Once the operations manager is done and makes the appropriate entries, the marketing manager can then view how many units of a certain product are available for accepting orders from customers and meeting sales targets. The personnel managers work is interlinked since employment records will be kept and appropriate people will be assigned to different departments or projects within the organization. The operations manager will enter the amount worked by a certain employee along with the marketing manager entering how many sales targets were met by certain sales personnel. All this information will help the personnel manager in calculating salaries etc.References:Davidson, L. (2007). Ten Common Database Design Mistakes. Retrieved, May 30, 2007, from http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/The University of Texas at Austin (2004). Introduction to Data Modeling. Retrieved, May 30, 2007, from http://www.utexas.edu/its/windows/database/datamodeling/dm/design.htmlUllman, L. (2003) MySQL Database Design. Retrieved, May 30, 2007, from http://www.peachpit.com/articles/article.asp?p=30885&rl=1
