ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

9 Database Models for Writing a Strategy Statement

Updated on November 7, 2018
David Ortega profile image

Enthusiastic strategic manager skilled in budgeting, fundraising, grant writing and policy development. Master of Public Administration.

Integrating Information Technology

Integrating information technology should be a significant part of an organization's overall mission. Information systems should be incorporated into the mission and strategy statements. A specific objective might include the expansion of information technology across all work silos.

Educational institutions likely have made some of the more significant progress in incorporating information technology to increase and enhance distant learning as well as other important areas such as communication and Internet presence. Texas Tech University includes these quantifiable goals: “Create a secure wireless network to serve at least 50% of campus. Expand the number of technology-enabled classrooms by 100%. Provide 25% of all Internet services through portable devices.” A goal to increase student achievement might be accomplished by the increased use of technology.

Strategy Statement

Goal setting and mission statements are the basic foundation that helps motivate employees to achieve common objectives. There is a need to develop strategies that point team members in the right direction. Berkowitz (2011) says that, “In general, a strategy statement should contain the following elements: publics, logic, communication channel, type of medium, [and] timing.” A well written strategy supports the objectives and outcomes that the organization is striving to achieve.

Greater Profit Margin

The use of information technology (IT) by many organizations has increased dramatically over recent years. Databases help an organization store, retrieve, manipulate and print information with increased speed and accuracy. This increased efficiency helps organizations to enjoy a greater profit margin.

Murphy (2006) says that making use of information technology can help you, “Avoid duplication of effort, save you time [and] money, make you more efficient, introduce staffing economies and ultimately increase your profit.” Increasing the profit margin as well as improving staff efficiency are common goals for organizations. Are they the goals of your organization?

9 Database Models

Consider these nine database models: (1) Hierarchical, (2) Network, (3) Relational, (4) Object/Relational, (5) Object/Oriented, (6) Semi-structured, (7) Associated, (8) Entity attribute value, and (9) Context.

How might an organization go about choosing the most appropriate database type?

Sabastian's Relational Database Theory

According to Paragon (2005), “The most common kind of database used for structured applications is the relational database which is partitioned into tables.” If an organization chooses the relational database model, then designing tables will be the next step.

Sebastian (2005) says one should consider appropriate naming conventions that limit the use of, “dashes, spaces, digits and special characters.” The author notes that the designer should also, “avoid language mix-ups…use consistent table naming and give them a technical primary key.” Sebastian discusses the relational database theory and identifies ways to setup a “one-to-many relationship” structure. “You need a policy for many-to-many relationships too.”

A thorough understanding of the components of a relational database gives the designer a competitive edge.

Database Poll

Are you happy with your organization's database?

See results

Choosing a Database

It is important to consider five key components during the planning and setup phase of the database design stage. Duffy (2000) states that the components of a database plan should include, “an executive summary, implementation plan, hardware/software purchase plan and needs, staffing recommendations, training recommendations and data/information flow (where/how data moves through your agency).”

Which database you will use? Who will build the database? Who will maintain the database?

Example: Table Naming in Relational Database

Source

Designing Reports

The user might set out to design some basic forms and reports. Microsoft Office software products are very commonly used by many corporations and non-profit organizations. Simple tables can be designed in either Excel or Access. One might first choose to begin in Excel and follow the suggestions outlined above by Sebastian.

Once the tables are designed in Excel, the user can import them into Access. At this point, the names of the tables and the identification of primary keys can be modified as needed. There are built-in help features which allow a person with a basic understanding of computers to design forms with radio dials and fields with dropdown menus.

Data Modeling

Before a user is able to make any meaningful reports or forms, data modeling should be conducted. It is important because it points the designer in the right direction for setting up the appropriate tables. The business design needs to be studied and then matched with the model that is most applicable. Work silos can be identified and their relationships studied. A relational database is appropriate across many organizational structures.

Diagram Basics

A diagram helps to depict the relationships of the data being modeled. Chaple, (2011) says an entity-relationship (ER) diagram is, “A specialized graphic that illustrates the interrelationships between entities in a database. ER diagrams often use symbols to represent three different types of information. Boxes are commonly used to represent entities. Diamonds are normally used to represent relationships and ovals are used to represent attribute.”

IBM describes an entity as, “a principal data object that is of significant interest to the user. It is usually a person, place, thing, or event to be recorded in the database. If the data model were a language, entities would be nouns” (IBM, 2005). The IBM guide also discusses attributes. “Entities contain attributes, which are characteristics or modifiers, qualities, amounts, or features. An attribute is a fact or non-decomposable piece of information about an entity. Later, when you represent an entity as a table, its attributes are added to the model as new columns.”

Entity Relationship Diagram

Example
Example | Source

Recommendations

High quality information technology should be incorporated into all aspects of a given organization. IT systems should be more user-friendly. Using Microsoft Office software products might be replaced or enhanced by voice recognition systems that design an appropriate database by oral command. Databases should be complex enough to capture all relevant data yet be intuitive for the end-user.

References

Berkowitz, D. (2011). How to write a strategy statement. Retrieved online.

Chaple,M. (2011). Entity-relationship diagram. Report of the DLF Electronic Resource Management Initiative. Appendix D. Retrieved from: http://databases.about.com/cs/specificproducts/g/er.htm

Duffy, M. (2000). Avoiding disaster: The database planning process. Save money, time, and resources with a good database plan. TechSoup Global.

IBM (2005). IBM informix database design and implementation guide. IBM Informix Dynamic Server Enterprise and Workgroup Edition.

Murphy, C. (2006). Avoid duplication of effort, use technology, increase profit. The Social Programmer. Retrieved from: http://www.craigmurphy.com/blog/?p=215

Paragon Corporation. (2005). Choosing the right database (relational). Retrieved from: http://www.paragoncorporation.com/ITConsumerGuide.aspx?ArticleID=1

Sebastian, (2005). Database design guide. Smart IT Consulting Services. Retrieved from: http://www.smart-it-consulting.com/database/progress-database-design-guide/

TexasTechUniversity (2001). Information technology division: Strategic plan. Retrieved from: http://www.depts.ttu.edu/infotech/strat/it.pdf

UnixSpace (n.d.). Database models. Retrieved from: http://www.unixspace.com/context/databases.html

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)