Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

I posted this question last night and no one has answered.

/in /by

I posted this question last night and no one has answered. Can anyone

please let me know if the 1st and 6th answers are correct?
Thanks

CMIS 320 PROJECT 41) Is this relation in at least 1NF? Why or why not?Yes, it is in the first normal form, because changing the order of the data does notchange its meaning, there are no multiple values in each column, nor does it vary thesize of the columns.2) What is the primary key of the initial relation (assume the values shown arethe only possible tuples for all time)? Remember that a primary key must beunique and not null.The primary key is the tuple consisting of the name of the girl and the game, ie PK(GIRL, GAME). We chose these two attributes for the composite key because whenthey are formed into a tuple, they obtain the UNIQUE constraint with respect to theother relationships that are transient or not.3) Describe the specific data anomalies that exist we DELETE the tuplecontaining Jacqueline.When DELETE the tuple conformed by Jacqueline, we no longer have anoccurrence of a specific CATEGORY and we will not have a way of detailing howmany categories we have for the games and to add new registers to the table.
Background image of page 1
View the Answer
By applying the DELETE operation on the tuple conformed by Jacquelinespecifically we are eliminating the only occurrence of the following attributes:GAME: Visual BasicCATEGORY: Prog. LanguagesThis implies that there is no record of these two attributes in an additional standardtable containing the data.4) Draw a functional dependency diagram for the initial relation. This diagramshould agree with the primary key you selected in above.5) Based on your diagram, what normal form is the initial relation in? Why?As we mentioned in the first normal form because there are still partial dependenciesbetween attributes that are not part of the tuple for primary key, for example there isstill a partial dependence between age and age group, which must be decomposedinto new relationships when normalizing In other forms this table.
Background image of page 2

Show 

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"