SQL Lab Report

The mole is a convenient unit for analyzing chemical reactions. Avogadro’s number is equal to the mole. The mass of a mole of any compound or element is the mass in grams that corresponds to the molecular formula, also known as the atomic mass. In this experiment, you will observe the reaction of iron nails with a solution of copper (II) chloride and determine the number of moles involved in the reaction. You will determine the number of moles of copper produced in the reaction of iron and copper (II) chloride, determine the number of moles of iron used up in the reaction of iron and copper (II) chloride, determine the ratio of moles of iron to moles of copper, and determine the number of atoms and formula units involved in

Identify the different types of entities, attributes, keys and relationships you will want to consider when designing the database.

* Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

Read the textbook. Do research on databases. All answers should be analytical, using IGEA and MLA. Please use own words/original thought, not regurgitation of facts. This is the expectation all year.

1.4 For the tables you created in Review Question 1.3, what are the primary keys of each table? Do you think that any of these primary keys could be surrogate keys?

This week was a little harder comparing to last; well it is expected because we are getting more into how to create a more dependable database. The topics for this week were “The problem of redundancy, Decompositions, Functional Dependencies and normal forms. We learned how to recognize and avoid the problem redundancy in database along with how to convert database schema into first, second, third normal forms.

Hence, this session has enhanced my understanding about normalization and how essential to create a data that is well organized with the relationships clearly defined and established between the tables (based on the business rules) in order to eliminate data redundancy and inconsistency.

Database interface's SQL editor provides an easy and efficient way to write and test scripts and queries. And its powerful data grid provides an easy way to view and edit data related to any DBMS/RDBMS tools.

Q1. List six major steps that you would take in setting up a database for a particular enterprise.

This week assignment was really fun because it actually addressed some programming. During this week's reading I learned some new programming concepts I did not know and I acquired a better understanding on some others I get used to apply in the practice but I did not known in theory.

By filling the database with test data, we can begin to determine if the tables are normalized correctly, need changes to the keys and foreign keys, or new bridge tables are needed to correctly output the data. It is also at this point that we test to ensure that data types match and all entities are of the proper format.

This week was not too bad in regards to any of the work I actually needed to do. There are definitely some concepts that I think I need to improve my understanding but I think that I did take away what was available from the texts we were provided.

12) Summarize the personal/professional growth that has occurred over this semester by describing what you understood about yourself and professional self-development at the beginning of the course, what you learned throughout the course, and where you are now.

Reflect upon what you consider the most interesting thing you have learned in this class so far?

This week’s assignment was the most challenging part for me. I assume this was to be expected but I went into it thinking that I knew exactly, from the text, how to achieve the goals of the assignment. I was wrong. As a result, I needed read more about how to appropriately join multiple tables. Once I figured out how to properly do that, I wanted to make the query work off of the current date automatically instead of having to manually enter it each time, as days go by. I was able to find some functions that worked in the Open Office DBMS to perform this but was again annoyed to find the wide variety of functions for various SQL DBMS that didn’t work.