Relational Databases"
ANSWER :-
Summarized the information provided in the question that "RELATION DATABASES" from the E-activity , assess the advantages and disadvantages of the continued use of the........
(A)
Relational database is a model that uses relationship data model or model where all data elements are viewed as being store intwo dimensional tablets. The relationship database has been very good way for acompany to maintain their data and efficient. However, with the increase of technologyand data grow the cloud computing was created as a option for companies. It is capableof handling more data, is more efficient, and work with data in memory that thetraditional relational database doesn’t. The disadvantage with cloud computing if you areoffline than your business is offline- a company musthave the internet working 24 hoursa day (not viable for small business), security of information being store.
A relational database is a database that is made up of several files of information that is related.The information is stored in tables of rows, which are called records, and columns, which arecalled fields.The database establishes a link between separate files with matching fields(www.dictionary.com).The advantages of this type of data base are that it is easy to use, data isonly stored once, flexible, complex queries can be carried out, better security, and cater for futurerequirements (www.teach-ict.com).Plus, it eliminates multiple record changes, creates betterstorage, and makes it easy to detect data changes (www.teach-ict.com).
A relational database is essentially a group of tables (entities) Those tables have constraints, and relationships are defined between them Relational databases are queried using SQL, and result sets are produced from queries that access data from one or more tables Multiple tables being accessed in a single query are "joined" together, typically by a criterion defined in the table relationship columns Relational databases are facilitated through Relational database management system Almost all database systems we use today are RDBMS, including those of Oracle, SQL Server, MySQL, Sybase, DB*, Teradata, and so on....
The reasons for the dominance of
relational databases are not trivial They have continually offered
the best mix of simplicity, robustness, flexibility, performance,
scalability, and patibility in managing generic data However, to
offer all of this, relational databases have to be incredibly plex
internally For example, a relatively simple SELECT statement could
have hundreds of potential query execution paths, which the
optimizer would evaluate at run time All of this is hidden to us as
users, but under the cover, RDBMS determines the "execution plan"
that best answers our requests by using things like cost base
algorithms
The disadvantage is that Even though RDBMS have provided database
users with the best mix of simplicity, robustness, flexibility,
performance, scalability, and patibility, their performance in each
of these areas is not necessarily better than that of an alternate
solution pursuing one of these benefits in isolation This has not
been much of a problem so far because the universal dominance of
RDBMS has outweighed the need to push any of boundries.
(B)
I believe that it is a good idea to let all of your clients know how you are storing theirpersonal information; whether it is ethical or not, it is just a good rule of thumb.If I was aclient I would like to know that my personal information was stored in a secure system; if itwas not secure then I would not be doing business with this company.Now if the client wasunder the impression that their personal information was safe in a secure system and thenthey found out that it was not through phone calls from solicitors then I would believe theywould be extremely upset and would definitely want all of their information taken out of their system and the company would probably lose a client because of it.Not to mentionthey would tell their friends.
...............................................................xxxxxx.................................................................................
I STRUGGLED A LOT TO COLLECT THIS ANSWER AS PER YOUR REQUIREMENT SO PLEASE----PLEASE KINDLY UP VOTE IT HELPS ME A LOT THANK YOU IN ADVANCE
Relational Databases" From the e-Activity, assess the advantages and disadvantages of the continued use of the...
You have to present three thoughtful responses to what other students wrote to the two questions below. You should not say I agree or not agree only. You have to explain your response. You have up to 100 words for each response. 1. What are the most three important things you have learned from the paper. Please explain. 2. As a CIO of a healthcare provider (e.g., Henry Ford Health System, Bauman), how would you use the digital technologies. Please...
Compensation sessionABC International: Solving the Rural BarrierSource: Thunderbird School of Global Management, A unit of the Arizona State University Knowledge Enterprise. 2015. This case was prepared by Erin Bell under the guidance and supervision of Dr. Amanda Bullough, and revised and updated by Drew Helm for the purpose of classroom discussion only, and not to indicate either effective or ineffective managementSiham sat with her family and childhood friend, Leila, in their rural village of Qabatiya, Palestine. Leila had recently returned from...
write up an essay on the problems in budgeting derived from the articles (i do Upvote the answers ) Why Budgeting Kills Your Company HBSWK Pub. Date: Aug '1 1, 2003 Why doesn't the budget process work? Read what experts say about not only changing your budgeting process, but whether your company should dispense with budgets entirely. by Loren Gary The average billion-dollar company spends as many as 25,000 person-days per year putting together the budget. If this all paid...