Question

In: Computer Science

3. What are some issues that can arise when importing data from an outside source into...

3. What are some issues that can arise when importing data from an outside

source into a DBMS? What are some tools or ways to resolve these issues?

4. Why do tables have to be related in Access for queries to work correctly?

5. What are the benefits and drawbacks for using a DBMS vs. a spreadsheet

to store data?

Solutions

Expert Solution

Question 3. What are some issues that can arise when importing data from an outside

source into a DBMS? What are some tools or ways to resolve these issues?

Answer: - There will be multiple issues arises while accessing or importing data from outside source into our DBMS like:

1. The format will not be the same as our DBMS format.

2. The number of fields will not match with our DBMS.

3. The size of data would be more than our DBMS volume.

4. There may be some security issues that can come.

5. There may be some encrypted data in the outside source that DBMS can not read or access.

Below are some tools or ways to resolve these issues: -

1. Always use query to access the data into DBMS.

2. You can use SQL to read or access the data into DBMS.

3. There are multiple ways or tools that are available in the market you can use to import the data into your DBMS like Microsoft access, Oracle, IBM DB2, MS SQL , FoxPro, MySQL etc.

Question 4. Why do tables have to be related in Access for queries to work correctly?

Answer : - Yes, Tables have to related in Access for queries to work correctly because it creates the relationship between multiple tables for access the data that will reflect in our result like if we define a field in our query but that field is not present is the table then it will give us dump or it will not work.

If the data is related in access for queries the it will quickly fetch the data into DBMS and make it easier for read/write or change the data into our system.

Question 5. What are the benefits and drawbacks for using a DBMS vs. a spreadsheet to store data?

Answer: - Benefits: -

1. DBMS can organizes data into fields and records but spreadsheet stores data in a grid of rows and columns allowing for calculations and the generation of graphs.

2. DBMS performs on Data Quality check means database allows for certain variables to be set as the only possible entries but in Spreadsheets allow value categories such as numbers, but not the customization of the database.

3. DBMS by default allows data from multiple source to be integrates into one database bit in spreadsheet it requires other applications or custom program to allow this feature.

4. Efficiency for database is more easier rather than spreadsheet

Drawbacks: -

1. Cost is higher for DBMS rather than using spreadsheet.

2. If you want your data public then Spreadsheet is more easier rather than DBMS.

3. In DBMS it requires expert for maintaining the data but in spreadsheet it does not require any technical expert.

4. If you does not have huge data then spreadsheet is more profitable.



Related Solutions

What are some ethical issues that can arise when dealing with data?
What are some ethical issues that can arise when dealing with data?
Identify some of the ethical issues that arise when artificial insemination is used.
Identify some of the ethical issues that arise when artificial insemination is used.
When comparing the GDP of different countries, two issues immediately arise. What are these issues and...
When comparing the GDP of different countries, two issues immediately arise. What are these issues and how does one account for these while comparing the GDP for different countries? Provide examples and explain your answer.
What are some of the issues or problems that arise because of GMO's? (Ethical, or environmental,).
What are some of the issues or problems that arise because of GMO's? (Ethical, or environmental,).
What are some of the issues that arise as a result of new global business opportunities...
What are some of the issues that arise as a result of new global business opportunities and how can businesses be more prepared to address such issues? Please do not be overly brief or generic
1) What are some of the ethical issues that could arise with the development and use...
1) What are some of the ethical issues that could arise with the development and use of CRISPR? 2) How much responsibility (if any) should the designer of CRISPR take with regard to anticipating and addressing these ethical issues.
Discuss some communication challenges that can arise when dealing with stakeholder expectations of a project. What...
Discuss some communication challenges that can arise when dealing with stakeholder expectations of a project. What is the purpose of a project communications plan?
"What does it mean for God to be omnipotent? What possible issues arise when trying to...
"What does it mean for God to be omnipotent? What possible issues arise when trying to make sense of God's omnipotence? Do you think that it is necessary for God to be omnipotent in order to be God? Why or why not?"
What unique issues arise when a government, as opposed to a business, is declared bankrupt? Will...
What unique issues arise when a government, as opposed to a business, is declared bankrupt? Will the Coronavirus bankrupt local governments, and how?
A Corporation with a BYOD policy is very concerned about issues that may arise from data...
A Corporation with a BYOD policy is very concerned about issues that may arise from data ownership. The corporation is investigating a new MDM solution and has gathered the following requirements as part of the requirements Gathering phase: each device must be issued a secure token of trust from the corporate pki all corporate applications and local that I must be able to be deleted from essential console cloud storage and backup application must be restricted from the device devices...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT