Question

In: Computer Science

Using the module discussion forum, work with your fellow students to identify any other database benefits...

Using the module discussion forum, work with your fellow students to identify any other database benefits you can think of, as say compared to a spreadsheet or basic file storage.

Solutions

Expert Solution

Dear User,
Database as well as Spreadsheet both stores the data in a tabular format and designed to store, manipulate, and retrieve information.
Still the database has several advantages over a spreadsheet.
1. Most databases are relational, so that data between tables can be linked and cross-referenced using primary key and foreign key.
2. The spreadsheet is good for numerical as well as textual data, but the database also can easily incorporate Images and documents.
3. the spreadsheet has the limitation of 10,00000 row limitation while database does not have any such limitation so it can handle huge amount of data efficiently.
4. In the database, it's easy to update the data in bulk.
5. integrity is the most important difference in between Spreadsheet and database, databases follows standardized integrity rules, each column has a specific data type which does not allow to enter value of other data types also we can restrict the value of a column using constraints like check and unique.
6. Here in a database all the tables are interlinked hence it avoids the data redundancy while spreadsheet can have multiple duplicate records.
7. in terms of security and accessibility. the database is far better than the spreadsheet as multiple users can insert, update, select and delete the records of the database also access to database objects can be restricted using the permissions.
8. it is very easy to take a backup and restore the whole database.

if we compare database with file system, still database has several advantages.
1. Data of database can be shared easily as it acts like a centralized system while it's a very complex process in file systems.
2. In a file system, if more than one user is updating the data there are chances of data loss while it is not the case with database.
3. Retrieving the data from database is easy as compare to file system.
4. There is no comparison in between database and file system in terms of data integrity.

Thank You !


Related Solutions

Identify 5 benefits of using a Database management systems
Identify 5 benefits of using a Database management systems
Discussion Forum Module 9 Research a disorder pertaining to the integumentary system. Summarize the disorder using...
Discussion Forum Module 9 Research a disorder pertaining to the integumentary system. Summarize the disorder using medical terms and post it in the discussion.
Discussion Forum - Benefits In the Human Resources field, as a means of demonstrating value to...
Discussion Forum - Benefits In the Human Resources field, as a means of demonstrating value to employees, companies, both small and large engage in offering employee benefits in addition to compensation. In this interactivity, you are the HR consultant to a small business with about 40 employees. The owner has asked you to prepare a listing of the top three mandatory benefits the employer must provide, and a strategy for figuring out what non-mandatory benefits the employer should also offer,...
For the discussion forum please relate your experience level, if any, regarding Six Sigma. If you...
For the discussion forum please relate your experience level, if any, regarding Six Sigma. If you have not had any Six Sigma experience, present a situation at your work or in school that could benefit from a Six Sigma program.
In this discussion, you will be creating your own application problems that your fellow classmates will...
In this discussion, you will be creating your own application problems that your fellow classmates will solve using systems of linear equations. Let’s first look at an example. When creating an application problem, it is helpful to begin with the solution to the problem. So, for example, if you start with the solutions (a rectangular garden with width = 8 ft, length = 10 ft), then you must find two ways these quantities relate to each other and give this...
Using the same MNC and host country as you did in your previous discussion forum, create...
Using the same MNC and host country as you did in your previous discussion forum, create a PESTLE analysis of the host country. Restate the host country, industry, and company name in your initial post. The PESTLE should be a visual such as a table or a chart with a 100- to 200-word analysis. Support your answer with at least one credible, recent source in addition to the course textbook.
Complete the Module 6 Discussion Forum In November 24, 2014, Netflix filed a lawsuit against its...
Complete the Module 6 Discussion Forum In November 24, 2014, Netflix filed a lawsuit against its former vice president of IT operations, Mike Kail, alleging fraud, breach of fiduciary duties, and other charges. Here is an excerpt from the lawsuit filing in Superior Court of the State of California, Santa Clara County:. “…During his tenure at Netflix, including as Netflix’s Vice President of Information Technology Operations, Kail was a trusted senior-level Netflix employee.  Kail’s job responsibilities at Netflix included negotiating and...
Suppose that you are assigned to work with a group of your fellow students on a term project. Draft a team charter that will guide your work, use the template already made.
Suppose that you are assigned to work with a group of your fellow students on a term project. Draft a team charter that will guide your work, use the template already made. CharterFocusPurpose Goal of the Team Duration and time committment Scope Members involved End Goal Supporting resources Reporting Deliverables Organizational approaches
Specify the benefits (if any) of using visuals aids or other support to deliver a speech....
Specify the benefits (if any) of using visuals aids or other support to deliver a speech. Many experts in public speaking discuss the importance of ‘word choices’, when preparing a speech. What is your understanding of this concept? Give at least one example. Provide an example of a public speaking situation or event you have been exposed to or watched and give your impressions (positive, negative, or mixed opinions):            
This week's graded discussion forum requires students to demonstrate their understanding of market interest rates and...
This week's graded discussion forum requires students to demonstrate their understanding of market interest rates and the impact of interest rates on marketable securities. Marketable securities include low-interest return investments such as money market deposits and certificate of deposits, debt securities (bonds) with fixed coupon rate but fluctuating yields, and equity investments. To prepare for this assignment, students are to study the chapter readings and conduct additional research to prepare a short analysis posting of 400 words (min). See the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT