Bis245 Week 5 Lab - Er Diagram and Er Matrix/ Homework-Aid

For this assignment, you will NOT create a database.  You will list the type of data you want to collect, group it accordingly, break it into field and determine attributes.  Think about how the different pieces of data relate to one another and what purpose they serve.  You may use Excel, Word, or Visio for this assignment.

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.

This supports our hypothesis that the amplitude being adjusted doesn't effect the rate at which it swings. Now we move on to our question: Would mass be a factor? The first bob was replaced with something much smaller in weight. We returned the displacement back to 10 cms while keeping the length the same. We recorded the 10 periods and the average seems to be around the same approximate rate of 2.01. This debunks the theory of the pendulum being dependent on mass. Changing both the displacement and weight seems to not affect the rate in anyway.

2. Quantitative because the data given is concrete and generalizations like mean and mode can easily be identified.

Phase 3: Sketch the star schema for the database and developed the database based on the star schema.

Although Change Request No. 3 seems fairly simple, it will bring to light any issues that might have been encountered while interpreting the tables from the ERD Diagram. It is not uncommon for changes to be needed to the database after it has been created from the ERD. Moreover, now is the best time to catch these issues before the system is fully functioning making it much more difficult to make certain changes.

The reason why this is the way to go is that relational databases are limited in the number of relationships that can be dug down and analyzed. Using a dimensional model will allow the use of multi-dimensional cubes to be able to pull 3 or more dimensions back into a pivot table. An example would be Sales by customer service rep by assigned sales territory. This provides a deeper detail of data than you would be able to get out of a relational database. For each department of the university, I propose a Data mart for each one. The reason why this is the case is so that every department can manipulate their own data as they see fit with their own resources because it is on a different server than another data mart typically. The look and feel of the Data Mart is up to that department and does not bother the other departments Data Marts. Individual data marts can also increase response time because there are not as many people hitting them all at one time. If a new department were to pop up, data mart creation is very easy to do. Each record will be unique based on the primary or composite keys of the table, and those keys could be surrogate keys such as using AutoNumber like in Microsoft Access. Depending on the analysis of the data, it may be determined that the ID numbers between student and teacher are unique and this can be the way to link items together throughout the database. The

First our team will talk about how Microsoft Access was used to create these tables by Huffman Trucking Database. Then how we used the tables with made up information to be tested on. Then on how we used forms in the maintenance database system. While the creation of relationships and normalization is explained in the process of using queries to search the database (University of Phoenix, 2007).

2. (TCO 1) Which object would you use to retrieve customers who live in Germany and the United States? (Points : 5)

A. Lab # : BSBA BIS245A-1 B. Lab 1 of 7 : Introduction to MS Visio and MS Access C. Lab Overview--Scenario/Summary TCOs: 1. Given a business situation in which managers require information from a database, determine, analyze and classify that information so that reports can be designed to meet the requirements. 2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool. Scenario: You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a

The N2O and NO fluxes measurements were conducted in 2–28 days intervals during the growing season and 10-30 days intervals during the non-growing season and between 8:00 and 11:00 h each measuring day to minimize the effect of diurnal temperature variation. The stainless steel chamber (40 cm in diameter and 30 cm high) was used for the measurement (Toma and Hatano, 2007). Gas samples were taken from the chambers using a 50 mL syringe. The samples N2O were collected for 0; 15 and 30 minutes and for 0 and 30 minutes for NO samples. N2O was analysed using gas chromatography with ECD (GC-2014 Model, Shimadzu) and NO using NOx Analyser (265 P Model, Kimoto Electric, Osaka, Japan). Gas flux is the gradient of gas concentration in chamber over time. The cumulative gas flux was calculated by

where a plot of ΛM versus √C gives a straight line of an intercept equal (Λ0) and a slope equal to the Onsager constant. In our solutions, the following equilibria are deliberated: M+ + A− ⇆ MA

In this lab, you will prepare a Data Dictionary based on the list of elements. Also, your task will be determined the tables, their relationships, primary and foreign keys. Based on this analysis, you will create Database Schema, relational tables, Entity –Relational Diagram (ERD), establish connection to your local MySQL Server, create physical database and insert data to the tables.

A prestigious university has recently implemented a consolidation strategy that will require it to centralize their student records. In order to move forward, the local university will need to develop a data model that will retain student records and perform various data extract transform and load (ETL) processes. As the database consultant it will be necessary to assist with the development of a design strategy for student records. The following has been determined after meeting with various university subject matter experts:

A) Adjust applicant pool in such a way to ultimately enroll the students that meet your strategic goals.