In: Computer Science
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?
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.