Primary Task Response: Within the Discussion Board area, write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future...

1 answer below »


Primary Task Response:Within the Discussion Board area, write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.


As you embark on the database design process, you want to make sure that all of the existing features and new requirements are built into the new database. What are the tasks and mechanisms that you can use that allow you to examine the existing system and start to transform it into the new database, and how are these mechanisms used?


When creating the new database it is critical to complete each step in the database design as completely as possible. To help with this and to make sure you do not move too fast, too soon, describe the differences between conceptual, logical and physical data modeling. Finally, you are in a somewhat unique position in that you are migrating from Access to an RDBMS of your choice. At what step is a DBMS chosen, and what is the process?


Your post should include the following details:



  • A description of the tasks and mechanisms that allow you to examine the existing system (a minimum of 3 different tools should be described)

  • A description of conceptual, logical and physical data modeling

  • A description of the process and steps in choosing a DBMS

Answered Same DayJan 14, 2021

Answer To: Primary Task Response: Within the Discussion Board area, write 400–600 words that respond to the...

Deepti answered on Jan 15 2021
137 Votes
Solution
Current system examination tools
The tools that would be helpful in examining the current
system are
· Database Structural Monitoring and Management Tool- This tool shall enable the DBA to determine, analyze and repair fragmentation and issues of space. Analyss tool shall monitor and review the database structures for storage. It will automate free space management of objects reaching maximum size, disorganized data, out-of-space issue, etc. The tool is capable of allocating additional space or defragmentation.
· Database System Monitoring and Management Tool- This tool will constantly monitor and report on the database management system’s status. DBA shall be able to set performance thresholds. The tools show thresholds and key performance metrics. Parameters can be changed through the tool’s interface. The tool shall provide information about the resource usage and recommend performance tuning suggestions. The interface shall allow DBA to manage several instances and wizards.
· SQL...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here