Question 4
Consider relational schema along with the functional dependencies given below:
gaming (gamename, gametype, amount, playerno, playername, playertype, discount, duration)
playerno -> playername, playertype, discount
gamename ->gametype, duration, amount
playertype -> discount
How many tables will result when the relation is in 3NF?
3
1
2
4
Answers
Answer:
Y hc ic hi viw is ix uw y cs wis v I C DC b you've bi huh cctv b is ji is no in dry can I e Iran dB b is to cry 7am cry tu Roark cyanide Skywalker t g all velcro b crispy Dani cr7
Answer:- The relation schema along with the functional dependencies is:- gamename ->gametype, duration, amount.
Number of tables will result when the relation is in 3NF are 3.
A functional dependency is a new type of the constraint between the two written attributes.
For example if we say that there is a relation with the attribute A and B, then by this we mean that there is a functional dependency between A and B.
Relation schema is defined as the design and the structure of the relationship like it consists of the relation name or the column names. There are four types of relation schema.
3NF is the third step in Normalization. The table is said to be in 3NF only when it has a relation in 2NF and it also has no Transitive Functional Dependency on any other function.
To know more about the given topic please go through the following
Link1:- https://brainly.in/question/10441969?
Link2:- https://brainly.in/question/2126391?
#SPJ3