How you can change the above table into 2nf

Assignment Help Computer Engineering

Reference no: EM132144435

Question :

Suppose you want to store the following information:

Student_id	Course	Mark
111	Maths	78
111	Physics	90
222	Biology	89
333	Physics	60
333	Chemistry	75

1.a Is this table in first normal form? Why or Why Not?

1.b Why it is not in 2NF? How you can change the above table into 2NF.

Reference no: EM132144435

Questions Cloud

Deposit in his individual retirement : Your client wants to save $500,000 for his retirement. He plans to retire in 20 years. How much must he deposit in his individual retirement

Which of the following characterizes a market order : i. Which of the following characterizes a market order? a) A market order, which is considered a small order, is when 100 shares of a stock are ordered

How that the real data is transferred from the main memory : With neat sketch, explain and show how that the real data is transferred from the main memory to the MBR.

Explain the factors that went into your decision : Disc jockeys must also be able to change playlists when they areused because what is actually played is often different from what isplanned.

How you can change the above table into 2nf : Is this table in first normal form? Why or Why Not? Why it is not in 2NF? How you can change the above table into 2NF.

What speed-up do you get with 10 versus 100 processors : Calculate the speedups assuming the matrices grow to 100 by 100. Which are strong scaling and which are weak scaling in this exercise?

Identify at least three possible use cases and actors : Create a state transition diagram that describes typical customer states and how they change based on specific actions and events.

Draw an fdd that shows the personal trainers main functions : The BumbleBee program stores basic member information, but does not include information about member preferences, activities, and history.

What is price of stock : What's is price of this stock? using Constant dividend model

User Account

All Pages