Unit 5 Discussion Topic 1

Discussion Introduction/Overview

The following Discussion topics relate to your readings in Unit 5 and experiences you may have had in the areas of modifying database structure and using NULL in databases. To successfully complete the Discussions, you must respond to the base question with an initial Discussion post no later than Saturday of each week and then reply to at least two other responses on different days before week end. See the Discussion rubric for questions on requirements.

Topic 1: Altering a table structure

What happens to data when you alter the table structure?

When altering table structure, you need to consider what changes this can make to your data. If you make a change that causes the data to become invalid, the data will be deleted. You can add to your table, changes sizes, and fields, but you must be careful to keep from losing data.

Hello Andrew,

Nice post this week. Having the ability to alter the database is great. I bets having to rebuild it completely every time something changes. However caution has to apply. What if you drop a column that was a foreign key, this will affect other tables.

Hello Andrew.

I agree whole-heartedly when you explain that one should take heed to the changes data goes through when changing anything in the table. We must pay close attention when editing tables as they are structured to use data in a certain way. Any changes made to the tables could cause data loss or data corruption if the data is not configured properly. While you are able to edit and customize nearly everything about your tables, you should remember the data that is being used by the table as well. Happy Learning!

Good Evening Class and Dr. B,

That is so true you need to know the changes to your data. It is good that you can add and change your data in the columns. What happens when you add and delete or change data? Great post this week thank you

Powered by TCPDF (www.tcpdf.org)