Data Modeling and Normalization

The Wikipedia article on data modeling was a little hard to get through. I understood it better when I read the article Data Modeling: Finding the Perfect Fit and it talked about entities more clearly. Then it really helped when I read about the ERD. The UACBT-VTC MySQL videos were helpful too. I didn’t get everything about the ERD though. I understood the crow’s feet and the O. But when it started getting into lines and dashes, I got a little confused. The Entity Relationship Diagram Example was helpful, but I was still confused some. I just need to practice.

For normalization, the UACBT-VTC MySQL videos were pretty easy to understand. But when I got to the Wikipedia article, I had no clue what it was talking about. The University of Texas page on normalization was a little confusing, but I started to understand it better. Then the Database Normalization Pt 1 and Database Normalization Pt 2 were really helpful. Part 1 summarized the benefits right away and talked about the primary key right away, instead of waiting until later to say how important it was. It made it seem simple, but maybe that’s because I had already read several things by then. The Three Normal Forms tutorial was a little hard to look at. I had to scroll up and down to see the spreadsheet and then read about it. It is nice that it is provided as a pdf. I saved it and might print it in order to read it better. But I liked that it showed a real spreadsheet. That was helpful.

I think I need to reread some articles and I think that something like this really takes experience to understand completely. I understood somewhat because of working with Access and trying to create a database. It’s hard work and a lot of thinking and planning. Data modeling and normalization helped me to understand why it’s so hard and why it’s important to really plan the database out well before creating it.

Week 9 Readings

"Technoplans vs. Technolust" by Michael Stephens was a good article. It made a technology plan simple to understand. I liked how it talked about who should be involved - "administrators, IT personnel, reference librarians, and others, including those who interact with patrons and understand what they want." I was happy that he added those who interact with patrons and that he mentioned that communication is important for staff buy in. Staff seem to be overlooked a lot when decisions are made even though they really know the customers well.

Another good article was "What went wrong? Unsuccessful information technology projects" by Brenda Whittaker. It was helpful in understanding why technology plans failed. It really made a lot of sense and made it clear for me why some projects that happened in my work place failed.

"Life is what happens to you when you’re making other plans" by Michael Shuyler was in interesting article. He seemed to think that technology plans were not that helpful and were needed for others and not for those who write them. I liked how he mentioned that they should be flexible and gave an example with things that really happened to him.

"Information technology plans" by Robert Dugan was a really good article. It explained well the process for writing a technology plan. It talks about how it can be a guide for many different things such as identifying weaknesses and strengths concerning technology implementations, letting everyone know what the library is doing, to manage a budget, among many other things. It talked about how information technology plans can be structured three different ways in academic libraries. Where I work, it is part of the strategic plan. It also talked about how to write a plan and what sections are recommended to be included. I think that this article is really helpful.

Demo system update

My demo system is running fine. I completed all of the week 8 assignments successfully. I had a problem pinging my demo until I figured out that I didn't have the ethernet cord plugged in. It was really cool learning how to connect remotely and creating a webpage.

XML Tutorials

The 3M tutorial was fine. It was like the HTML one. Seems simple, but boring to look at and the screen is too busy. I went through the XML schema tutorial too. I had to read that one at least three times before I understood it somewhat. It makes sense why one would make a schema.

The UACBT videos were pretty good. The parts where he just did PowerPoint was pretty boring to watch. The parts where he showed how to right XML made a lot of sense. He explained things well and clearly. He really made the difference between and the uses for HTML and XML clear.

Demo system status

I have successfully installed the server on my demo system, selected an IP address for it, and installed and set up everything that I did before with my virtual machine server. The only problem that I had was the ping to it from my main machine. It worked with the IP address and with the server name (even though it wasn't supposed to with the name I think) until I added it to my HOSTS file.

HTML Tutorials

I took HTML basics at my job a few years ago and I only ever used them to post in a blog where if you wanted to use HTML, you had to do it yourself with tags. I only ever used it when I wanted to insert links or pictures, so all I ever used were those tags plus paragraph, bold, italics, and break. The w3schools tutorial was easy to use, although it was boring to look at. It was organized well with the list of topics on the side, which made it easy to navigate through and to pick and choose. It was also nice that it gave links to examples and that you could edit them and then see what it would look like with your edits. It was a helpful tutorial over all. I didn't go much into the advanced part. I had enough to try just with tables, lists, and frames and figuring out the attributes for different tags.

I also like the mcli tutorial. It required that you do the exercises along with it, which was helpful because it made me do it. It wasn't organized as well as the w3schools tutorial. Also, it had some things in the advanced section that were in the basic section of the w3schools. Overall, I think it helped me going through the exercises.