morihe.icu

Companies are involved in different operations that result in the generation of information. The information is never discarded rather it should be kept for the future references. The question to ask is how to keep the data. The database concept came previously with the usage of the file database until we came to settle on the sequential databases. The primary databases are the SQL databases and the Oracle databases that do perform the same job but with the application of different principles in the implementation of the functionalities. A database is described as the collection of related data that is organized and stored at a collective place for easily accessing, management and administration of the data.

History of databases and SQL
Database came in to ensure that the data stored can be retrieved or shared amongst the users without the know that there is sharing. In 1970, Dr. Codd published a paper “A Relational Model of Data for Large Shared Data Banks” that was the building block of the relational database system. He described a new structure for data within the database that brought the relational database system that is still in use up to current (Sumathi & Esakkirajan, 2007). On the other side, Chamberlin and Boyce (employees at IBM Corporation, Inc) developed a query language they referred to as Specifying Queries As Relational Expressions (SQUARE). The language did apply the set theory a predicate mathematics to have the select of data from the database. SQUARE acted as the building block for another language (Instructional Software Research and Development Group., 2006).

In 1974, Chamberlin and Boyce refined the SQUARE language to publish the Structured English Query Language (SEQUEL). The refinement focused on the data retrieval from the database, and they had taken the focus to applying the top-down programming that required the linear notation, and readable programs which are easy to modify and maintain. The result of the implemented got the description of the SEQUEL as structured (Chamberlin & Boyce, 1974). In 1979, SQL got into its existence by dropping the vowels EUE, the SEQUEL was found out to be a registered mark trade for Hawker Siddeley Aircraft Company that forced IBM to change the SEQUEL to SQL.

SQL Architectural framework
The architecture of Pl/SQL describes its working with the Oracle. The PL/SQL block is made up procedural and SQL statements as it describes how the SQL in Oracle interprets the PL/SQL block. The PL/SQL architecture contains the block, engine, and the Oracle server. The engine is concerned with the compiling and executing the SQL block, and the PL/SQL engine contains the PL/SQL procedural statement executor that executes the procedural statements. On the other side, the Oracle server contains the SQL statement executor that executes the SQL statement (Rosenzweig & Silvestrova, 2004). Therefore, the PL/SQL engine is in coordination with the Oracle Server for purposes of processing the block.

According to Instructional Software Research and Development Group (2006), SQL statements can be classified either;

Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Data Control Language (DCL)
Data Administration Statements (DAS)
Transaction Control Statements (TCS)
Features of SQL

Structured Query Language (SQL) has got developed and meets the ANSI and the ISO standards as a computer language that can use in creation and manipulation of hierarchical databases. SQL has the capability of allowing the proficient user to undertake some administration activities such as create some views, update, delete records and retrieve the data from the database. It is very simple and easy for one to learn because it is sequential and structured in nature and it is to work with some other desirable database programs such as MS Access, and Sybase (Groff & Weinberg, n.d).

SQL database, the SQL Server 2005 and SQL Server 2008, have the data mining architecture that enabled the models to enhance business intelligence. Business intelligence components can easily get integrated into SQL server that includes the On-line analytical processing (OLAP), SQL Server Integration Services (SSIS) and the reporting services (Crat, Tang & MacLennan, 2013). SQL has been on developed and currently exhibit some attractive, unique features of supporting character sets, collations, and translations. A transaction can roll back on save points. The database language supports Boolean data type and large objects of binary and the character LOBs (Kreines, 2000).

Benefits of SQL
SQL does not require navigational instructions as it is coded without embedded data that simplifies the retrieval of data.
The applications applying the SQL are portable as well as the language gives a high level of abstraction, and its internal implementation makes it independent.
SQL is simple to learn and easily handle complex situations at the same time the language has no ambiguity about the way a query interprets the data.
The SQL is used in definition of the data structure; control the accessibility of data, delete, insertion and modification of data
Proposal

Iteration 1: Orientation
The orientation program captured my attention by familiarizing me to a few identities. I first had to sign the internship acceptance form from the Human Resource department after which I am to be directed to my designated department. Within the working point, I will introduce myself to the work mates and move around to have the familiarization of the company strategic location. I will visit the specified departments starting with the operational section from where I will have to understand the company core business operations, procedures, principles and the goals to achieve. The working conditions will also be provided to avoid the misrepresentation at working point.

Iteration 2: Understanding the SQL concepts
After the understanding of the company operations and my expectations, I will take some critical time to have the deep understanding of the SQL concepts. Databases go by experience and understanding of what the requirements are according to the company procedures. During the iteration, I will make some consultation from my working mates so that I take to know where I need to take the concentration of understanding. Secondly, I will undertake some online research to have the deep experience of coding and the most critical operations of the SQL. The model accordance to the Model will be under study. The personal studying will further involve the data analytics and the understanding of the big data. The iteration will be the preparation for the training that I will be taken through by the assigned supervisor. At the end of the iteration, I would have sharpened my knowledge and have the best theoretical understanding of SQL as far as the database is concerned.

Iteration 3: Training
The training will go through the application of the SQL and the implementation of the Oracle databases. The training will be conducted primarily to have the clear, practical understanding of the Oracle database and the SQL database. Define the principles of the application modes of the databases. The training will be conducted through the labs of the company where normal staff training and seminars take place. The process will be the preparation of the primary object of designing a database exercising gall the database administration and maintenance. Therefore, by the end of the training session, I would have gained the practical skills and experience of database administration.

Iteration 4: SQL Database designing
The iteration will get me through the steps prior designing and development of a database. First, I will have to undertake some feasibility so that I may be able to define the requirements of the company and the end users to be adhered to during the SQL database development. After then the designing of the application will take its course by applying primarily all the knowledge of SQL database to have the database that meets the determined requirements after that the last iteration will follow.

Iteration 5: SQL database administration and management

The iteration is the other critical activity that I will be involved. The primary expectations are ensuring that the database is up to date the demands of the end users are accomplished. During the process I will be updating the database, deleting some entries. Furthermore, create the views procedures and the queries as well as reports and more so enhance the security within the database. Actually, at the end of it all, I would have got the best knowledge than ever that will get me into the market with the desirable experience and skills.

Alzheimer’s disease is a progressive mental disease that occurs due to the degeneration of the brain. It can manifest itself in the middle and old age thus causing premature senility. An interest in the disease arises from the fact that the condition affects a person’s cognitive ability. It raises the curiosity of how the brain changes to the extent that a healthy a functioning brain ends up damaged and almost non-functioning. A person that was once healthy and active may have Alzheimer’s disease, resulting in a loss of general body functioning. The cause of Alzheimer’s disease remains unknown although the early onset of the disease is associated with a genetic mutation. The late occurrence of Alzheimer’s disease, however, occurs due to a combination of genetic, environmental and lifestyle factors. People with APOE?4, have an increased of early onset of Alzheimer’s disease although people without the gene can also acquire the condition (Villemagne, & Ames, 2013).

Moreover, persons with Down syndrome have an increased risk of Alzheimer’s disease because of the existence of the extra chromosome 21 with the gene that produces the harmful amyloid. Conditions such as heart problems, diabetes, and high blood pressure have also been associated with a decline in cognitive functioning that increases the risk of Alzheimer’s disease. According to Qui & Strauss (2009), approximately 25 million people are affected by Alzheimer’s disease. In the Europe, the age-standardized prevalence in 65+ is 64% for dementia and 4.4% for Alzheimer’s disease. In America, the prevalence of Alzheimer’s disease in individuals over 70 years is 9.7%. The number of people who have Alzheimer’s disease is anticipated to double in the next twenty years.

The first symptom for persons with Alzheimer’s disease is a cognitive impairment that begins to manifest through memory loss. The memory loss may not be immediate, but the individual may start by demonstrating increased forgetfulness and repetition of statements. The mild cognitive impairment may be difficult to detect, but as the condition progresses, it becomes obvious. The individual may demonstrate complete memory loss; he may wander and get the loss (Jack, 2013). The individual may also take longer to perform tasks that he used to take a short duration to complete. In the severest form of the condition, the individual loses the ability to communicate and may not recognize family members.

The symptoms begin and vary with the changes that the brain is experiencing. Alzheimer’s disease is progressive thus the damage to the brain can begin decades before the symptoms begin to show. The brain begins to have abnormal deposits of amyloid plaques and tau tangles (Selkoe, & Hardy, 2016). The result is the healthy neurons stop functioning and lose connections with each other. Damage first begins at the hippocampus, the part responsible for formation of memory. The damage to the hippocampus marks the indicator of the first sign of Alzheimer’s disease, memory loss.

The diagnosis of Alzheimer’s disease involves a variety of test, examination and a look at the individual history. A physician may also perform a variety of tests to measure the patients, memory, problem-solving abilities, and language capacity. Laboratory tests such as urine and blood tests may be performed to eliminate other diseases that may manifest similar symptoms. Moreover, a CT, MRI, and PET test may be performed to rule out other possible causes of symptoms. Conditions such as stroke, brain tumors, and Parkinson’s diseases can expose an individual to symptoms such as those of Alzheimer’s disease.

There is no single intervention that is suitable for the management of Alzheimer’s disease. A patient may require a diversity of drugs and intervention to manage the condition (Liu & Shen, 2014). Currently, the emphasis is on helping patients maintain their mental function, manage their behavioral symptoms, and slow down the progression of the disease. There have been intensive studies to develop therapies that target the genetic, molecular and cellular mechanism of the disease. Medication such as donepezil, rivastigmine, and memantine are given to manage mild to severe Alzheimer’s. The drugs work by regulating the neurotransmitters, maintain thinking, memory and the patient’s communication skills. The medication does not work for all patients, while for others it may work for a while before they no longer do.

Unlike factors such as age and genetics that may be uncontrolled about the occurrence of Alzheimer’s disease, lifestyle and health factors can be controlled. Exercise and physical activity can ensure a healthy brain as the activities encourage the formation of blood vessels through the brain. Moreover, exercise and physical activity increase the number of connections between nerve cells thus ensuring a healthy brain. Exercise stimulates the brain thus keeping it healthy and less prone to degeneration. Scientists have also discovered that a healthy diet that is rich in vegetables reduces the rate of cognitive decline (Norton, & Brayne, 2014). Foods containing imega-3 fatty acids such as salmons and fish also reduce the occurrence of beta-amyloid plaques in the brain. Moreover, the engagement in mentally stimulating activities such as reading and engaging is sports activities reduce the risk of Alzheimer’s disease.