Solution-State the functional dependencies in this table

State the functional dependencies in this table

Assignment Help Management Information Sys

Reference no: EM131109731

The figure below shows a table called GRADE REPORT for a university.

StudentID	Student_ Name	Campus_ Address	Major	CourseID	Course_ Title	Instructor_ Name	Instructor_ Office	Grade
16830045	Williams	208 Brooks	IS	IS 350	Database Mgt	Codd	B 104	A
				IS 465	Sys. Analysis	Parsons	B 317	B
54329107	Baker	104 Philips	Acctg	IS 350	Database Mgt	Codd	B 104	C
				Acct 201	Fund Acctg	Milier	H 310	B
				Mkgt 300	Intro Mktg	Bennett	B212	A

Assume that students can take multiple courses and has only one major; also assume that one course is taught by one professor.

1) Describe deletion, update, and insertion problems for this table.

2) In what normal form is this table?

3) State the functional dependencies in this table.

4) Then decompose this table into 3NF.

Reference no: EM131109731

Questions Cloud

Calculate the steam consumption : The specific heat of the feed solution is 3.77 J/g_OC, and the latent heat of vaporization of the solution may be taken equal to that of water. Radiation losses may be neglected.

Initial submission of your dissertation premise : Attn: I looking for a worthy scholarly prospectus out of this tentative premise but first to help me revise this premise based on the feed back from my instructor, as attached I am very open to any changes to the tentative premise that can in turn..

Why did not fighting men just stop fighting : Given the often terrible experiences that fighting men experienced in the Great War, why didn't they just stop fighting? (there will be multiple answers, some based on psychology and sociology.

Directors-and thus a representative of its shareholders : Let's say that you're a member of Boeing's board of directors-and thus a representative of its shareholders. Boeing's stock price stood at $60 at the beginning of 2009 (down from a high of $105 a little more than year earlier).

State the functional dependencies in this table : Assume that students can take multiple courses and has only one major; also assume that one course is taught by one professor. Describe deletion, update, and insertion problems for this table. In what normal form is this table?

Find the velocity as a function of time : Find the velocity as a function of time using differential equations.

Understanding of the principles of catholic social thought : Create a landing page for a wiki about the topics of 'self' and 'community'. Demonstrate your understanding of the principles of Catholic Social Thought (CST) in relation to 'self' and 'community'.

The major challenges facing the global managerial worker : 2. What are the two major reasons you would want to become a manager or would not like to become a manager? (Explain fully)

Describe in detail one event in african american history : Describe in detail, one event in African American history BEFORE 1877 that had a profound effect on African Americans and history. What had profound impact you will still need to give details and descriptions with source citations.

User Account

All Pages

State the functional dependencies in this table

Reference no: EM131109731

Reference no: EM131109731

Questions Cloud

Reviews

Write a Review

Management Information Sys Questions & Answers

Information technology and the changing fabric

Case study: software-as-a-service goes mainstream

Research proposal on cloud computing

Host an e-commerce site for a small start-up company

How are internet technologies affecting the structure

Segregation of duties in the personal computing environment

Social media strategy implementation and evaluation

Problems in the personal computing environment

Role of it/is in an organisation

Perky pies

Mark the equilibrium price and quantity

Visit and analyze the company-specific web-site

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT