Database Modeling, System Design, And Improve Performance

with information it requires to join the information in the tables together as needed, helps support

A database administration framework (DBMS) is a PC programming application that connects with the client, different applications, and the database itself to catch and dissect information. A universally useful DBMS is intended to permit the definition, creation, questioning, upgrade, and organization of databases.

There are several important steps to consider when designing a database, as a well-designed database should be deployed and not only support the accuracy and integrity of business information but also avoid redundant data and assist with has enterprise level reporting tasked. If we analyze the

“The practice of keeping data protected from corruption and unauthorized access” is known as data security (SpamLaw, 2011). The focal point of data security is the protection of

Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • • University policies: You must be logged into the student website to view this document. Instructor policies: This

Relational database contains data records that do not have a preset of relationships, permitting the user to define his or her relationship when accessing the data. Since users have much control over the data being accessed, relational databases can perform a variety of tasks. Such as defining the database; querying the database; adding, editing, and deleting data from the database; modifying the structure of the database; securing data from public access; communicating within the network; and exporting and importing data (Murthy, 2008).

What is a database? According to our book, it’s an organized collection of logically related data. The information collected in a database can be effortlessly administered and accessed. However, with each database there is a concern of security. According to our book, the goal of database security is to protect and prevent data from unintentional or deliberate threats to its integrity and accessibility. The database environment has grown more complex, with distributed databases located on client/server architectures and personal computers as well as mainframes. Access to data has become more open through the Internet and corporate intranets and from mobile computing devices. As a result, managing data security has become more difficult and time-consuming.

If the finance department wanted to find the total compensation paid to each employee in the same month as the first query a slightly different query would be run to generate that information. The first code simply pulled the information and did not include and computation because the finance department only requested to be able to determine as in pull up the record for employee’s commission paid. The second code will include computation which will divide the yearly salary by twelve months then multiples the commission rate by the total amount of product sold and lastly add those two numbers together to get the total compensation for that month. Unfortunately the coding that I am using is not generating a proper result. However, it should look something like this:

This paper has been compiled as the final project for the course: Boston University, MET CS 674 – Database Security. This paper contains all relevant material which aligns with the mission of this course – to teach students the tools and techniques required to secure and audit a database system in the information technology era.

SQL Injection is one of the main database attack mechanisms used by hackers to loot organization 's data from databases. Hacker target the application layer program and takes advantage of the improper coding methods to inject SQL command into a web form and then gain access to the database. SQL injection may adversely affect the integrity of the database and may reveal sensitive data of the organization. The intensity of the SQL injection attack vary depend on the capabilities of the backend database in use. With the help of SQL injection hacker can change existing queries, attach additional queries, read in or write to file or execute operating system command from the database. To protect organization data from SQL injection we need to apply security measures in the application layer and in the database layer. The purpose of this study is to analyze the database functionalities/security holes, mainly Oracle and MySQL, and propose the preventive measures database developers need to consider in the database layer while working with these databases to secure data from SQL injection.

Connolly and Carolyn (2004) define a database as a structureordesign that consists of theclient’s data as well as metadata. It is also a persistent, logicallycoherentrepository of inherentlymeaningful data that is relevant to someaspects of therealworld. The database consists of data organized in a systematicway, anditallowseasy retrieval of information, analysis, updating andoutput of data. Thatdata can be in theform of graphics, scripts, reports, text, tables, andsoon. Most of thecomputerapplications are databases at their core. Manycompaniesusuallyhave a lot of data, andsotheyhavebig databases that can handlethatlargeamount of data. It is wherenothe database administratorcomes into playtopensurepropermanagement of the database sothatthe organizational data is safe from anyintrudersor data corruption (Jones, 2014). The database is whatcontrolsthedata of theentireorganization, andany tampering of the databases can culminate to the stoppage of businessoperations.

The protection of the database from unauthorized users is the maintenance of database security. This controls come in the form of user names and passwords to identify people who have the authority to use the database. The accessibility of an authorized person can be limited by the operation types such as retrieval, insert, update, delete. For instance, the DBA has access to all the data in the database, a branch manager may have access to all data that relates to his or her branch office and a sales assistant may have right to access with related to properties but no access to sensitive data such as staff salary details.

Every part of the given task will incorporate abridging every section of the book named Database Security, 1st Edition, Alfred Basta; Melissa Zgola,Copyright 2012, Cengage Technology on data security which will offer us some assistance with building a manual for arrangements and methodology for keeping the database secured. The center of this task will be on section one which worries about security of data frameworks. The target of this paper is to make report in view of the discoveries online and how it relates with the substance said in the book. Looking into how national trade data model aides in database security is something which will likewise be talked about in this paper. This task gives true experience of really building a manual which can be useful amid emergency, moreover it will likewise offer us some assistance with applying abilities and demonstrate ways how progression in innovation can have a colossal effect.

With advances in technology constantly happening, it can be hard to keep up with all of the latest trends. If organizations cannot keep up with the latest trends, it can lead to flaws in their security. Any flaws in security can have a detrimental effect on an organization’s database. Almost every organization has some sort of database, whether it is for maintaining customers, inventory, or vital information.

Integrity constrains provide a way of ensuring that data are entered or updated in a database by authorized users do not result in a loss of data quality. Integrity constrains could either be a specification of uniqueness for values of column (for example, only allowing the input of “M” for male or “F” for female in the gender field) or validation for values of a column (for example, allowing only a specified range of values for a field that records a patient’s temperature. Integrity Constrains Referential integrity is another strategy that is used to ensure data quality in relational databases. Referential integrity ensures that there is consistency between tables that are linked in the relational database. HIM professionals are frequently involved in helping to develop integrity constraints in a database. Database Management Systems Database management systems (DBMSs) fail into two categories: a personal DBMS, which runs on a client; and a server-based DBMS, which runs on a server. Personal DBMS A personal DBMS is used for small projects such as storing contact information (for example, in a personal address book). It should not be used for systems that require large amounts of storage and 24/7 access. Database Management Systems Most healthcare systems would not use a personal DBMS. Personal DBMSs are tempting to use because (1) they are inexpensive and (2) most people already have access to one with an office software package such as Microsoft Office. Microsoft Access