Public relations

Social media plan for Riyadh city
The results demonstrate that most retweeted messages are the more likely to contain a direct Tweeting, Retweeting, Hashtag, Phototwitter, Photo Facebook, Photo Instagram, Photo website, Photoflyer, Website, Video, and Broken links. These results will be the basis for crafting the social media plan. The type of interaction can work with influencers and amplifiers within an industry. Twitter can be used as a predominant place for amplification. It presents an opportunity for Riyadh city to create tweets that generate engagement.

Objectives
The objective of the social media plan will be to establish strategic and beneficial relationships with the amplifiers to improve engagement on Twitter. Amplifiers are significant in keeping the conversation flowing and enhancing interactions with conventional online mainstream media and corporate media. Establishing a relationship with amplifiers is likely to have more people interacting with the city.

Goals
The goal of the social media plan is to promote engagement with the public. Using various tools including Photo website, videos, Photo Instagram, Photo flyer, the PR team will attract more retweets from social media amplifiers. The tools will provide an excellent opportunity for followers to get to know the individuals behind the brand.

Strategies

The first strategy to be used is finding a niche of Twitter Followers. The social media plan will be directed to social media amplifiers. Amplifiers are important in keeping the conversation flowing and promoting interactions with conventional online mainstream media and corporate media. On Twitter, the focus on amplifiers will ensure that the conversation flows. Amplifiers will be useful in determining what to retweet and what not to retweet. Thus, they will be useful in enhancing engagement of Twitter users. Determining who to follow and how to get followers is a difficult task. When Twitter users start using Twitter, most might follow anyone who might follow back for no particular reason. To increase the number of Twitter followers is the goal of any organization which can act as an ego boost. However, unless the followers are quality followers, the large number of followers won’t fuel the initiative to increase Twitter exposure. Niche or quality of followers means having followers with similar interests as the city and individuals who also tweet similar topics as the city. In general, the followers are more prone to retweet city’s messages to their Twitter following. Given that the quality of followers will be more inclined to retweeting the city’s links, amplifiers will expose the tweets to a much larger audience.

The second strategy is through engaging amplifiers and influencers through valuable and relevant Content. Social networking is all about sharing valuable information and content. Amplifiers are only interested in relevant and valuable content. The city requires relevant and quality tweets and how they will be distributed. More time will be spend thinking about the levers necessary to generate actual engagement and step up interaction with messaging and content. Influencers are individuals who carry weight in industry. Twitter is considered to be one of the most suitable social networks for networking, and it can reach out to many influencers who have a Twitter account. Retweeting influencers with valuable content is one of the easy ways to connect with influencers and tap into their group of followers. This can be done by Tweeting the same content several times. Identical tweets often obtain a similar amount of clicks. Creating relevant content and focusing on getting influencers to engage with it can make it go viral incredibly fast as more people can discover content through organic and social search. However, it all comes down to the quality of the content being shared. If it is of interests, influencers are going to retweet (Safko, 2010).

Tactics
Direct Tweeting and Retweeting
Tweeting and Retweeting are critical to maximizing tweet exposure. The PR team will employ tweeting and retweet tactics to promote engagement by influencers. Tweeting and Retweeting are not about sharing content. There is evidence to show that there are things that compel people to retweet. From the choice of words to the time of day, tweeting and retweeting will take into consideration different factors that impact how many retweets can be achieved. When a tweet is made, a message is sent out to social media followers. When none of the followers are actually interested in the message, then very few will retweet the messages as it isn’t really relevant to them. On the other hand, when there are a dozen followers who are interested in the message, there is a greater chance that they will retweet the tweet. Therefore, tweeting and retweeting exposes a message to followers also might be interested. Another way to have the frequent retweeting of messages is to be active in retweeting messages from influencers when the message relates to the topic. Influencers and followers are likely to appreciate the retweet and tend to retweet some of the tweets in return.

Hashtag
The second tactic is the use of hashtags. A hashtag is a way that enables organization of Tweets for Twitter search engines. Using hashtags correctly simply prefix messages tag to enable influencers and followers to discover relevant posts. Using hashtags is critical for maximizing retweets and finding those quality Twitter followers. When one searches for certain keywords, it becomes easier to view other Twitter results of users who also tweet the particular topic. Those users using the same hashtags will be followed as they can become the niche followers.

Photos and videos
Twitter has several features that provide users with more options and opportunity when it comes to Twitter images. Multiple Photos in Tweets will be used to Photo Tagging. Every Tweet will include multiple Twitter images, offering the users more opportunities to use visuals that represent the message. Photos will be added to Tweets and will then be displayed in an easily shareable preview collage. New photo tagging option will allow tagging in the Twitter images shared. This will have a big implication for the city to followers and fans. Individuals can then tag other users in the photos, adding a level of appreciation for followers. This may encourage more engagement on Twitter. To really make the Tweets engaging, the photos will not be just an afterthought. Twitter images will be chosen based on their relevance and appeal to the content and shareability. Images will not be shared just for the sake of having a visual element to your Tweet.

Finding photos to share does not have to be a struggle. One way to improve engagement through images will be to ask for submissions or run contests from followers. Sharing photos will be a great way to keep influencers and followers engaged and coming back. When using photos, it will be important to ensure that images will be clear when viewed within a Twitter stream. When photos are too small and require to be expanded by the viewer, they may likely receive less sharing and engagement. Additionally, sharing the same content in multiple Tweets is a tactic that is appropriate as long as messages are spaced out. However, sharing the same photo possibly may not draw the same level of engagement in second and third Tweets. When the content to be shared has multiple images, different Twitter images for subsequent Tweets will be shared. This will be a strategic way to add new appeal to content to be reused. Favoriting is a tactic that will focus on making use of growing interaction with influencers and amplifiers. Building authority on Twitter is important to generating more engagement, and the utilization of multimedia like images can drive that engagement. By including photos and images in tweets, it will be likely to double the chances of a Retweets. Videos will be important when trying to connect on a personal level with amplifiers. These tools offer a simple way to respond to the audience and are far more engaging than a simple tweet would be. Videos will also be used to cover events as they’re happening. Videos drum up more interactivity by involving followers in the big numbers. A large number of followers will likely enhance the chances of retweeting.

Favoriting
Favorites will be used to bookmark. Favoriting is an easier way of saving tweets and pages for easier future access. The most common use of favorites is to capture the attention of those they are interested in capturing. It is a desirable option to make presence noticed online. This type of interaction can work with influencers and amplifiers within a particular industry. Many are the times that it may be necessary to type out a response to tweeter user. This may not be possible particularly where the number of responses is overwhelming. Thus, favoriting will be used as a tactic to show gratitude. Favoriting will be used as a tool to engage with influencers and amplifiers.

Database Creation

Questions
For a database administrator, describe the importance of database alerts

The alerts are very important to the database administrator because they help them get information regarding the events that may diversely impact the database in one way or another. They help the database administrator to respond to the issues as quickly as possible before any damage can take place (Basta & Zgola, 2011). Alerts come from all the internal errors, block corruption errors and deadlock errors that may be disastrous to the database. So the alerts help the database administrator to respond to them promptly before the effect of the error can escalate.

Describe the importance of reviewing the database logs to determine errors
At the heart of many devices that offer protection for the information technology, networks is an ability to log the events and actions so that remediation actions can be taken as appropriate (Horwath, 2012). The database logs errors to help the database administrator to review them and take any appropriate responses as per the error. It is essential for the database administrator to review the database error logs to determine the error so that he/she can take defensive measures before any real damage occurs (Murphy, 2015). Without the review of those database logs, the database administrator has little chances of knowing whether a live application has been compromised or is being attacked.

Compare the advantages of using a Database creation tool or using a script to create a database

Creating a database using a database creation tool or a script has many advantages, for instance, one can use the DBCA wizards to get direction in the selection of options offering an easy means of creation and tailoring of the database (Oracle Corporation, 2002). The database creator only supplies a minimum of input, and the tool makes decisions for them, eliminating the need to spend much time in deciding how to set parameters or how best to structure the database. The use of a tool also helps the database creator to be very specific concerning the file allocations and settings. The database creation using a script helps to decide the services required at the start.

Describe the basic database administrator responsibilities
The database administrator responsibilities revolve around three major activities: maintenance of the production database; planning, designing and making changes to the existing applications; and the management of a company’s data and the metadata (Connolly & Carolyn, 2004). The database administrator should also create policies and procedures regarding the database management, security, and the use of the database. A database administrator should also carry out general technical troubleshooting as he/she also provides consultation to the development teams (Blaha, 2001).

Describe Oracle tablespace (default tablespace, Bigfile, Smallville)

Oracle tablespace are the logical units in Oracle database that are used to store the entire database’s data. Each of those logical units/tablespaces consists of one or more data files that are physical structures that are specific to the operating system that Oracle database is running in. There are Bigfile tablespace and small file tablespace whereby the Bigfile tablespace comprises of a single datafile or a single temp file and the small file tablespace consists of several temp file of data files that can amount up to 1022 (Powell, 2007). A Bigfile tablespace comprises of a repository of if all the information in a single file whereas the small file tablespace has the same information contained in several files.

Describe the benefit of the Oracle client/server architecture

The client applications do not have to perform any data processing. Those applications only concentrate on the input requests from users or the server and then analyzing that data appropriately so that they can present it through display capabilities of the client node Luz, T. (1990).
The client/server architecture helps Oracle RDMS to exploit the multitasking as well as the shared memory facilities of the underlying operating system. Consequently, that offers the highest degree of data integrity, concurrency, and performance to the clients.
In this architecture, it is possible to optimize the terminals or client workstations for the presentation of data while the server can also be optimized to process and store data.
In the case of networked environments, the shared data can have placement on the servers instead of the workstations so that it will be easier and efficient to manage its concurrent access.

Orientation and Training

Iteration 1: Orientation and Training
Student Name
Course
Instructor
Date

Plan

My internship program at Kronsys Inc was purposely for acquiring the skills and experience of being an expert as an SQL programmer and developer. I began my program with the orientation to the company and training of the SQL Webpage development process aspects. The actions of the process were developed through the following several tires of primarily familiarizing me to the company SQL Web Application developers along with the overall Kronsys Inc management. The second division of the orientation and training process was the familiarization with the aspects of SQL Webpage development process. In this case, I had to develop a detailed program of reviewing the tutorials, guidebooks, and journals in preparation for the training. The training preparation is the basis for establishing the ground of easily capturing and understanding what entails in project development and overall SQL Webpage development process.

To facilitate the individual training preparations I made some consultations to the company SQL web Application Developer professional for the guidance on how I was to go about the process. The third tier of the program was to hold a meeting with the project manager and the SQL and PL/SQL administrators for the understanding of the skills desirable for an SQL Programmer and Web Application developer. The last tier was the training on the different aspects of SQL Webpage development process along with the best understanding of different phases of project development life cycle. The internship program was scheduled to take the duration of two weeks. The activities within the orientation and training phase of the project will be undertaken in a sequential manner to ensure that the deliverables are much helpful to my future career of being an SQL programmer and Web developer expert.

Action

As a new attachee within the Kronsys Inc, I made pre-visit to the company before the reporting day to have the easy understating of the physical organization and location of the different departments of the organization. I made a visit as an ordinary guest and got to have the knowledge of the terrain of the company. On reporting, I begun with the introduction to the company SQL Web Application developing staff. The process was essential for the creation of the relationship that will allow the teamwork during my overall activities that I undertook at the company. The familiarization process was done by the movement from one office to the other. The knowing of each other gave me the courage now to begin on the program by developing a schedule of how I was to understand the aspects of SQL Web Application development process. I collected the relevant materials relating to the concept. The materials I majored in were the journals and the textbooks alongside the online studying. This was the preparation for the training of the SQL Web Application development concepts.

I studied the concepts under the guidance of the SQL Web Application development professional whom I made regular consultations. The consultation was to provide the way forward in the areas that I was too special and take much focus. The actions were the roots of understanding the principles of SQL Web Application development process during the training. After the individual training, I held a meeting that was described as the meeting of company governing and operational policies principles and procedures. The project manager defined and elaborated the governance of the company to secure the right direction for me. The following actions were holding meetings as the project manager takes me through the training of the SQL Web Application development process and overall project development process phases.

Observation
Orientation carries its weight when it comes to new staffs within an organization. I deliberately made the company pre-visit because I wanted to take the shortest time possible for the orientation program. The pre-visit gave me the understanding of the strategic company organization. The design and location of the company were done professional since it is organized just by the mode of viewing. Orientation creates a motive of working as a team, in all cases teamwork has been the foundation of a company maintain productivity and improving on the same. At the same time, the quality of the products and services gets to grow as the employees work as a team (Mattson, 2015). The Kronsys Inc employees were welcoming, and they showed me the hospitality that I have never had before. They were all willing to work with and give the directions in all activities I was to perform. It was encouraging at that point.

As preparation mechanism to the training that I was to undergo before the other related activities, I took a step of familiarizing myself with the concepts of SQL Web Application development process. The materials opened my mind, and I captured the necessary information about the SQL Web Application development process and project development process phases. This knowledge got my training program successful as I stood to understand the ideas. The focus of the project manager was about the agile software development technology that we described as the technique that he does always apply in developing and implementing his projects. At that time, I was able to have an understanding of the skills that an SQL programmer and developer must possess. Some of the skills that I noted as the critical included the knowledge in Microsoft SQL server side developing that include the SSIS, SSRS, and SSMS. Others were the T-SQL stored procedures and the triggers, administrative database experience, and the.NET development experience (Conte & Cravitz, 2000).

Reflection
Descriptively, orientation process can only be enjoyed if the place of work is conducive in any case. The orientation program was done accordingly though there was an assumption that I know the location of some of the offices, meeting places and other relevant places. This came in mind that indeed it was a great idea to make pre-visit to the Company as it provided direction to what I was expected to undertake. The idea made the orientation process successful that I was taking to imagine (Arthur, 2012). The management of any project is under the leadership of project managers, and the project manager stands to make sure that all the personnel he applies in the project are productive. The principle was a necessity that I was too through training that indeed provided the clear understanding of the SQL Web Application development process concepts and an overall project development process phases. The training as well was successful by the fact that I had done through pre-training preparation of consulting about what is expected as an SQL programmer and developer.

At this point, I had acquired the necessary and required knowledge that I was to apply to the remaining part of the program. To have the practical workings, I had to acquire an SQL developer application that I was to apply in creating the database objects. Therefore, there was the necessity of installing the SQL developer.