-

 

Week 6 – CST– 363 Introduction to Database Systems

Summarize what you have learned this week. 

This week, I have learned how to design a database ERD more efficiently. The relationship lines can be used to show the type of relationship two entities share. The dotted lines indicate non-identifying relationships, and the solid lines indicate identifying relationships. In a non-identifying relationship, the child entity has a foreign key from the parent, but it does not make up the child’s primary key. In an identifying relationship, the foreign key is part of the primary key. In a good design, you want to keep primary keys minimal without unnecessary columns.

This week we are learning how to code a web application that uses a database. We are using JDBC which stands for Java Database Connectivity. We are using Connector/J which is the official JDBC driver for MySQL.

In order to use the database, you must first create a connection using the DriverManager.getConnection() method. You must specify a database server address, a database name, login username, and password. Connections are created in a try-block of a try-catch statement because the connection will fail if the database is not found, or the login credentials are invalid.

I also learned about the SQL Injection Attack. This is an attack that can happen when a “clever user” enters a sequence of characters like 0’ or ‘1’=’1 into a query that is constructed using string concatenation. This results in a select statement like Select * from instructor where name = ‘0’ or ‘1’ = ‘1’, which returns all rows from the table. Using a prepared statement prevents SQL injection when assigning values to placeholders.

Comments

Post a Comment

Popular posts from this blog

-
Week 4 – CST – 300 Module 4 OLI – Module 4 and 5 This week’s OLI required us to meet with our team and discuss what we have learned from this unit. It was interesting to compare what I have learned to what the rest of my team learned from their experience with the unit. The assignment included an activity called “2 Truths, 1 Lie” which required each team member to share three strengths related to our group project. Of the three strengths, two were supposed to be truths and one a lie without disclosing which were truths and which was the lie. The rest of the team had to guess which of the three was the lie. For the most part, we were all able to pick out the lie from the strengths. That activity showed me that we are becoming familiar with our team members’ strengths which will help in assigning tasks during challenging projects. The last part of the assignment consisted of answering questions from what each of us shared. Everyone of our members agreed that it is a good idea to allo...
Read more
-
  Week 5 – CST – 300 Module 5 OLI – Module 6 and 7 The OLI for this week was interesting. It helped us recognize conflict and showed us how to deal with them using different conflict strategies. Module 6 showed us a video where Kurt and Freda had a conversation which quickly escalated into a conflict. Freda was questioning the level of a platform that had been checked already. Kurt told Freda that he didn’t trust her leveling phone app. After arguing for some time, Kurt noticed that the platform was not level because there was a piece of wood underneath it. I first noticed the conflict when Kurt told Freda that he did not trust her leveling app around the 15 second mark of the video. Module 7 was challenging, here we had to use the best conflict strategy to deal with conflict based on how important the relationship is and how much do we care about the problem. An example was in the scenario where you asked Taylor, a friend of a friend for a ride to get wood because your car...
Read more
-
Week 8 – CST – 300 Module 8 OLI – Post-Test This week we had to take the post-test which was a culmination of what we have learned throughout the course. It started off with opinion questions where you had to choose whether you agreed or disagreed with the statement. I compared my answers to the pre-test answers and, although they are not graded, I believe my answers improved. From the OLI modules, I learned that you must consider everyone’s opinions and to use conflict resolution techniques when there is difference of opinions. When someone is expressing their opinion, you must use active listening and let them know you understood by repeating to them what they told you in your own words. For dealing with conflicts, you must use active listening and then formulate an assertion message to deal with the conflict.   Part 1: Review Other Team’s Final Video Projects Gigabit Goon Squad Public Video – 1.       Is the topic well covered? Yes, I bel...
Read more