Analyze the data and determine functional dependencies

Assignment Help Other Subject
Reference no: EM132388544

Assignment Instructions:

Use the attached Excel spreadsheet to complete the Midterm project. You will need to analyze the data in the spreadsheet and determine functional dependencies. Show your work at each step of 1NF, 2NF, 3NF/BCNF. Also, give a brief explanation of how you broke down each normalization. Once the relations are in BCNF, create a detailed ERD.

After you have your detailed ERD, define the input screens and show the mapping to the fields. Below are 3 Reports. You are to map which fields from which tables are needed in order to create the report.

Report 1 List of Classes by semester and in which building they are taught.

Report 2 List of Classes and which Instructor teaches it.

Report 3 List of Students and their grades.

Attachment:- Midterm Project.rar

Reference no: EM132388544

Questions Cloud

Find the equation of the regression line for the data : Find the equation of the regression line for the given data. The construct a scatter plot of the data and draw the regression line.
Estimate the mean cholesterol levels of patients : You wish to estimate the mean cholesterol levels of patients two days after they had a heart attack. To estimate the mean, you collect data from
What is the difference between pearson and spearman : What is the difference between Pearson and Spearman correlation and when would be a better time to use one vs. the other?
What is the expected number of stations : If 100 stations are in use, what is the expected number of stations that will detect an enemy plane?
Analyze the data and determine functional dependencies : Use the attached Excel spreadsheet to complete the Midterm project. You will need to analyze the data in the spreadsheet and determine functional dependencies
200425 Economics Assignment Problem : 200425 Economics Assignment help and solution, Western Sydney University - Assessment help - explain why you think GDP may still be considered a useful measure
What is the probability that exactly 41 businesses respond : (a) What is the probability that exactly 41 businesses respond? (b) What is the probability that the response rate is at most 0.24?
Null hypotheses and research hypotheses : For each of the following examples state the null hypothesis and the research hypothesis, in words:
Advantages and disadvantages of paired sample t-test : What are the advantages and disadvantages of paired sample t-test and non-paired sample t-test?

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd